SUMMARY

• Over 8+ years of experience in analyzing, designing, tuning and developing client/server, Business Intelligence (BI) database application, using MS SQL Server 2014/2013/2012/2008 R 2/2008/2005/2000 DTS/SQL Server Integration Services (SSIS), Reporting and Analysis Services (SSRS, SSAS), Oracle Client 11g, PL/SQL, Oracle SQL Developer, Oracle Hyperion EPM System.
• Extensive experience in the Extraction, Transformation and Loading (ETL) of data from different data sources into Data Warehouse, data cleansing/data integration using SSIS.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Expert in SSIS, utilizing control flow items such as For Each loop, For Loop and Sequence Container.
• Experienced in .Net, Windows Application and Website Services.
• Experienced in Importing/manipulation and data consistency.
• Experience across all phases of Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Experienced in deploying and enhancing the SSIS Packages from development server to production server.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL and PL/SQL queries, stored procedures, and triggers, functions usingSQL Servers.
• Expert in creating indexes, Stored Procedures, user defined functions, common table expressions (CTEs) and Triggers to facilitate efficient data SDLC from project initiation to post-implementation and Agile Methodology.
• Excellent knowledge in RDBMS, Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Extensive experience in developing web application, using JavaScript and Oracle Hyperion Reporting.
• Experienced in Database Administration, Database Management, Database Security, Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports, cached and snapshot reports, linked, click reports, sub reports through using RDL, SSRS 2012/2008R2/2005, and Oracle Brio Studio.
• Experienced in using global variables, expressions and functions for the reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server and R2 and 2008R2 to 2012.
• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations, using Multi Dimensional Expression (MDX) to access them.
• Familiar with Corporate Finance, Mergers & Acquisitions, DCF model, Financial Derivatives, International Finance, IRR, Fixed Income

TECHNICAL SKILLS

• Microsoft SQL Server 2005/2008/2008- R 2/2012/2013/2014
• SQL Server Management Studio (SSMS)
• SQL Server Business Intelligence Development Studio(BIDS)
• SQL Server Data Tool(SSDT)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• MySQL
• MS-Access
• MS-Excel
• SQL
• T-SQL
• HTML
• XML
• Erwin
• Visual Studio 2005/2008
• Crystal Reports
• SQL Profiler
• Performance Point
• MS Visio
• SharePoint
• PowerPivot
• PowerView
• Oracle SQL Developer
• Oracle Hyperion Reporting(BRIO Studio)
• Hyerion Essbase
• PL/SQL
• JavaScript.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr SQL Server MSBI Developer

Responsibilities:

