SUMMARY:

• 10+ years of experience in Microsoft technologies: SSIS, SSRS and TSQL.
• Well versed in MS SQL SERVER 2005/2008 R with experience in ETL (SSIS) and SSRS.
• Developed complex ETL packages using SSIS.
• Designed packages for parallel processing and configured the package using SQL server table and XML file package configuration.
• Used C# for reading the file content and inserting to the table.
• Used Script task to format the SSRS subscribed Excel reports alignment, color etc.
• Good exposure of Implementing logging and error handling in SSIS packages.
• Deploying and scheduling the packages in 2008, 2008 R2 & server.
• Implement the best practices for SSIS performance tuning and designing the performance optimized package for time bounded jobs.
• Have implemented complex query performance tuning and have fair knowledge on SQL Server Execution Plan, Profiler and Performance Counters etc.
• Creating Dynamic SSRS reporting queries using DSQL. Designing parameterized OLAP heat bubble Map reports, using SSRS 2012 integrated (SharePoint 2010 and SQL Server 2012) mode.
• Knowledge of various languages such as C#, Java, HTML, Python etc.
• Good Analytical thinking and Problem - solving skills.

SKILLS SUMMARY:

Current Domain: P&C Insurance

Programming Languages: SQL, DAX, C#, Java, Python

Operating System / ERP Version: Windows 7, Windows 10, Windows Server 2016

Tools: / DB / Packages: TSQL, SSIS, SSRS, SSAS, SSMS, PoweBI, Visual Studio 2017, Report Builder, Visio

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Responsible for the overall release success of the Business Intelligence (BI) reports and Extract Transform Load (ETL) process.
• Investigate, diagnose and provide corrective and preventive action(s) for ETL process and/or Data Integration Issues.
• Code high quality prescriptive analytical reports using Microsoft’s SQL Server Analysis Services (SSAS), Microsoft’s SQL Server Analysis Services (SSRA) platforms. The reports are needed for critical business decisions by the end user.
• Troubleshoot complex reporting system implemented on Windows platform.
• Alter and enhance complex software system version and programs. This includes identifying software configuration and upgrades to work effectively with the hardware infrastructure.
• Keep updated with latest developments in the Microsoft Business Intelligence (MSBI) and information technology by reading technical manuals, publications, case studies and white papers and implement gained knowledge.
• Produce high-quality requirements related to project and task including requirement specifications, process flows, screen/report mock-ups by using appropriate technical visual tools.
• Answer questions and clarify requirements for projects enhancement during estimation process.
• Proficient in troubleshooting database issue and experienced to solve dead lock issue, performance issues, reports and long running queries.
• Troubleshoot and reproduce issue identified in production or pre-production environments by duplicating and resolving the issue in lower environments before promoting fixes.
• Provide support for customer Production environments on daily basis. This includes modification to ETL processes, monitoring Microsoft’s SQL Server’s job subscriptions, deploying software changes and compliance reports on two-week cycles (Service Packs).

Technology & Tools: TSQL, SSIS, SSRS, SSAS, Visual Studio, Visio

Confidential

Responsibilities:

• Data/Dimensional model improvement and development for the warehouse.
• Create SSAS cube for analytical reports. These reports help client to make day today business decision.
• Developing stored procedures and functions for data integration and transformation.
• Fine tune ETL Stored Procedure as per proposed time, so that critical reports are available to end user in the morning time.
• Support the business and Hyperion system administrator to user acceptance test the Application Changes
• Create migration procedures and a verification script to move older and inefficient reports to newer improved version.
• Preparing the Unit test plan and procedures for testing purpose
• Ensure that raised issues are resolved in a timely fashion as well as ensure client needs are met in an accordance with the SLA
• Analyze client needs and software requirements to determine feasibility of design within time and cost constraints.
• Involvement in multiple proposals for technical solution.

Technology & Tools: SSIS, SSRS, SSAS, Visual Studio, C#

Confidential

Sr. Software Engineer

Responsibilities:

• Designed the Dimensional Model for Report Mart.
• Implement Dimension and Fact Load for Insurance claim data using SSIS packages.
• Schedule the night jobs to run the ETL load and report subscription.
• Incorporating the dynamic Dashboard reports based on the user selection.
• Create framework for XML based data input system, which is used into drive report layout and UI rendering format.
• Develop stored proc and function to support dynamic data processing and aggregation on SQL engine.
• Develop store procedure to handle complex multi-level commission distribution for Insurance agent and producer.
• Create the SSRS reports and used the different visual artifacts like pie, bar column chart, drill down and drill thru reports etc.
• Design SSRS reports as per the client specification.
• Use SSIS to dump the historical data periodically on separate tables in same database.

Confidential

Responsibilities:

• Migrating DTS package to SSIS and make the corrections if required.
• Writing VB.Net script, equivalent to the Active X script.
• Create the SSRS reports and used the different visual artifacts like pie, bar column chart, drill down and drill thru reports etc.
• Use DSQL to return the dynamic results based on the parameter selection.
• Design SSRS reports.
• Use SSIS to dump the historical data periodically on separate tables in same database.
• Prepare Configuration and Functional document for the project.
• Prepare test cases for all scenarios.
• Ensured accuracy of data by defining and building necessary audit and control tables.
• Deploy project to test, staging and production environment.
• Frequent verbal & written communication with client to discuss Requirements for enhancements, issues, planning and status updates.
• Maintain quality & documents relevant to issues and change requests.
• Work on Change Request as when comes.
• Providing Production support.