Provide exceptional support to Business Intelligence team on critical projects concerned with Broadridge BPSA Extracts data mapping, anti-money laundering efforts, security encryption, marketing campaigns and SQL and SSIS package upgrades. Well experienced in creating stored procedures, views and SQL agent jobs. Improve query performance by evaluating query execution plan, usage of user-defined functions(UDFs), common table expression (CTE), creating partitioned tables, clustered and non-clustered indexes, column store index, etc.. Effectively develop and maintain SSIS package configurations and variables to ensure reliable server connection and boost export capabilities; upgrade SSIS packages to SQL server 2014. Build SSRS reports in SQL Server Versions 2008, implement dacpac file usage within multiple teams, and develop and maintain OBIEE reports and dashboards. Implement projects utilizing Agile methodologies SCRUM and KANBAN, and maintain vital data definition documents. Identify and resolve crucial problems for users at various locations; travel to end-user locations as necessary. Mentor new hires to improve team communication and overall cohesion.Key Achievements:Developed complete Broadridge BPSA Extracts project in Enterprise Data via gathering of needed requirements,data mapping, the creation of new SSIS packages, Stored Procedures and updating of existing packages to map with existing fields. Serve as a key member of the Anti-Money Laundering project by setting triggers for high-risk customers, enacting new metrics to evaluate the customer profiles, and developing trading surveillance reports in OBIEE and SSRS. Identify critical security fields, encrypt vulnerable fields, and decrypt fields as necessary in collaboration with DBA team. Conducted workshops to educate new users on the correct use of OBIEE and SSRS reports.

Involved in creating process and data flow diagrams, Installation and product support documents.Designed Logical and Physical tables for Cost Data Repository Database using Star Schema.Designed and Developed SSIS Packages to transfer data from SAP database data and Non SAP database data to Cost Data Repository Database using SQL Server using Business Intelligence Development Studio(2008 R2) and SQL Server Data Tools(2012).Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).Involved in Development, Unit Testing, monitoring, and troubleshoots of SSIS packages.Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Send Mail task etc.Identified the dimension, fact tables and designed the data warehouse using star schema.Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS) 2012.Responsibilities include Developing and Extending MS SQL Server Analysis Services 2012 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects and writing MDX queries. Created Hierarchies, Partitions, Aggregation and KPIs for Cube as per business requirement.Good experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008R2/2012 (SSRS).Developed simple and complex SQL and T-SQL scripts as per application requirement.Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.Involved in Query Optimization and Performance Tuning using SQL Profiler, Explain plan and Index Tuning Wizard.

• Worked in multiple project as Database Development, Administration, tuning and using SQL, T-SQL and SSIS, SSRS and SSAS.• Extensive experience in BI Solutions (ETL, Analysis & Reporting) using SSIS, SSAS and SSRS.• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and Informatica.• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.• Experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.• Expertise in Developing MS SQL Server Analysis Services 2012/2008R2 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries. • Defined many Cubes using SSAS services to generate reports in SSRS.• Experience in development Scheduled reports for Business Analysis using SSRS and OBIEE.• Experience of all phases of SDLC (analysis, design, code, unit test, system test, implementation, post-implementation) and Agile methodology.• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.• Very good experience in Installation, configuration and maintenance of SQL Server.• Expert in database creation, maintenance, monitoring, backups and recoveries. Specialized in analyzing, coding, implementing and creating complex query reports using SQL Server 2005/2008R2/2012 and Oracle 9i/ 10g/11g,• Experience in query optimization and performance tuning. Creating partitioned tables, clustered and non-clustered indexes, column store index, etc.• Experience in SQL database design, architecture, Data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP, Dimensional modeling, star schema and snowflake schema.