Summary:

• Over 7 years of administration and development experience on Database Design and Development in SQL Server 2008/2005/2000 system in OLTP and OLAP Environment.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server
• In-depth knowledge of T-SQL (DDL, DML) in creating effective Views, Functions and complex stored procedures. Experience in creating effective DML, DDL Triggers.
• Experienced in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Extensive experience in creating ETL packages using SQL server 2005/2008 SSIS.
• Expert in resolving the performance issue of SSIS packages.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS and Bulk Insert).
• Extensive experience in using different transformation e.g. Auditing, SCD, Lookups, Conditional Splits, derived column, fuzzy lookups, fuzzy grouping, script task.
• Experienced in Error and Event Handling: Check Points, Logging in SSIS.
• Experienced in creating cubes from Dimension Modeling using Fact tables & Dimension tables using SQL Server 2005/2008R2 Analysis Services (SSAS). Defined Measures, Measure Groups, Hierarchies, and Dimensions by configuring Data Sources & Data Source Views.
• Experienced in administering cubes by defining different security levels, roles.
• Created business critical KPIs using SQL ServerAnalysis Services (SSAS).
• Experienced in creating Drill Through, Drill Down, Tabular, Matrix reports, Adhoc & created charts, graphs using SQL Server 2005/2008 Reporting Services (SSRS).
• Experienced in creating jobs, Alerts, Alerts, SQL Mail Agent, and Scheduling DTS Packages.
• Involved in DBA activities such as Backups, Restores, Log-shipping, partitioning the tables, Mirroring and Replication etc.

Education: Masters in Computer Science

Skillset:
MS -SQL Server 2008/2005/2000, DB2, MS Access, T-SQL,PL/SQL SQL Server Integration Services, SQL services Analysis services, SQL Server Reporting Services, VB Script, HTML, XML,C, C++, Crystal reports 9/10/11, MS Excel, MS Visio, Erwin, SQL Profiler, Visual Basic, Windows NT/2000/XP/Server 2003

Projects Summary:

Confidential,Honolulu, HI 08/ 2010 - Present
MS SQL Server Developer/ Business Intelligence Developer
Hawaii Medical Service Association(HMSA) is aninsurance companyinHawaii. The Hawaii Medical Service Association (HMSA) is a member of theBlue Cross Blue Shield Association, an association of independentmedical insuranceproviders. HMSA covers more than half of the state’s population.
Data Management System which gives company an excellent database of its clients including Retailers, Pharmacies and Medical franchises pharmacies, Alternate care, Mail order and Hospital pharmacies. The project was to load Clients information in Data warehouse using SSIS.
Responsibilities:-

• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Implemented data staging environment in SQL 2008 for importing, parsing, scrubbing by using SSIS Packages by applying business rules, data Scrubbing using effective store procedure, UDF, views, filtering (e.g., selecting only certain columns to load) using Lookups, splitting a column into multiple columns and vice versa, using Conditional Split,j oining together data from multiple sources (e.g., lookup, merge or merge join).
• Performed Data processing optimization techniques, Using high-value targeted data staging to fuzzy lookups and data merge sources, Limiting asynchronous (blocking) Data Flow transformation usage like aggregations and sorting.
• Scheduled and maintained routine jobs, tasks, and alerts using AutoSys scheduler.
• Developed objects (i.e. tables, views and stored procedures, functions, indexes) in SQL Server 2008/2005 to get a better and faster performance.
• Defined check constraints, rules, indexes and views based on business requirements.
• Generated Sub Reports, Drill Down, Parameterized reports and matrix reports using SSRS.
• Generated reports using Global variable, Expressions and Functions using SSRS 2008.
• Responsible for designing, creating and deploying the reports into the production server.
• Generation of the weekly Drilled down Reports using SSRS for internal consumption deployed on IIS server.
• Closely worked with DBA’s and Business Needs team for deploying the packages.
• Responsible for the Performance tuning, and Optimization of procedures and queries.

Environment: Microsoft SQL Server 2005/2008/2008R2,Oracle 10i, T-SQL, Windows 2003, .net, VB, SSIS, SQL Profiler, Erwin7.2, SQL SSRS, Visio.