• Creating and defining theSQLServers (Dev, QA and Prod) and Databases inSQLserver 2014 with the Architecture in the team.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views,SQLjoins and other T-SQLcode to implement business rules.
• Expertise in writing T-SQLQueriesusing Joins, Subqueriesin MSSQLserver 2010, 2014.
• Strong experience in writing stored procedures, functions, triggers in MS T-SQLbuilding the packages, Testing and implementing in the production server.
• Redesigned and tuned stored procedures, triggers, UDF, views, indexes and was successfully able to increase the performance of the slow runningqueries.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Developed ETL packages using multiple data sources (SQLServer, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Created Master SSIS packages in order to execute a set of packages on a timely basis and deployed those packages using Manifest Files and Import/Export Wizard so that the packages were available for use of other team members.
• Experience in Error and Event Handling: Precedence Constraints, BreakPoints, CheckPoints, and Logging using SSIS.
• Extensive experience with multiple development environment includingSQLserver Server 2005/2008/2008 R2/2012/2014 Visual Studio (BIDS) 2005/2008/2010, TeamFoundationServer(TFS) 2008/2010, and SharePoint 2010.
• Monitor productionserversusing Red Gate tools andSQLServer by using Red GateSQLmonitor. And comparing all the databases and tables by usingSQLCompare 11.
• Used to run the jobs by Active Batch, which it is more advanced to run the jobs in SSMS.
• Created, updated and maintained ETL Technical Documentation for future reference by other team members.
• Identified, tested, and resolved performance issues of poorly runningqueriesand performance of database itself by using Index Tuning Wizard,SQLProfiler, andQueryAnalyzer. Also monitored Deadlocks inSQLserver usingSQLServer Profiler.
• Experience in T-SQLProgramming skills, Experience in query optimization & performance tuning. UsedSQLProfiler, Execution Plan, Performance Monitor, Diagnostic Manager, and DBCC Commands.
• Monitoring the data files, log file space issues, blockings, TempDB space issues.
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.

Environment: SQLServer 2014/2008R2/2008, SSRS 2008, SSIS 2014/2012/2008, Data Stage, DB2, Oracle 9i/10g, Visual Studio 2005, Active Batch, Red Gate, Team Foundation Server(TFS), XML, XSLT, MS Office and Visual source safe.

Confidential, Chicago, IL

SQL BI Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Involved in conversion interfaces on QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits.
• Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.
• Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created incremental data load task using SQL Server Integration services
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server.
• Worked with development teams in the design of physical databases and in modification.
• Involved in migration from SQL Server 2005 to SQL Server 2008

Environment: MS SQL Server 2014/20132008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Confidential, Chicago, IL

SQL BI/ETL Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Designed Database using Erwin data modeler.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Developed SSIS Packages using Lookup Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.
• Generated parameterized reports, sub reports, tabular reports using SSRS-2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.2

Confidential, Florham Park, NJ

MS SQL/SSRS/SSIS/SSAS Developer

Responsibilities:

• Involved in the initial development of data requirements and infrastructure design; met with end users and gathered requirements from them during the phase of product development.
• Documented, analyzed and designed process and workflow by following Agile Methodology.
• Obtained financial forecasting and plan spreadsheets, performed data analysis and created business and technical requirements documents including functional, system and data requirements.
• Created detailed technical specifications and data models for development of new or modifications to existing products and ensured project remain on schedule and all target requirements are met.
• Participated in back-end development of database and financial data warehouse and implemented data loading using SSIS.
• Designed ETL Jobs/Packages using SQL Server Integration Services SSIS and troubleshot Packages using Event Handler and Logging.
• Created SSIS package to import and export data from Excel, CSV, XML and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Designed and implemented ETL for data load from Source to target databases and for Fact.
• Designed packages which utilized tasks such as Data Flow Task, Sequence Container, For Each Loop Container and For Loop Container.
• Created financial data feeds requirements for data mapping (Source to Target) for all tables.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Developed PL/SQL and T-SQL queries to create tables, views, constraints and indexes.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Data Conversion, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed and implemented company-wide reports using SSRS and also create Data Model for users to generate ad-hoc reports.
• Designed (SSIS) SQL server integration packages for migrating data using variouscomplex transformations such as derived column and lookup etc.
• Built user-defined functions as well as complex stored procedures, involving forecasting and calculating annual and quarterly revenues, table updating and tracking using PL/SQL and T-SQL.
• Designed, developed financial forecasting reports based on business model and requirements, dynamic reporting Dashboard and interactive reporting application to generation PDF reports using Oracle Brio Studio and JavaScript.
• Performed unit testing and data validation of reporting and packages in different servers and wrote released notes.
• Modified stored procedures in accordance with the logic changes and the updates of and business requirements from clients.

Environment: Microsoft SQL Server Management Studio, Microsoft SQL Server 2008R2/2012, SSRS, SSIS, Oracle Clients 11g, Oracle SQL Developer, PL/SQL, T-SQL, Hyperion EPM Excel Add-in, Essbase, Oracle EPM System(Reporting and Analysis: Brio Studio), XML, VB, C#, JavaScript, VISO Studio, MS PowerPoint, MS Excel, MS Access & Windows Server, SharePoint, .NET Framework, ASP.Net

Confidential, Parsippany, NJ

MS SQL ETL Developer

Responsibilities:

• Developed T-SQL code, Views, Functions and Stored procedure using T-SQL to get data from Different data and with best execution plan.
• Scheduled SQL jobs in SQL Server 2005 to generate alerts to the subscribers to the alerts in RAN 2G & 3G and CORE alerts.
• Created different user-defined functions using T-SQL Query for the creating Datasets and Data Adapters to use them in SSRS 2008 and SSIS.
• Configured SQL Mailing Agent for sending alerts to the subscribers by mails upon SSIS packages, SSRS reports2008 and T-SQL Stored Procedures.
• Involved in developing and deployed Reports from OLAP in SSRS with Charts and PIE Diagrams.
• Created Drill Down and Drill through reports with user defined parameters with sub reports, Pie diagrams and Charts in SSRS.
• Configured in report architecture and report security for reports in SQL Server Reporting Services.
• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2008
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2008 SSRS
• Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP
• Designed ER diagrams and mapped the data into database objects and performed
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent using SSAS
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries
• Involved in table and index partitioning for performance improvement and manageability and identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Involved in table and index partitioning for performance and Manageability in cognos.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Generated Crystal reports using SQL Server Reporting Services integrated and deploying them using web applications onto the SharePoint web servers in Data Modeling.

Environment: Microsoft SQL Server 2005/2008, SQL Server Integration Services (SSIS), BIDS, SQL Server Reporting Services (SSRS), Windows Server, MS Visio, Oracle, MS Excel, cognos, crystal Reports, Business Objects.

Confidential, Charlotte, NC

MS SQL Developer

Responsibilities:

• DesignedSSIS packages to Extract data from different sources like flat files, excel files, SQL Server; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Gathered report requirements and determined the best solution to provide the results in a Reporting Services.
• Produced operational reports in SSRS i.e. drill-up, drill-down, drill-through, dashboard and matrix reports.
• Wrote complex SQL queries and stored procedure to create reports using SSRS from the relational database.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008R2.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to create reports.
• Configured the report server and generated the report models for user interactions.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Environment: Microsoft SQL Server 2008 Enterprise Edition, Windows 2003 Server, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio(BIDS), Microsoft Visual Studio 2010, Visual Source Safe 2005, ERWIN, C#.Net, ASP.Net, VB.Net, SQL Profiler.

Confidential, New York, NY

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports, debugged and deployed reports in SSRS.
• Designed, developed, modified and enhanced the database structures and database objects.
• Created several SSIS packages in Microsoft SQL Server 2005.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Wrote several complex stored procedures for the ease of application.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Environment: Microsoft SQL Server 2005, Business Intelligence tools - SSIS, SSRS, MS Access, T-SQL programming.