Objective

• To obtain a fulltime/long - term position having background in design, development and implementation of SSIS, SSRS, SSAS in Windows 2003 & 2008 Environments.

SUMMARY

• Over 8+ years of experience in Microsoft Technology SQL Server 2008 R2/2012, in creating SSIS, SSAS and SSRS packages.
• Highly proficient in developing SSIS/DTS Packages to Extract, Transform and Load data into Data warehouse from various data sources Oracle, DB2, Excel, MS Access, CSV and flat files.
• Industry background in healthcare with Medicare, Medicaid and HIPAA guidelines.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and SSIS.
• Knowledgeable with relational data structures, ER modeling and principles.
• Proficient in mapping, data import, export and migration using the DTS package.
• Hands on with development of Business Reports and Dashboards in adherence to best practices.
• Expert in designing and developing large number of enterprise reports using SSRS and Excel Pivot table based on OLAP cubes.
• Hands on experience with Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down reports using SSRS.
• Knowledgeable in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Proficient with SDLC and STLC. Experience with Waterfall, Six Sigma, RUP, Iterative and Agile Methodology.
• Good understanding of Business, Development, Quality Assurance and Change Management.
• Worked extensively on Client/Server, Web and Mainframe environment.
• Experienced in creating Views to reduce database complexities for the end users.
• Worked on ODT for Visual Studio and industry wide used products.
• Expert in scheduling jobs for SSIS Packages and sending Alerts using SQL Mail.
• Self-motivated, adaptable, team player, excellent communication and good interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows, Vista/ 2000/2003/2008/ XP/NT/98/95 and Unix AIX

Languages: C, C#, VB.net, Visual Basic, SQL, TSQL and Java

GUI’s: Visual Studio .Net 2003/2005/2008/2010 , Dream weaver & Edit Plus

Databases: MS SQL Server 2000/2005/2008 R2/2012, Oracle, DB2 and MS Access

Web Technologies: HTML, XHTML, DHTML, ASP, ASP.NET and Ajax

RAD Tools: Crystal Reports and XMLSPY

Web Servers: Internet Information Server (IIS)

PROFESSIONAL EXPERIENCE

BI Developer

Confidential, Farmington, CT

Responsibilities:

• Generate database objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL.
• Conduct weekly and daily user meetings to gather requirements for Reports and SSIS packages.
• Involve in writing SQL statements which includes joins and functions.
• Implement complicated transactions for the existing tables.
• Use common table expressions for better performance in executing commands.
• Use SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Perform transformations using various SSIS tasks such as conditional split & derived columns that performed data scrubbing.
• Work with re-directing outputs into different formats including XML Files and various other data sources.
• Implement database management techniques that include backup/restore, import/export and generated scripts.
• Create and updated Reports to meet the requirements and changes specified by the users.
• Optimize the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Work with Tabular reports, Chart reports, Parameterized reports, Sub-reports, Drill down reports and Drill through reports according to business requirements in time restricted environment using SQL server reporting services (SSRS).
• Develop various Charts (Pie Charts) and Graphs like Bar Chart (Side by Side, Stacked) using SSRS.
• Configure and deploy various reports.

Environment: Windows 7, MS-SQL Server 2012, SSIS, SSRS, FileMakerpro.

BI Developer/ETL Developer

Confidential, Piscataway, NJ

Responsibilities:

• Worked on Windows SQL Server 2008 R2, maintenance, Performance optimization and Tuning concepts in relation to RDBMS, SQL optimizations, & Index Tunings.
• Designed high level ETL architecture for overall data transfer from various data sources by building the SSIS packages.
• Created ETL packages to extracted data from source database, flat file, reformat the data, and insert into fact table.
• Created SSIS package to load data from XML Files and SQL Server 2008 R2 using Derived Columns & Condition Split.
• Loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server 2008 BIDs.
• Created indexes, triggers, procedures, functions, constraints and rules on database objects with exposure in T-SQL.
• Manipulated data in SSIS Package using Sequence Container, Script task, Expressions, Execute SQL task, Variables, Package Execution task, FTP Task, Lookup, Union All, Multicast, Script Component, Derived Column, Conditional Split, Data Conversion, Aggregate, Merge and Merge join transformation, Web Service Task of control flow and data flow tasks.
• Performed ETL optimizations, component optimizations & session variable managements.
• Installed and configured Windows Server 2008 and upgraded from 2003.
• Created reports using SSRS sourcing OLTP and data warehouse, data marts.
• Developed multiple reports such as Sub Reports, Matrix Reports, Charts, lists, Drill-down reports, Send mail task using SSRS for supporting various business requirements and data file export formats.
• Worked with different data sources like OLE-DB, flat files and Excel to target databases in SSIS.
• Performed database administration tasks which include Installation, Configuration, Maintenance, Monitoring and Troubleshooting.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities & an extremely diligent strong team player with an ability to take new roles.

Environment: XML, HTML, T-SQL, MS-SQL Server 2008 R2, SSAS, SSIS, SSRS, Toad Data Modeler, Java-Script, Windows Server 2008/Win7.

SQL Server BI Developer

Confidential, Edison, NJ

Responsibilities:

• Took part in JAD sessions and worked closely with the Business Analysts, Project manager and the clients to develop the requirements.
• Developed SSIS packages to migrate the legacy data from DB2 to SQL Server 2008.
• Ensured that all deliverables adhere to the GE Health Care QMS and advocates a quality culture across engineering and cross-functions.
• Adhere to policies, standard operating procedures, QA guidelines, inspection plans and standards for developing medical devices (e.g. IEC 62304 SDLC).
• Installed and configured Windows Server 2008 and upgraded from 2003.
• Executed packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Handled the errors during data movement and sequencing the task as per requirements.
• Maintained SQL Server 2005/2008 for high availability, back up, restore, & upgrade.
• Implemented XML schemas for data transfers configured IIS on development environment and troubleshooting to fix issues.
• Surround SCM and healthcare tools for software development and testing.
• Built many Drilldown, Matrix, Sub-Reports and send mail tasks using SSRS for Sales and Insurance departments, in accordance with Healthcare IT design controls work instructions.
• Wrote T-SQL queries, triggers, & stored procedures for use by the application development team to validate, translate and extract application data.
• Tested the migration of the SSIS packages/reports from SQL environments.
• Generated reports using SQL Server Reporting Services from OLTP and OLAP data sources.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Experienced in understanding of SSAS, OLAP cube and Architecture.
• Based on the requirements applied breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Proficiency in working with Visual Studio IDE, debugging tools like Debug and Error/Exception Handling.
• Performed Unit Testing, Performance testing, and analysis reports against the DB using SQL.
• Extensively worked on installing new environments for offshore/onshore teams for testing and deployments.

Environment: T-SQL, HTML, XML, SSIS, SSRS, DB2, IIS & MS-SQL Server 2005/2008BIDS, OLAP, UML, MS-Office Suite, Erwin 4.1,Windows2008 Server.

MS SQL /BI Developer

Confidential, Novi, Michigan

Responsibilities:

• Took part in requirements analysis and technical specification processes in coordinated with the Business team.
• Contributed to development of Design Document from FRD. Attended Sign off reviews.
• Created SSIS packages and automated jobs to monitor, backup, import/export data from FTP sites for data warehouse extracts.
• Developed back end database SQL Server 2008 stored procedures.
• Implemented Stored Procedures for faster execution in the application.
• Responsible in creating tables, views and T-SQL procedures for the projects.
• Created DTS packages to copy tables, schemas and views and to extract data from MS Excel using SSIS.
• Implemented checkpoint usage in SSIS package enabling the packages to run from the point of failure instead of rerunning the entire package.
• Managed member access to share folders for new and existing users, created validation Controls using SSRS.
• Migrated DTS packages to SSIS packages to modify with new features of SQL SSIS.
• Used SSRS packages to update the Data grid with sorting and paging.
• Customized reports using SSRS with added performance adjustments and scheduled reports to run on a scheduled time via email (SMTP).
• Unit tested the newly developed functionality and documented new features that support software capabilities for each release.
• Installed and configured IIS and MS SQL Reporting Service.
• Expert in creating Star schema cubes using SSAS.
• Assisted the team in development of SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Paired with the team to define Schemas, the relationships between Measure groups and Dimensions in SSAS.
• Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Used Profiler to identify and resolve database lockups, deadlocks, and other issues
• Performed backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Maintained version control with TFS, VSS 6.0 and Visual-SVN.
• Reviewed, analyzed, and modified programming systems including encoding, unit testing, debugging and installation to support an organization's client/server software applications.

