SUMMARY

• Around 8+ Years of development experience using SQL Server and OLTP/OLAP models in Banking, Health care and Financial Sector.
• Experience in creating Calculated Members, building Key Performance Indicators (KPIs) using different storage settings for cube designing, writing MDX queries.
• Experience in developing OLAP cubes consisting of dimensions and measures using SQL server Analysis services (SSAS).
• Proficient in Installation, Configuration and migrating and upgrading of data from previous versions to current version (MS SQL Server 2005/2008/2008 R2 to SQL Server 2012).
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Extensive experience in Data extraction from different homogeneous or heterogeneous systems like Excel, flat file, Text Format Data and DB2 and then transfer to SQL Server as a part of ETL processes.
• Efficient in generating parameterized reports, drill down, drill through, cascading, sub - reports, matrix reports and so on using SQL Server Reporting Services (SSRS).
• Efficient in creating SSIS Packages to extract data from different sources and transform the data according to the business requirements and load the data in SQL server tables.
• Strong knowledge of Data warehousing concepts, including Star schema, Snowflake schema & Dimensional Modeling.
• Experienced in creating Databases based on Functional Requirements and System Design.
• Experience in writing complex T-SQL programming artifacts such as Stored Procedures, Indexes, Views, Functions, using SQL Server for data consistency and manipulation.
• Strong at Query Optimization, use of different Tables and Functions such as CTE, Derived Tables, Temporary Tables, Table variables and Inline Table-valued Functions.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Excellent Knowledge in RDMS concepts and Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Developed complex Stored Procedures, Indexes, Views and Cursors for implementing business logic and process in backend for data extraction, reports and other client interfaces.
• Experience in Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation and Post Implementation Warranty.
• Flexible and versatile to adapt to any new environment and work on any project. Good team player with strong analytical and communication skills. Excellent problem solving skills for delivering useful and compact solutions.

TECHNICAL SKILLS

Database: SQL Server 2005/2008/2008 R2/2012, MYSQL, IBM DB2

ETL Tools: DTS (Data transformation services), Integration Services (SSIS), Import Export Data, Bulk Insert

Reporting Tools: SQL Server Reporting Services, Report Builder 3.0, Power Pivot, COGNOS

Analytical Tools: SQL Server Analysis Services, SQL Profiler, Query Analyzer

Languages: T-SQL, PL/SQL, C#, MDX, COBOL

Tools: SQL Server Management Studio, Toad, CA7 scheduler, JACS scheduler

Applications: Data Tools, Business Intelligence Studio, Microsoft Visio, MS Office Suite, Adobe Photoshop, Visual Studio

Operating System: Windows NT/98/2000/XP/2003 server/Vista/7, Unix

PROFESSIONAL EXPERIENCE

Sr. SQL Server/BI Developer

Confidential - Minnetonka, MN

Responsibilities:

• Responsible for one time migration of historical data from In-Site CRM to Sales force CRM.
• Worked with business users in gathering requirements, source data analysis, design, development, Testing and preparing technical documentation.
• Developed ETL packages from sources like SQL Server, Salesforce, Excel Sheets, CSV, Flat files, FTP and SFTP using SQL Server Integration Service (SSIS) by following Standards of development.
• Used different transformations like derived columns, merge join, data conversion, conditional split, lookup, SCD Etc. in developing SSIS packages to cleanse and transform data while flowing from source to destination
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Assisted in production of OLAP cubes, wrote MDX queries to produce reports using SQL Server 2012 Analysis Services (SSAS) and Reporting service (SSRS).
• Improved the performance of SQL queries tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor.
• Worked on error handler for various events and used different methods for logging in SSIS.
• Responsible for environment creation for Unit testing, FIT/SIT testing.
• Preparing Technical Design document, Operational Design Document and Implementation plan document
• Worked on developing and fixing Excel reports and SSRS reports like Cascading reports, Ad-hoc reports and parameterized reports, Drill down, Drill through, Sub reports, dashboards.
• Extensively worked on developing database objects like Stored Procedures, Views, Indexes, Triggers and Functions using T-SQL and performance tuning of SQL Queries.
• Assisted users with different problems related to data missing, Reports and resolved issues independently.
• Creating and validating reports from Cognos to SQL Server Reporting for merger process
• Provided ongoing support of existing reports, packages including further automating report items and incorporating to larger BI architecture.
• Involved in adding enhancements to measures groups and multiple dimension hierarchies based on the requirement for SSAS cubes.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting. Responsible for handling entire implementation on production environment

Environment: Sales force, C#.Net, SQL Server 2012, SSIS, SSRS, SSMS, MDX, T-SQL, SQL Profiler

Sr. SQL Server/BI Developer

Confidential, Troy, NY

Responsibilities:

