SUMMARY

• Over 7 years of experience in MS Business Intelligence development/data warehousing and expert in leveraging the full stack includingSQLserver,SSRS,SSIS,SSAS, DAX, Power BI and Data Transformation Services (DTS).
• Experience in developing new databases of all areas ofSQLServer including user views, Stored procedures, functions, triggers, indexes, clustering, relational database models, data dictionaries, Backups, Recovery, common table expressions (CTEs), and data integrity.
• Experience in ETL (Extracting, Transforming and Loading) data from Flat file, Excel, Oracle, XML to MSSQLServer by usingSSISservices.
• Specialized in creating and configuringSSISsolutions for elevated performance Data Integration, Business Intelligence Process and Data Migration which consist of Merging Data from various Populating Data Warehouses, Cleaning, Data Marts, Heterogeneous Data Stores and Standardizing Data.
• Experience in handling Debugging, Error logging, Error Handling and Production support forSSIS.
• Expert in system study and testing Health Care, Banking applications developed on various technologies like QNXT,SQLServer on Windows, and SharePoint.
• Specialized in Processing QNXT Healthcare Claims (Professional & Institutional) in PORTAL with valid TPI.
• Experience in migrating and upgrading Analysis Services(SSAS).
• Expert at accessing and analyzing Dimensions and Cubes using star schema to achieve the productivity ofSQLserver.
• Intense ability in generating drill through reports, drill down reports, handling parameterized reports and creating sophisticated report layouts inSSRS.
• Expert in providing Enterprise Reporting solutions using Crystal Reports, Performance Point Server,SSRS, SharePoint Services.
• Experience in using Data Analysis Expressions (DAX) functions for the Reports and for the Tabular Models.
• Developed and designed newSSASTabular models in memory engine.
• Specialized in Creating Power View Reports using the TabularSSASmodels in Excel.
• Expert in Different data formats used in healthcare like CCDA, CCR, X12,HL7 and NCPDP.
• Expert in using Power BI tool and prepared dashboards using Tableau to make it more attractive.
• Experience in creating reports in Power BI preview portal utilizing theSSASTabular through Analysis connector.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.SQLSSIS/SSAS/SSRS Developer

Responsibilities:

• Worked on Partition Tables based upon Partition Schemas Partition and Functions.
• Engaged in developing dashboards and Tableau visualizations using Tableau D.esktop
• Worked in Extracting, Transforming and Loading data from Flat file, Excel, Oracle, XML to MSSQLServer by usingSSISservices.
• Designed and developedSQLSSISPackages to extract data from various data sources like Access database, Excel spreadsheet, and flat files intoSQLserver 2014 for further Data Analysis and Reporting by using multiple transformations provided bySSISsuch as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• CreatedSQLserver Reports usingSSRS.
• Created Parameterized, Cascaded, Drill - down, Cross-tab and Drill-through Reports usingSSRS.
• Worked onSSRSserver to expose reports in other contexts like K2 Workspace.
• Designed tools and then import reports into K2 Workspace Report Designer.
• Created fine-tunedSSAScube.
• Worked on creating named query inSSASData Source View to get hierarchical summarize data for two dimensions.
• Engaged in detailed and advanced requirements gathering for Power BI projects and statements of work.
• Created and maintained technical writing and guidelines for Power BI Solutions and statements of work.
• Created MDX expressions to validate data in cube.
• Created and debugged data connections, data sources and Data Source Views.
• Migrated data from text files and Excel spreadsheets toSQLServer databases.
• DesignedSSASTabular models in memory engine.

Environment: MicrosoftSQLServer 2014, Visual Studio 2014, DB2, Performance Point Server, C#, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Power BI.

Confidential, NY, NY

SQLSSIS/SSRS/SSASDeveloper (MSSQL)

Responsibilities:

• Involved in designing, developing and analyzing the data warehousing applications.
• Created DTS packages for the data cleansing/transfer and transformation.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.Worked on Extracting, Transforming and Loading (ETL) data and Import, Export them by DTS package.Performed Performance Tuning inSSISpackages by using Block, Unblock and Row Transformations.
• Managed Package Configurations, Event Handling, User-defined Variables and Logging System on
• SSISPackages.
• Implemented and Designed Replication solutions forSQLServer 2008 r2/2012 using Enterprise Manager.
• DevelopedSQLServer Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
• Involved inSQLstatements, queries, triggers and stored procedures.
• Performed modifications on the present stored procedures to meet recent design.
• Created indexed views, and appropriate indexes to cut the complex query time.
• Provided day-to-day administration tasks like space and log management.
• Developed Recovery Strategies, Backup and Disaster Recovery Plan.
• Involved in Creating Cascaded, Cross-tab, Parameterized, Drill-through and Drill-down Reports.
• Involved in creating Dashboard Reports to support end users usingSSAS.
• Upgraded and migratedSSAS.
• Worked on Database, database tuning, performance planning, backup planning and database administration.
• Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.

