Thendral Jothi

· Driven Database Developer with 13 years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments.

· Efficient Database Developer with broad knowledge of high availability SQL Server solutions. Adaptable professional with background in improving workflow processes, creating database objects, and overseeing security tasks.

· Dependable ETL Developer with 10 years creating reliable and accurate data transformation tools. Well-versed in technologies such as Microsoft BI Stack. Designs ETL tools to scale overwhelming data transition tasks into manageable projects with realistic timeframes and achievable budgets.

· Diligent BI Developer with 10 years of experience performing detailed compilation and maintenance of extensive database systems to track complete BI information. Integral leader when overseeing analytics to generate critical custom business intelligence reports. Applies detail-oriented process for overseeing analytics application availability and performance, from planning through end-of-lifecycle. Crucial contributions to BI database backup, recovery, and maintenance.

· Excellent knowledge in RDBMS concepts and constructs along with Database objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

· Experience in disaster recovery, performance tuning, T-SQL query optimization and Solving Blocking issues.

· Developed ETL Packages with different data sources (SQL Server, Oracle, Flat Files, Excel Source Files, XML Files, etc.,) and loaded the data into target tables by performing different kind of transformations using SQL Server Integration Services (SSIS).

· Experience in proving Logging, Error Handling by using Event Handler and Custom Logging, Performance Tuning in SSIS Packages.

· Expert in developing Cubes using SSAS Tabular Model (SSBI). Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.

· Developed OLAP cubes by using SSAS, and defined data sources, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.

· Expertise in Creating, Managing and Deploying SSRS Reports on the portal for user accessibility and have good experience in generating Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

· Writing MDX queries to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports using SSRS.

· Having experience in DAX Functions and in developing Power BI Reports.

· Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS and Power BI.

· Created various Power BI Dashboard and reports using PBI Desktop and deployed it to the shared location.

· Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations. Extensive experience in using Microsoft BI studio products like SSIS, SSRS, SSAS for implementation of ETL methodology in data extraction, transformation, and loading.

· Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Requirement Gathering and Analysis, High Level Design, Detailed Design, Development, and Implementation Support.

· Very good exposure in Oracle 10g, 11 in writing complex queries, views, functions and procedures.

· Followed agile methodology and coordinated daily scrum meetings.

o Won “Microsoft Maestro Team Award” for deserved and excellent work in Managed Reporting at Infosys.

o Received “DW-Special Contribution to Project Excellence (SCOPE)” reward for special contribution in achieving project excellence in the DWBI&PM practice at Cognizant Technology Solutions.

o Got “Bravo Extra Miler” Award for the Involvement and the Commitment in the project at Sutherland Global Services.

o Got an “Appreciation” and “Confidence” from “Mastercard” within a short span of time

Microsoft Certified for Querying Microsoft Server 2012