• Worked closely with Compliance team, DW team and various channels to understand the type of data and the integration being done currently.
• Utilized knowledge of existing process of processing Checks and HOLDS on customer accounts in designing the new process..
• Scoped the business requirement with different stakeholders.
• Understand the functioning of D.A.V.E engine (using NorKom tool) and the integration efforts with data from ATM and Deposits along with other sources such as CPCS, T3K, Mortgage, CIS, OBIQ, Teller, Online Channels (Mobile and Cash Manager).
• Developed Data Mapping, Data Governance and Transformation and Cleansing rules for the NorKom tool.
• Created OLAP cubes and MDX queries to assist Fraud group and higher management with Analytical and Decision purpose.
• Provided different solutions and the best viable solution to prevent ATM skimming and better processing of HOLDS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Create various reports using Translated customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing, and implementation.
• Responsible for driving the project within stringent timeframe as it was a Compliance issue, along with reporting to multiple stakeholders.
• Lead the efforts including programming and testing for production defect fixes that culminate in client acceptance of the results.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server and wrote the queries for the drill down reports.
• Utilize in-depth knowledge of functional and Technical experience in ETL tools like SSIS, SSRS to create automate reports to be sent to higher management.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, OLAP and Sub reports and formatting them.
• Dented with different ticketing system like Change request, Footprint tickets and Remedy tickets to solve user issues from various groups.

Environment: SSIS, SSRS, SSAS, MDX, SQL Server 2012, MS Visio, HP ALM, SharePoint, MS Excel, MS Word, SSMS, VSAM, DB2, Power Pivot.

Confidential, Richmond, VA

Responsibilities:

• Successfully converted current Ab-Initio process and programs using MSBI tools, SSIS and T-SQL.
• Identified several subscribers (BI appliance for DIME and BIO) and that sources hierarchies directly from ERDM Reference Data Publication Layer.
• Participated in the development of hierarchical-data centric strategies, solutions, and systems design.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in SSIS Package, DTS Import/Export for transferring data.
• Loading of data to Staging tables and then to Master Database Services (MDS).
• Transformed data from various data sources using OLE DB connection by using various SSIS packages.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Experienced in creating master and child packages, package configurations and logging.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SSIS package conversions. Business Intelligence package design.
• Created tables and performed data imports and restores for successful migration.
• Transformed DTS packages into SSIS packages and improved the performance by analyzing database design, database modeling, query plans, database settings and deployed them on to production server.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Designing & Development of Standard Reports, Sub Reports, Cross Tab Reports and Charts using SSRS.
• Exported SSRS reports into various formats like PDF, HTML, Excel and Word for end users.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Generated Reports using Global Variables, Expressions and Functions for the SSRS reports.
• Provided Documentation support on SSRS 2008 as assigned and deployed in SharePoint Environment.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created Tabular and Matrix, Charts reports using SSRS. Created on Sub-queries and Joins were extensively used in stored procedures Using SSMS.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

Environment: Master Data Services (MDS), SQL Server 2012, SSRS 2012, SSIS 2012, SSMS, MS Excel & Windows 2003 platform, C#.NET 3.0.

SQL Developer

Confidential - Atlanta, GA

Responsibilities:

• Migrated associated DTS packages to SSIS packages.
• Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SQL Server Integration Services (SSIS) Created jobs, alerts to run SSIS packages periodically.
• Designed SSIS package to export and import data from SQL Server to Access, text files and Excel files.
• Worked on different data flow sources and Control Flows Tasks such as Send Mail Task, Bulk Insert Task and Execute SQL Task and also worked on various Data Flow Tasks.
• Developed and implemented Cube with dimensions and facts using Server Analysis Services (SSAS).
• Generated drill down reports, drill through reports, matrix reports based on statistical analysis of data using SQL Server Reporting Services (SSRS) according to the client requirements.
• Used Query Analyzer to optimize SQL Queries.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created Dimensions with the cube wizard and also individually.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Created/ modified stored procedures, functions, triggers, views and complex SQL statements for applications.
• Worked with peers to create multiple jobs to be run on JACS tool.

Environment: SSIS, SSRS, SSAS, MDX, SQL Server 2008, Windows Server 2003, SQL Server Management Studio, C#.NET

SQL Developer

Confidential, Grafton, WI

Responsibilities:

• Performed data extraction from multiple sources and vendors and loaded them to Comp Central database using SSIS tools. Also used various transformation components like Execute SQL Task in the data flow task to implement business logic. Used various tasks in control flow and data flow to cleanse and filter duplicates in tables.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments
• Developed, deployed and monitored SSIS Packages.
• Responsible for creating cubes using SSAS and populate the cubes with the data for reporting to higher management.
• Extensively created Ad-hoc reports using SSRS to validate and send information to Finance team.
• Created reports that call Sub reports in SSRS Created Matrix reports and Charts reports using SSRS and Automated monitoring of critical jobs that failed in the database using DTS (SSIS) and SQL mail.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created ETL package for data conversion using various transformations tasks.
• Scheduling Jobs and Alerting using SQL Server Agent and Created datasets for reports using T-SQL and stored procedures.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, SSAS, MDX, C#.NET 3.0, T-SQL, SSMS, Windows 2000/2003 Server, MS Excel.

SQL Developer

Confidential

Responsibilities:

• Created multiple SSIS packages to load requests from vendor provided file to various tables Created SSIS Package to move data from text files to SQL Server 2008.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008 Used various transformation components in the data flow task to implement business logic.
• Used various tasks in control flow and data flow to cleanse and filter duplicates in tables.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS 2008.
• Created Ad hoc reports using SSRS. Created Tabular and Matrix, Charts reports using SSRS Created on Sub-queries and Joins were extensively used in stored procedures
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating and Modifying T-SQL stored procedures for validating the integrity of the data.
• Created ETL package for data conversion using various transformations tasks.
• Scheduling Jobs and Alerting using SQL Server Agent Maintenance and provide support to the users for the deployed reports

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, C#.NET 3.0, T-SQL, SSMS, Windows 2000/2003 Server, MS Excel