Environment: MSSQLServer 2012,SSIS,SSRS,SSAS, T-SQL, Crystal Reports 7/8, Windows 2012 Advance Server, VB.NET, MS Excel, and MS Office.

Confidential

Sr.SQLSSIS/SSRS/SSAS Developer

Responsibilities:

• Worked in writing complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQLcode andSQLjoins for applications followingSQLcode standards.
• Involved in Creating Indexes for quick retrieval of information.
• Worked on Performance tuning and Optimization of query using execution plan.
• Performed event handling adequately to generate logs and audits for the generatedSSISpackages.
• Worked on archiving and achieved automated processing of the raw data through the ETL process inSSIS.
• Experience in handling Debugging, Error logging, Error Handling and Production support forSSIS.
• Worked in system study and testing applications developed on QNXT technology.
• Performed in Processing QNXT Healthcare Claims (Professional & Institutional) in PORTAL with valid TPI.
• Involved in Maintaining and Entering providers' data like additions, updates, audits, benefit types, enrollment period and eligibility, network coverage, and terminations) in the QNXT system(s).
• Worked in Different data formats used in healthcare like CCDA, CCR, X12, HL7 and NCPDP.
• Worked in Editing reports related to provider setup (Pending Claims for provider information etc.).
• Performed store procedure function and Troubleshot member records when a flag is revealed in the process of Confirming members' eligibility during bulk loading and ensure member.
• Involved in creating logging for ETL load at task level and package level to log number of records processed by each task and each package usingSSIS.
• Created packages to convert txt files to XML files.
• Responsible for Scheduling Jobs, Maintaining, Alerting and DeployingSSISpackages.
• Developed Report Models for building Ad hoc reports using Crystal Reports.
• Experience in creating reports in Power BI preview portal utilizing theSSASTabular through Analysis connector.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Confidential, Cleveland, OH

SQL SSAS/SSRS Developer - MS SQL

Responsibilities:

• Provided Database Administration and Development of SQL server at Citigroup in support of a financial distributed.
• Replicated storage system with a multi-terabyte data store, installation of Oracle Financial accounting package, and evaluation of SQL Server 2008.
• Involved in design, development and implementation of SSIS, SSRS and SSAS.
• Developed SQL SSIS Packages to withdraw data from various data sources such as flat files, XML, and Excel into SQL server 2008 r2 using different transformations like sort, derived column and aggregate transformations.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler.
• Worked on upgrading/changing all the database objects from 2005 to make them compatible to the schema changes in 2008 r2.
• Performed restore and backup, database objects like indexes, tables, triggers, procedures, constraints and views.
• Created and configured SSIS solutions for elevated performance Data Integration, Business Intelligence Process and Data Migration.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used multiple join statements to get back the data from multiple tables.
• Created stored procedures, triggers, views, functions like user defined to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Designed and implemented parameterized reports, Drill Down, Drill Through reports for Citigroup organization through SSRS.
• Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports.
• Developed Star schema using SSAS cubes.

Environment: SQL Server 2008 R2, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), C#, XML, SSMS, MS Excel, Oracle, Toad.

Confidential

SQLServer,SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database.
• Implemented different types of constraints on tables.
• Used Try catch and @@error for exceptional handling.
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio
• Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Responsible for ETL operation usingSQLServer Integration Services (SSIS) 2008/2005 and Worked with users in and support and also have experience in incremental data loading.
• Managed up gradation of DTS packages toSSISpackages
• Responsible for developing, monitoring and deploying SSIS2008/2005 packages.
• Identified and defined Fact relationships inSSAS.
• Involved in development of ASP .NET / C# /SQLServer web application.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Installed and ConfiguredSQLServer Active /Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Implemented and successfully tested Log Shipping inSQLServer 2000 andSQLServer 2005.
• Experience using REDGATE to compare and synchronize all database objects.

Environment: SQLServer 2008/2005/2000 Enterprise Edition,SSRS,SSIS,SSAS,SQLServer 2005 Partitioning .NET Framework, C#, ASP.NET, ADO.NET, Oracle 9i/ 10g, Visio 2003, MS IIS, Windows 2000/2003 Advance Server, XML, MS Excel, Access and Visual source safe.