Professional Summary:

• Over 9 years of total IT experience in Application Development, DBA, Data warehousing experience with Microsoft SQL Server 2000/2005/2008/2012, SSIS/SSRS/SSAS, OLTP and OLAP environments.
• Experience in Netezza platform, an industry leading scalable and massively parallel processing platform as basis for solution. Netezza Certified Specialist PureData System for Analytics v7.0
• Knowledge of the Health Care and Banking Industry.
• Good development experience in working onshore and offshore model and leading offshore resources from onshore. Worked with Syntel Inc onshore and offshore model for client Magellan Medicaid Administration for duration of 3 years.
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment. Experience in understanding SQL Server Integration Services SSIS Engine and optimizing package processing.
• Master in designing relational and dimension database modeling and physical implementation as per business requirement.
• Experience in Informatica.
• .Experience in developing the applications using T-SQL Programming DDL, DML and DCL .
• Expert in creating Tables, views, indexes, cursors, stored procedures and Trigger in SQL Server Management Studio and Enterprise Manager using T-SQL Programming
• Strong Transact SQL, MDX and XML
• Experience in designing both normalized and star schema based tables
• Extensive knowledge in Tuning SQL queries improving the performance of the Databases
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Expert in designing high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developing reports on SSAS SSRS on SQL Server 2000/2005/2008 . Sound Experience and understanding of SSAS, OLAP cube and Architecture. Good knowledge in optimizing MDX queries. Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them. Experience in creating ReportModels and Adhoc reporting. .

TECHNICAL SKILLS

Professional Experience

SSIS Netezza PDW Linux Developer

Responsibilities:

• Conducted ETL development in the Netezza and SQL server environment using SSIS and
• Linux standard design methodologies.
• Monitored progress and documented compliance with ETL best practices standards.
• Extensively used nz migrate to copy data from Mustang to TwinFin environment.
• Extensively used NZSQL, NZPLSQL, UDX, NZLOAD, Netezza Query Plan and Query tuning.
• Managed netezza queries by performance tuning and techniques such as CBT and Collocation.
• Converted logic from stored procedures to dynamic ETL SSIS packages.
• Hands on experience in Transactional OLTP databases and Netezza PDW.
• Extensively used TSQL and wrote various TSQL stored procedures for the purpose of application development.
• Tuned SQL statements e.g.: - Using Indexes and Stored Procedures.
• Good knowledge on Replication and Backup.
• Designed dynamic SSIS Packages in Visual Studio 2005 and 2008 to transfer data crossing different platforms, validate data during transferring, and archiving data files.
• Collaborated with software architects to ensure alignment of the Netezza environment.
• Participated in data modeling and database design.
• perform database development tasks in Netezza and Sql server.
• modify Unix shell scripts for batch jobs
• Ensure deadlines are met.

Confidential

• Project: Comprehensive Capital Analysis and Review CCAR The purpose of the Comprehensive Capital Analysis and Review CCAR project is to review the capital position of BMO/Harris/M I and provide critical mandated Stress Test and FR Y-14 Schedule reports to the Federal Government. Apollo Risk Analysis and Reporting
• The purpose of this project is to develop a consistent and quick method to pull in 14 data files from five different sources in order to provide cleaner data and timelier Risk Analysis and Reporting.

Role: SQL server SSIS SSAS Netezza Developer

Responsibilities:

• Requirement analysis in order to generate complex system integration SSIS packages.
• Created Data Model Design for CCAR project.
• Multi-Tasks over several different projects.
• Mentoring other ETL developers
• Scheduling Jobs on Sql server
• Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.
• Worked on OLTP TSQL, Stored Procedures, Functions, Materialized Views, Cursors and Triggers.
• Performance tuning of OLTP systems.
• VB.Net and other .NET languages C used for Script task. Script task is primarily to control the flow of SSIS package. Created SSIS packages using script tasks and with Error Handling.
• Dimensional Data Modeling experience, Star Schema/Snowflake Modeling, Fact Dimensions tables.
• Created Complex SSAS cubes with multiple Fact and Measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.

• Created Local Partition, Remote Partition and Storage Modes Settings in OLAP
• Created MDX queries for implementing Actions and KPIs in SSAS.
• Optimized SSIS/SSAS Code performance and processing methods
• Written Complex scripts in Netezza to retrieve data from source systems.
• Designed effective ETL packages to transform data in Netezza
• Extensively used NzLoad and NzSQL in Netezza Datawarehousing Appliance.
• Interacting with Business Objects development team for reporting needs.

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, SQL Profiler, PL/SQL, Toad, Netezza, Aginity, Erwin, Business Objects, SQL Server Analysis Services,, SourceSafe.

Confidential

Project: Clinical Rules Integration CRI Role: SQL server SSIS SSRS SSAS Developer CRI system provides personal health care guidance can improve the safety, quality and coordination of healthcare for WellPoint members and help lower their costs. CRI continually analyze each individual's health data to create their personal health picture and run a Personal Health Scan to identify actions to improve health and reduce costs. We then send personalized, confidential messages to help members, their doctors and care managers take action.

Responsibilities:

• Worked in database design and data modeling process for CRI system using Erwin.
• Good experience in loading data to very large SQL Server databases VLDB 20TB .
• Extensively used Table and Index Partitioning to improve new data load and query performance.
• Developed dynamic SSIS packages to load Medical and Rx claims, Provider, Eligibility etc extracts for Clinical rules integration processing. The extracts are in several layouts and had to be validated and re-formatted to a standard layout and loaded into SQL Server.
• Implemented Precedence Constraints, Logging, Transactions, Package Configurations, Error and Event Handling in SSIS packages.
• Deployed SSIS Packages to File system and SQL server.
• Created Datawarehourse Cubes in SQL Server Analysis Service SSAS .
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experienced in analyzing multidimensional cubes in SQL Server 2005 and 2008 Analysis Services SSAS by using skills like slicing and dicing, drill down, drill up, and drill through.
• Designed and developed the entire business intelligence reports using SQL Server Reporting Services 2005 and integrating it to the front end application.
• Designed/Implemented the Ad-Hoc Reports
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Extensively used Dynamic SQL and MDX
• Created Database objects including Tables, Triggers, Views and T-SQL Procedures
• Created Indexes to improve query performance.
• Worked with various functional experts to implement their functional knowledge into working Procedures
• Involved in Bug Life Cycle

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, SourceSafe.

Confidential

Role: SQL server SSIS SSRS SSAS Developer

Magellan Medicaid Administration MMA is directed specifically toward State Medicaid Agencies. MMA generates and forwards rebate invoices, conducts dispute resolution and updates and maintains labeler accounts receivable file. First Rebate and PDL Applications Improves the effectiveness of the rebate service processes, Improves the accuracy and timelines of the rebate invoicing, receipts, and reporting to external customers.

Responsibilities:

• Migrated DTS 2000 Packages to SSIS Packages.
• Extracted data from Heterogeneous data sources like SQL Server 2005/2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP and loaded to SQL Server.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Optimized packages minimizing use blocking transformations, adjusting buffer size, parallel executing packages in control flow, and using proper event handing, loggings and check points.
• Developed code in SQL Server to calculate rates for the Preferred Drug List PDL , based on requirements gathered from business SME.
• Mostly used XML package configuration in packages making easy to move into production environment
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design Star Schema and maintenance.
• Designed various Cubes as per the requirements for various clients using SSAS.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Created reports using SSRS from various sources like SQL Server 2005/2008 R2 and Cubes from Analysis Services
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008 R2.
• Filtering data with Report Parameters, Cascading Parameters for Reporting Services.
• Wrote stored procedures for report generation in SQL Server 2005.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE .
• Created Clustered and Non- clustered indexes in SQL Server 2000 and 2005
• Developed physical data models and created DDL scripts to create database schema and database objects.

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, SourceSafe.

Confidential

Role: SQL server SSIS SSRS SSAS Developer

• The primary role of this project was to assist a team in creating a new reporting system. After detailed and careful reporting analysis, SQL Server Reporting 2005 fulfilled the needs of the company. A new reporting system was designed to allow internal departments to access data via an internal website using SSRS 2005.
• Nightly/Minute ETL processes into a custom designed data-mart allowed for ad-hoc reporting from minutes old data.

Responsibilites:

• Design/Implemented the SQL Reporting Services management security.
• Created Linked Reports and Snapshots
• Designed/Implemented the Ad-Hoc Reports
• Data mart solutions to improve performance of Sql Server 2005 Reporting services SSRS
• Migrated Crystal Reports to SQL server 2005 Reporting Services
• Created complex Stored Procedures and Views to be used in the reports
• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports
• Experience in Data Warehouse Modeling with SQL Server Analysis Service SSAS
• Data Cleaning by Fuzzy Lookup and Fuzzy Grouping.
• Deployed SSIS packages and Reports to Production Servers.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Created functional requirement specifications and supporting documents for business systems.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Developed stored procedures, functions, indexes, views and triggers.

Environment: SQL Server 2005/2000,T-Sql, Visual Studio, VB Script, SSIS, SSAS, JAVA Script, Oracle 9i/ 8i, MDX, C ,XML, Crystal Reports10.0, Business Intelligence Development studio, Query Analyzer, Enterprise Manager.

Confidential

Role: SQL server SSIS SSRS SSAS Developer

• Description: ESRI geographic information systems, marketing analysis tools, and demographic data products offers powerful ways to compete in today's business environment.
• The primary role of this contract was to create ad-hoc reports for the marketing team utilizing SQL Reporting Services 2005. Extensive T-SQL queries were required in order to return the requested data requirements for email and address lists. Most ad-hoc reports were defined via email by a member of the marketing department and returned via a network location holding bucket for use in targeted marketing lists.

Responsibilities:

• Actively involved in creation of database, tables, triggers, and store procedures to clean and validate the data so as to meet the company specifications.
• Data Transformation Activities using DTS Import/ Export for transferring data with proper mapping between different databases like oracle. Designed new DTS packages as per needs, Resolve the problems.
• Designed and created cube SSAS with 10 dimensions.
• Created Measures, Dimensions and Relations between Attributes in OLAP
• Created Calculated Measures, Perspectives and Cell Calculations and Assignments in OLAP.
• Knowledge on several Dashboards and Scorecards with Key Performance Indicators KPI in SQL Server 2005 Analysis Services SSAS .
• Wrote DDL Scripts for generating Tables, Stored procedures, Views, and Functions etc.
• Ensured constraints and writing triggers to apply business rules. Designing, creating, maintaining, optimizing SQL databases, backing up and restoring user databases.
• Created Ad-Hoc Reports with SSRS Report Builder.
• Extensively used Business Intelligence Development Studio and Visual Studio VS 2005
• Created database triggers for data security.

Environment: SQL Server 2005/2000, Visual Studio, VB Script, SSIS, SSAS, Crystal Reports, JAVA Script, MDX, C .