SUMMARY

• Around 7 years of IT experience in Database Design, Data Modeling, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server, Microsoft BI Tools like SSIS/SSAS/SSRS (2005/2008/2008 R2/2012)
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)
• Hands on experience in data Extracting, Transforming, and Loading (ETL) from various sources such as raw file, XML file, Oracle, DB2, MS Excel and Access database to SQL Server
• Experience in creating Event Handlers, Precedence Constraints for executables such as packages, for each loop, for loop and Sequence Containers
• Experience in migration of data using Bulk Insert command, SSIS, DTS Packages, Import/Export Wizard and Copy Database Wizard
• Excellent knowledge of using variables and expressions in packages for updating properties of package elements at run time and control looping within a package control flow
• Experience in Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like by using multiple transformations provided by SSIS such as Conditional Split, Union All and Bulk Insert
• Expertise in ETL, Enterprise Data warehousing, Operations Data Store concepts, data marts, star schemas, snowflakes, ETL processes and dimensional modeling and OLAP technologies
• Expert experience in developing SSIS package framework (storage, deployment and management) for solutions across the projects using design best practices
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Knowledge in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS) and also experienced in developing Aggregation, KPIs, Partitioning Cube, Data Mining Models, and deploying and processing SSAS objects
• Extensive SQL Server database experience and expert knowledge in scripting stored procedures, triggers and user-defined functions in T-SQL.
• Extensively used Report Wizard, Report Builder for developing and deploying reports using SSRS.
• Experience in developing Custom Reports, Tabular Reports, Matrix Reports, Ad hoc reports and drill down, drill through and chart reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/2012
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduling DTS and SSIS Packages
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation

TECHNICAL SKILLS:

Databases: Server 2012/2008R 2/2008/2005/2000 , MS-Access, Oracle 11g DB2.

Database Tools & Reporting: SQL Server Management Studio, SSIS, SSAS, SSRS, Enterprise Manager SAP Business Objects, Crystal reports, Xcelsius.

Data Modeling Tools: Erwin, VISIO, SQL Profiler Microsoft SharePoint.

Languages: C, C++, T-SQL, MDX, VB, C#.NET.

Operating System: Windows 2008/2003 Enterprise, Windows 2000 Datacenter, Windows XP, Vista, Windows Server 2003/2008.

Architecture: Relational DBMS, Client-Server Architecture and OLTP.

Other: Microsoft Visual Studio 2008/2005, Team Foundation Server (TFS), Top Team.

PROFESSIONAL EXPERIENCE:

Confidential

MS BI Developer

Responsibilities:

• Gathered requirements from Program area SME’s and coordinated with the Data Architect to design the WCAIS application data base and reports data base
• Created Report Specifications documents using Top Team( Requirement gathering tool)
• Implemented Stored Procedures for self-insurance and Assessment modules which perform complex financial calculations and automated them using SQL Server Agent
• Conducted performance tuning by using SQL Profiler and database engine tuning advisor
• Worked on importing and cleansing of data from MS Access onto SQL Server 2008R2
• Used various transformations in SSIS like Data Conversion, Lookup, Fuzzy grouping, Conditional Spilt, Pivoting/Un-Pivoting Transformations with error handling for Assessment module
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions
• Scheduled SSIS packages by creating corresponding job tasks for Self Insurance and EDI transactions, Claims related to Self-Insured Employers and Insurers
• Performed system restoration, data back up as per requirement and also scheduled data backup
• Used Copy Database Wizard to copy databases and their objects from one server to another
• Managed server security, created new logins for users for System Integration Testing (SIT), User Acceptance Testing (UAT) and on production environment
• Generated Adhoc reports on Claims, self-insurance modules and employers account information using T-SQL
• Developed and Deployed reports in MS SQL Server environment using SSRS-2008
• Worked on Sub Reports, Data Drill-Down and Data sorting/grouping Report Design in SSRS
• Used dynamic parameters in SSRS to enable/disable parameters based on user selection
• Participated in User Acceptance Testing for Reports and also trained end users in ad hoc reporting
• Provide production support by writing data scripts to fix defects and also developed new enhancements as and when required

