SUMMARY

• Over 7 years of IT experience as a SQL BI developer that includes migration of data and reports using SQL server 2012/2008R 2/2008/2005/2000 and Visual studio 2012/2008/2005.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/ 2005/2008/2008 R2/2012 with expertise on data normalization and understanding of software/application/system development lifecycle.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008 R2/2012 SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.
• Good knowledge of security,memory management, andexception handling using C# and .NET.
• Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.
• Experienced in designing and developing large number of reports in SSRS/Tableau using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in data Import/Export, Bulk insert and BCP. Experienced in creating Jobs, alerts, SQL Mail Agent, scheduling packages using SSRS.
• Extensive experience in database activities like Data Modeling, Database Design & Development, Coding, Implementation, Maintenance and Performance Monitoring & Tuning using tools such as Index Tuning Wizard, SQL Profiler and Replication.
• Highly proficient with Microsoft Office tools such as Word, PowerPoint, Excel and Outlook.
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

• MS SQL Server 2000/ 2005/2008/2008 R2/2012
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• BIDS
• DTS
• Import/Export Data
• Bulk Insert
• BCP
• SQL Profiler
• SQL Query Analyzer
• Enterprise Manager
• Management Studio
• Replication
• SQL Agent
• MS Visual Source Safe 6.0/8.0/2005
• C# Visual Basic 6.0
• ASP
• T-SQL
• HTML
• TFS
• XML
• VB.Net.
• Oracle 10g/11g
• Tableau

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

MS SQL/BI Developer/QA

Responsibilities:

• Created reports to meet user requirements using Microsoft SQL Reporting Services.
• Wrote and maintained SQL database stored procedures.
• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Prepared the completedata mappingfor all the migrated jobs using SSIS.
• Extensively used SSIS transformations such as derived column, data conversion, Aggregate, Conditional split, SQL task and Send Mail task.
• Participated in project scope discussions and business requirements meetings.
• Updated requirements documentation and assist with any updates discovered during the report implementation and UAT.
• Developed different kind of reports such asub reports,charts,matrix reports,linked reports and drill-down reports.
• Generated multi-parameterized reports allowing users the ability to make selections before executing reports.
• Developed Reports for business end users usingreport builderwith updating statistics.
• Developed an automated report subscription process usingSSRS.
• Responsible to support the issues with reports on the enterprise environments (development, UAT, test and production).

Environment: MS SQL Server 2012, SSRS, Visual Studio 2012, ASP.Net, C#, Oracle 11g.

Confidential, Des Moines, IA

MS SQL/ETL/ Data Analyst

Responsibilities:

• Play a senior role in realizing reporting and analytics strategy.
• Design and scope analytical projects: formulate methodology, establish data requirements, identify client deliverables, and determine tasks and timing.
• Maintain a working knowledge of the data sources to accurately and efficiently report findings in a meaningful and understandable manner.
• Execute complicated analyses and make the results accessible and relevant to a wide variety of business users.
• Develop and refine analysis templates for problem diagnosis and opportunities assessment.
• Complete special projects and management SSRS/Tableau reports as assigned.
• Synthesize complex data into user friendly visual presentations.
• Perform complex SQL queries, triggers and stored procedures, views and user defined function and update database statistics.
• Configure and create SSIS solutions for ETL and business intelligence process for data integration and migration services
• Involved in Report Design and Coding for Standard type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Created SSIS package to load data from Flat File, CSV File, and Oracle to Data warehouse and Report-Data mart and applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column and Merge Joins in SSIS.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Establish effective mechanisms of communication with staff, providers, and the organization’s management team to foster an environment of openness, trust and team work.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Visual Studio 2012, MS Visio 2008, Windows 2007, ASP.Net, C#, Oracle 11g,Tableau.

Confidential, Walnut Creek, CA

MS SQL/ETL Developer

Responsibilities:

• Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2 and Text files and Excel files and MS word 2007 files) to SQL Server.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master defective parts source spreadsheet to the SQL Server table and update the old data.
• Responsible for the deployment of the reports on the reporting server and scheduled subscription for the windows file share.
• Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Dashboard, Drill through and Drill down reports.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Build packages and handled slowly changing dimensions to maintain the historic data.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created and Configured OLAP Cubes using SQL Server 2012 Analysis Services and Performance tuning and scaling to large numbers of users.
• Evaluate business performance with key performance indicators (KPI) using SQL Server Analysis Services.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time frame.
• Build the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS) and created SSRS reports.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, BIDS, Visual Studio 2008, MS Visio 2008, Windows 2007, ASP.Net, C#, Oracle 11g.

Confidential, Dover NH

MS SQL Server/ BI Developer

Responsibilities:

• Involved in the logical and physical design of the Data mart using dimensional modeling and designed the SSIS Package for the transfer of data from OLTP to data mart.
• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
• From one standard database for loans created diversified destinations for auto loans, student loans, home loans using SSIS packages.
• Created SSIS script tasks, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Created T-SQL queries, created dynamic Stored Procedures that calculates the loan sanctioning details taking the customer details as input and also Created report models for ad hoc reports when the end user wants to see the reports on fly.
• Unit tested all the reports by running queries against the warehouse using SQL
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.
• Calculated loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.
• Designed Usage summary and Detail reports in SSRS and responsible for the deployment of the reports on the reporting services website
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.

Environment: MS SQL Server 2008R2, SSIS, SSRS, SSAS, MS Server Integration services, C#, .NET, Windows7, Oracle 11g.

Confidential, Norwalk, CT

BI Developer/ ETL Developer

Responsibilities:

• Involved in the logical and physical design of the Data mart using dimensional modeling and designed the SSIS Package for the transfer of data from OLTP to data mart.
• Stored configuration information in SQL Server table for the migration from development server to production server and used various dataflow and control flow transformations for ETL.
• Wrote Stored Procedures for the ETL functionality from ODS to Data Mart in SQL Server 2005 and developed the Slowly Changing Transformation to maintain the historic data.
• Designed Usage summary and Detail reports in SSRS 2005 from the requirement document and also Created Alerts for successful or unsuccessful completion of the scheduled jobs.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Performed complex queries, triggers and stored procedures, views and user defined function and updated Database Statistics and Re-indexing.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard and improved data load performance by analyzing database design and query plans.
• Responsible for the deployment of the reports on the reporting services website and created subscription for the windows file share.
• Responsible for the Performance tuning and optimization with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Implemented three layer securities for the reports in SSRS website and in the Intranet web application.

Environment: MS SQL Server 2000/2005, SSIS, SSRS, BIDS, Visual Studio 2005, VSS 2005, Erwin 7.2, Windows NT/2003, Microsoft .NET framework 3.0, JavaScript, ASP.NET, XML

Confidential

MS SQL Developer

Responsibilities:

• Actively involved designing the logical and physical architecture of the database.
• Created new tables, written stored procedures for application developers and some user defined functions.
• Defined check constraints, Indexes and views and also created triggers to enforce data and referential integrity.
• Developed financial analysis reports which include fixed income, bonds, prices and risks and presented to portfolio managers and traders.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Involved in performance tuning using indexing by minimizing table scans.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in writing T-SQL programming for implementing stored procedures and functions for different tasks.
• Used SQL Server profiler to find badly performing queries and deadlocks and also resolved various performance issues
• Worked on Client/Server tools like SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server 2005.
• Calculated loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.

Environment: MS SQL Server 2000/2005, Query Analyzer, MS Excel, Enterprise Manager, MS Visio 2005, VSS, Oracle 10g.