Confidential,Windsor, CT 02/2009 – 07/2010
MS SQL/SSIS/ETL/SSAS/SSRS Developer
CIGNA is one of the leading health care systems, which provide wide variety of health insurances. As a part of development team in Business Development department, my role was to populate data. Analyze and test cubes using SQL SSAS and to create Reports according to the business requirement using SQL SSRS.
Responsibilities:

• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in Analyzing, designing, building &, testing of OLAP cubes withSSAS 2008 and in adding calculations using MDX.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the operational data.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL

Environment: MS SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, SQL Profiler, Erwin, SSRS, SSAS, visio, Share-Point.

Confidential,MI 08/2007-01/2009
MS SQL Server BI Developer
Meijer, Inc. is a regional American hypermarket chain based in Grand Rapids, Michigan. Meijer is credited with being the first hypermarket store in the United States. My responsibility was to develop DSS and to create packages to migrate data.
Responsibilities:

• Developed SSIS packages using different sources as Teradata, Oracle, and Excel Files & Flat Files.
• Worked on automating the daily, Weekly & Monthly requests to stores by scheduling packages to run using Sql Server Agent.
• Developed complex packages using containers as For Each Loop, For & Sequence, different tasks as Execute Sql, Execute Package, File System, FTP, Send Mail & Script for controlling flow of data using transformations as Data Conversion, Conditional Split, Derived Column, Export Column, Lookup to load data in Sql Server 2005 from different sources as Teradata, Oracle, Flat Files, Excel Files & Mainframes.
• Extensively used Breakpoints, Event Handlers & logs for debugging packages.
• Created Dimension Models for cubes using Erwin by defining Fact & Dimension table’s relationships.
• Used Analysis Services for creating Dimensions using Attributes, defining Hierarchies, Levels & Measures, and Measure Groups.
• Defined Parent-Child relationships & used different properties to customize dimensions.
• Created Additive, Semi-Additive & Non-Additive measures based on business needs.
• Defined Perspectives for Cubes based on needs for a particular group of users.
• Optimized cube processing by creating separate partitions for different fact tables & more current data with separate storage modes (MOLAP, HOLAP) for performance improvement .
• Created Reports using Report Designer, Report Builder & Report Model. Generated Drill Through, Drill Down Reports using Reporting Services.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.

Environment: MS Sql Server 2005 (SSIS, SSAS & SSRS), Teradata, Informatica, Erwin, Oracle 9i, Shell Scripting, Windows Server 2003, Excel 2003.

Confidential,Chicago, IL 11/ 2005 - 07/2007
MS SQL SSIS/ SSRS Developer
BMO Harris Bankis a subsidiary of Montreal-based Canadian bankBank of Montreal. Today the bank holding company is formally named BMO Bankcorp, Inc. My responsibility was to move the data from OLTP to OLAP and also creating the reports using SSRS 2005.
Responsibilities:

• Created Packages for Transaction processing using containers as For-Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Created Reusable packages having modular structure which can be reused in other packages.
• Used Breakpoints & Event Handlers to debug packages & capture errors.
• Developed SSIS packages for developing a fully fledged data warehouse solution.
• Gained performance improvement by direct execution of packages on server.
• Defined Dimension Models based on existing fact & dimension tables in Relational Data Warehouse.
• Created dimensions by defining Parent-Child relationships, using different dimension types.
• Created Perspectives & defined security, roles for different group of users.
• Extensive experience using Report Designer, Report Builder, Report Manager & Report Model.
• Experience in creating Drill Through, Drill Down, Tabular & Pivot reports.
• Created Reports directly from Integration Services packages & Analysis Services.
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.

Environment: MS SQL Server 2005 (SSIS, SSAS, SSRS), Excel 2003, Crystal Reports, Windows Server 2003.

Confidential,Delhi, India 05/2004 - 09/ 2005
MS SQL Server Developer
Reliance Communications International Inc. is an affiliate company of Reliance Infocomm Ltd, Mumbai, India. The Project goal was to gather requirements from Business users and designed, developed and maintained the tool for making decisions depending on different scenarios.
Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed data models using Erwin.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects for optimization.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer