PROFESSIONAL SUMMARY:

• Around 8 years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Knowledge in property and Causality insurance types.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Experienced in TSQL coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2016, 2014, 2012.
• Experience with Windows Server and MS SQK Server 2016, 2014, 2012 and their Installation, Configuration and Maintenance.
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers .
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Strong  in deploying packages using SSIS from  OLTP to OLAP .
• Exposure & knowledge of designing logical & physical Data  Model in  Relational Database Management System (RDBMS). 
• Created tables with indexes,  Entity  Relationship   Model, applied constraints and referential integrity checks.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Created  MDX queries to retrieve data from the cube and also to display SSRS reports.
•   Created and Dimensional OLAP Cubes ( Star Schema and Snowflake Schema ) using SQLServer2008R2Analysis Services (SSAS) .
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS)
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS:

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Databases: SQL Server 2016,2012/2008R 2/2008/2005/2000 ,MS Access, TFS, Oracle

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Tableau, XML Publisher

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, CHARLOTTE, NC

MSBI (SSRS /SSIS/SSAS) Developer

Responsibilities:

• Worked with Technical Architect and Business analyst to design the Data vault to house data from various data sources for all reporting needs.
• Worked on creating packages like Maps, Contents that maintains history of the data.
• Implemented Star schema to design the cube.
• Developed C# scripting for packages.
• Designed the ETL processes using  Informatica to load data from Flat Files, XML Files, Excel files and used Power exchange for mainframe sources to Oracle Staging area. 
•  Involved in design and development complex  ETL mappings and stored procedures. Designed and developed  Informatica mappings for data loads, business rules development and data cleansing. 
• Restructure the existing connected intelligence tool by using Datorama .
• Extensively worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task and Transfer Logins task.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup.
• Assisting clients in utilizing Qlickview, OBIEE, Discover, Business Objects and Cognos to facilitate Client Reporting requirements 
• Developed multi-tier application using ASP.NET web forms, C#, jQuery, Bootstrap, CSS, HTML, ADO.NET and SQL Server.
•  Participated in designing of Multidimensional Modeling in  Microstrategy , regulating Star and Snowflake Schemas.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Used Extract Transform Load (ETL) software to migrate customer data from Sugar  CRM  instance to Infor  CRM  through the use of Web Services. 
•  Developed ETL packages to Load data from various sources to  SQL   server and  SQL Azure . 
• Fixing existing  Micro Strategy  Dashboards and schema objects.
• Created packages to load the Snapshot Facts.
• Built Look ML dashboards using Looker.
• Leverage BI tools, such as Looker, Excel, and SQL to design and Lead analyses.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Experience in designing stunning visualizations using  tableau software and publishing and presenting dashboards on web and desktop platforms 
• Used Microsoft Power BI Power Query to extract dada from external sources and modify data to certain format as required in Excel.
• Responsible for performance tuning of MDX queries in order to make efficient reporting performance.
• Generated Monthly, Yearly, Quartely and daily reports in Power BI.
• Worked on joining the queries and merging the tables in Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Experienced in handling SDLC full cycle methodology.
• VB.Net and SQL Reduced resource pooling time significantly (~60%) through optimized sub-querying techniques.
• Developed client applications using VB.Net and SQL Server.
• Migrated VB 6.0 to VB.Net as the existing modules functionality are developed using VB 6.0.
• Working as a production support for DB2 SQL Server databases.
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS)

Environment: ETL,SQL Server 2016,2012/2008R2/2008/2005, SSRS 2012, SSIS 2012, TFS, Visual Studio 2012, XML, XSLT, MS Office, MS Office, Visual source safe.

Confidential, Los Angeles, CA

MSBI (SSRS /SSIS/SSAS) Developer

Responsibilities:

• Worked with Technical Architect to design the vault to house data from various data sources for all reporting needs.
• Worked on creating packages like Maps, Contents and Links for the Vault.
• Implemented Star schema to design the cube.
• Design and Developed new SSAS Tabular Models, which uses xVelocity (formerly Veritpaq) in-memory engine.
• Developed ETL jobs to load information into Data Warehouse from different relational database and flat files.
• Writing complex DAX functions in  Power  Pivot. 
• creating  Power BI dashboards using  Power BI Desktop and  PowerQuery. 
• Experience in testing Electronic Data Interchange (EDI) per  HIPPA Compliance.
•   Tested and validated  HIPPA compliance and Hl-7 messages requirements in the application.
•  Developed the necessary project plan based on   Agile Principles, timelines and schedules related to client's infrastructure and workflow needs for the scope of the project 
• Data Modeling Star Schema, Snowflake schema, FACT and Dimensions, Erwin 4.5/4.0,Physical and Logical data modeling.
• Good experienced in Dimensional and Relational Data Modeling using Star and Snowflake Schemas,OLTP/OLAP system, Fact and Dimension tables,Conceptual,Logical and Physical data modeling by using Erwin.
• Thorough understanding of network in  Linux environments such TCP/IP. 
• Managing users for  Linux systems and assigned rights to access network resources 
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas. Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
• Developed C# scripting for packages.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Worked with SSIS packages involved FTP, send mail, script tasks, Merge, and Merge joining Control Flow Transformations.
• Used SSIS to create ETL packages to validate, extract, transform, and load data into data warehouse and data marts.
• Developed dashboards using Tableau for demographic information such as population and allow users to drill into geographical objects such state and county information.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configured SQL mail agent for sending the error records to a different team.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Successfully deployed SSIS (ETL) packages and scheduled jobs.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Used SQL Server Agent for scheduling jobs and alerts.

Environment: ETL, SQL Server 2012/2008R2/2008/2005, SSRS 2012, SSIS 2012, Oracle 9i/10g, TFS, Tableau, Visual Studio 2012, XML, XSLT, MS Office, Visual source safe.

Confidential, Petersburg, PA

ETL DW-BI (SSRS /SSIS/SSAS) Developer

Responsibilities:

• Key role in team of 4 in brining 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Extensively worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Developed SSIS ETL packages using  data warehouse architecture model by creating fact tables  role playing and conformed dimensions.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
•   Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpaved Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Responsible for Analyzing requirements, designing, maintaining and updating data models using ERWIN.
• Deployed and configured the reports in the Report Server.
• Implemented hybrid of Snow-Flake Schema to design the cube.
• Implemented data views and control tools to the ETL packages for guaranteed data transformation using SSIS.
• Responsible for different Data mapping activities from Source systems to  Teradata.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.
• Configuration and Deployment of all reports across various SDLC environments.
• Deployed the packages to production using XML package configuration.

Environment: ETL,SQL Server 2012/2008R2/2008/2005, SSRS 2008, SSIS 2008, Visual Studio 2005,TFS, XML, XSLT, ERWIN, MS Office and Visual source safe, Crystal Reports.

Confidential, PA

Sr. MSBI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Developed SSIS ETL packages using  data warehouse architecture model by creating fact tables  role playing and conformed dimensions.
• Created dashboard reports using  Power BI Desktop ,  Power pivot ,  Power Query,  Power Map  
• Responsible for different Data mapping activities from Source systems to  Teradata .
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created SSIS-ETL packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
• Created SSIS packages to Oracle and other SQL Server instances in SSIS2008.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Deployed SSISpackages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Experience in creating snapshots of static reports and configure subscription.
• Experience in creating complex SSIS-ETL packages using proper control and data flow elements
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS2008.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Lead the team of developers to write efficient code.

Environment: SQLServer 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, ProClarity, MS Excel.

Confidential

SQL Developer

Responsibilities:

• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Trigger
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Develop and maintain in-house custom Crystal Reports to support  business processes and performance assessment. 
• Created stored procedures to apply banking rules
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Created several packages in SSIS.
• Used SQL Server Agent for scheduling jobs and alerts.
• Tuned the SQL queries using SQL profiler.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Managed the use of disk space , memory and connections.
• Prepared of project documentation.
• Worked with application developers in data modeling.
• Created materialized views and normal views as per requirement.
• Imported data from PeopleSoft to Ms SQL server database.
• Developed with a focus on structured query language, T-SQL, Stored procedures and triggers, automating and improving repetitive data tasks so they are more efficient.
• Reviewed and fixed issues related to pre-existing SQL queries, Ensured all database servers and Backups

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Developed User Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.