Environment: MS SQL Server 2008 R2,MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS),SQL Server Business Intelligence Development Studio, MS Visio 2010, MS Visual Studio 2010, Team Foundation Server(TFS), Top Team, SQL Profiler,, T- SQL, SDLC, Waterfall Methodology, Agile( Scrum) Methodology

Confidential, CA

MS SQL SSIS/SSAS/SSRS Developer

Responsibilities:

• Provided documentation on database/data warehouse structures and updated functional specification and technical design documents for reports and SSIS packages
• Provided assistance and support to higher level staff for SSRS abilities and reporting capabilities
• Maintained records in Excel Spread Sheet, export data into SQL Server Database and cleaned the data using SQL Server Import and Export Wizard
• Designed SSIS Packages to transfer data from Oracle 11g to SQL Server 2008R2, validated data during transferring and archived the data files
• Used Event Handlers for Exception Handling in packages, Scheduled Jobs, Backups and performed database restoration
• Reviewed existing reports with Oracle backend and mapped the fields to the SQL Server database to facilitate report development
• Assisted in production of OLAP cubes with star schema, wrote queries to produce parameterized reports using SQL Server2008 R2 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed and created Report templates, bar graphs and pie charts based on the students enrollment data using appropriate filters and expressions
• Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboards
• Configured and created Report Snapshots periodically using the SQL Reporting services
• Managed DBMS related utilities to support and maintain databases and optimization of SQL queries using SQL Profiler
• Coordinated with Database Management staff to provide support throughout the project life cycle

Environment: MS Visual Studio 2008, SQL Server Management Studio 2008 R2, Team Foundation Server, SharePoint, Oracle 11g,T-SQL, Stored Procedures, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MS Office Suite

Confidential, Hoffman Estates, IL

BI Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development and deployment
• Developed scripts to check for duplicate records, delete/modify them depending on the business rules
• Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and creating packages
• Responsible for Implementation of SCD type 1 and type 2 mappings to insert/update records into Dimension tables
• Worked extensively with debugging, defect tracking and troubleshooting issues
• Responsible for Import and export of data from SQL Server 2000 to SQL Server 2008 as per requirements
• Involved in creating Data mappings and data models using ERWIN tool
• Created SSIS packages to load data into Data Warehouse using SSIS tasks like Execute SQL Task, data flow task, file system task, send mail task, xml task
• Assisted in creating OLAP cubes using SSAS 2008, and create Drilldown, Drill through OLAP reports using SSRS 2008
• Documented use case for data mart, cube testing and also performed initial validations to check data consistency

Environment: SQL Server 2008/2000, SQL Server Management Studio 2008(SSMS), Business Intelligence development Studio(BIDS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Windows 2000/NT

Confidential - Mechanicsburg, PA

SSIS/SSRS Developer

Responsibilities:

• Created and developed stored procedures to handle complex business rules, wrote complex SQL statements using joins, sub queries and correlated sub queries
• Responsible for Developing, Monitoring and Deploying SSIS packages
• Created dynamic configuration packages in SSIS
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column
• Used Event Handlers for Exception Handling in SSIS packages
• Worked on the statistical analysis of the data to generate reports using Crystal Reports
• Developed Report Models using report builder and distributed reports in multiple formats using Developed and edited many complex reports with Crystal Reports
• Generated Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports using Chart expert of Crystal Reports
• Responsible for Exporting reports to various formats like MS Excel, PDF, MS Word, Text and CSV as per the requirements
• Created many complex Stored Procedure/Functions and used them directly to generate reports
• Scheduled, maintained, and supported the distribution and access to reports created

Environment: SQL Server 2005, SQL Server Management Studio(SSMS), Business Intelligence development Studio(BIDS), SSIS, SSAS, SSRS, Crystal Reports 2008, Windows 2000/NT

Confidential

BI Developer

Responsibilities:

• Resolved deadlock issues of the application using SQL Profiler.
• Worked extensively with debugging, defect tracking and troubleshooting issues.
• Created SSIS Packages for Incremental Loading, slowly changing dimensions and data Importing
• Created multiple reports (SSRS) in Drill mode using tables, crosstabs and charts
• Hands on experience in design, development, and maintenance of various SSRS Reports in SQL Server 2005
• Generated reports dat can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear view of the reports
• Scheduled monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes

Environment: MS SQL Server 2005, VS 2005, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), DTS