Environment: ASP .Net 3.5., C#, ADO.NET, HTML, XML, SSIS, SSRS,SSAS, DB2, .NET, IIS & MS-SQL Server 2008, DTS, T-SQL, MS Excel, SQL Query Analyzer, SQL Profiler.

MS SQL /BI Developer

Confidential, Bloomfield hills, Michigan

Responsibilities:

• Reviewed Business Requirements Document to understand the business process migration strategy to move the database from a legacy system into SQL Server environment.
• Coordinate with Business and created flow charts and Data flow diagrams.
• Designed and developed a full-scale reporting solution for development environment using MS SQL Server 2008 and SSRS 2008/2005.
• Created Technical Design Document, Risk Analysis and Unit Test Specifications.
• Designed parameterized reports using SSRS allowing users the ability to make selections before executing reports. Scheduled reports to run via Send mail task.
• Participated in architecture planning meetings & took part in migrating existing legacy system Unify to SQL Server 2008.
• Performed Data migration using the SSIS module.
• Built ETL packages using SSIS which connected to the source legacy system and loaded into target SQL Server 2008 database.
• Implemented common functionality in SSIS package templates such as common event handling, Error handling, package configuration etc.
• Designed ETL packages which loads Reference data, to staging environment on daily bases and sends Email to notify user groups with detail information such as file name, number of record, date and process time.
• Designed Database in MS SQL 2008 following normalization rules.
• Made application efficient by implemented Triggers, Indexers and Stored Procedures.
• Generated matrix reports and drill down reports in SSRS.
• Developed stored procedures using functions, and JavaScript to generate reports using SSRS.
• Acted as single point of contact for support ofSSISpackages in production. Collaborated with external teams and partners to resolve production issues.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience with data modeling and design of both OLTP and OLAP system.
• Fixed defects, change status in Quality Center. Coordinated with QA Team to verify defects.
• Provided weekly status to the Project Manager.

Environment: .NET 3.5, XML, JavaScript, OLTP, OLAP, IIS, SSIS, SSRS, SQL Server 2008, Quality Center & MS Office suite.

MS SQL Server& Report Developer

Confidential

Responsibilities:

• Designed drill down, drill through, sub and linked reports using SSRS.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Designed and developed SSIS Packages to import and export data from MS Excel files, SQL Server 2008, FTP and Flat files.
• Took part in Database Schema design, Implementation, development, Query development, indexing, maintenance and configuration in MS SQL server 2005.
• Performed data extraction, transformation and loading (ETL) between systems using MS SQL tools such as SSIS.
• Created stored procedures, views, functions, triggers and MS SQL server 2005.
• Created and Managed OLAP Cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Performed the role of an analyst. Gathered User requirement and developed flow charts in Visio to reflect al the artifact of application needs.
• Experienced in creating views, User Created Data Types, indexes, Stored Procedures, Cursors, Triggers and more.
• Involved in site server migration and maintaining legacy SSIS (2000) packages.
• Extensively used SSIS and SSRS for creating various reports for business needs, using MSSQL database 2005.

Environment: .Net 2.0/3.5, XML, XSLT, VB Script, IIS, SSIS, SSRS, MS-SQL Server 2000/2005, Windows Server 2003.