Skills

Please use this table to list the skills noted in the Required/Desired section of the Peoplefluent requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

ETL developer

Responsibilities:

• Database development activities including database and database object creation in a SQL Server environment.
• Interpretation of business and logical models, and implementation of physical models for data warehousing using standard methodologies, such as top-down and bottom-up design strategies.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Extensive ETL design, planning, implementation, testing, and documentation utilizing standard ETL tools like SSIS, SSRS SSAS.
• Integration of legacy systems and data sources into a single data warehouse model, plus the addition of newly-defined data sources and data feeds into the data warehouse.
• Implemented multi dimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Production of design documents and other documentation for internal use and for client consumption throughout the development lifecycle.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the slowly changing transformation, to maintain historical data in data warehouse.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Direct supervision of a team of developers and other technical staff to accomplish tasks.
• Work with other SSIS Architects, business analysts BAs , project managers PMs , relationship managers PMs , sales, and other staff to ensure smooth implementation and integration of all components on large-scale projects
• Wrote Excellent scripts to provide solution using T-SQL commands.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using Execution Plan.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed and created views for security purposes, implemented rules, defaults, and User defined data types.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture
• Extensively used command prompt application using SQLCMD.

Environment:

MS SQL Server 2008, SSIS 2008, SSRS 2008, JavaScript, Sql Profiler, Data Analyzer, Crystal Reports, C , .net, Microsoft Excel, Windows server 2003, ERWIN

Confidential

ETL developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Created new logical and physical database design to fit new business requirements and implemented it to the SQL Server 2008
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Maintained 6000 tables, 60,000 stored procedures, 3000 views and 1700 triggers.
• Worked with project lead, analyst, and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Highly responsible for development and management of SSIS, SSAS and SSRS projects.
• Created ad-hoc queries and reports for unit team lead as requested and provide on-going analytical support for these requests.
• Formulated and documented the physical SSIS process design based on business requirements and system specifications with strong SSIS design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components
• Worked with Tabular reports, Matrix reports, Gauges Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using sql server reporting services SSRS .
• Designed and developed report with Running value, interactive sorting as well as conditional formatting using SSRS
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created sub-reports to present more detailed information about the summary.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multi dimensional views for data analysis.
• White paper on Integrating hub and spoke with point-to-point architecture.
• Performed efficient database optimization using SQL Server Profiler, Graphical execution plan and wrote database objects Stored Procedures, Views, User defined functions, Triggers etc .

Environment:

MS SQL Server 2008, SSIS 2008, SSRS 2008, JavaScript, Sql Profiler, Data Analyzer, Crystal Reports, C , .net, Microsoft Excel, Windows server 2003, ERWIN

Confidential

ETL developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Implemented SQL standards in writing Stored procedures, Triggers, Views, Sql functions and locking issues
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards
• Responsible for creating reports based on the requirements using SSRS 2005.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture.
• Implemented Star Schema for OLAP cubes using SSAS.
• Created Packages to group logically related column types and to transfer data.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Designed both logical and physical data models in Erwin r 7.2.

Environment:

MS SQL Server 2008/2005 Enterprise Edition, .Net 3.0, SQL BI Suite SSAS, SSIS, SSRS 2008/2005, MS Excel, Windows Server 2003, Crystal Reports, SQL Profiler, Data Analyzer, ERWIN

Confidential

ETL developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with Aegis Data warehouse ADW including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Wrote Technical Design Specifications, ETL workflows and Source to Target Mapping STTM spreadsheets for each legacy system interface with ADW.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2005.
• Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the ETL process.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.
• Developed and implemented partitioning and security in cubes based on user roles.
• Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.
• Designed MDX expressions/queries for accessing cubes involved in query structuring and performance optimization.
• Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture.
• Developed complex canned reports using SSRS 2005 from multiple data providers in Underwriting and Claims systems, User defined objects, Aggregate Aware Objects, Charts and synchronized queries.
• Conversion of Crystal Reports to Reporting Services and also existing SAS reports to Reporting Services 2005.
• White paper on Integrating hub and spoke with point-to-point architecture.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, and Execution Plan and Index Tuning wizard.
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.

Environment:

MS SQL Server 2005/2000, T-SQL, SSIS 2005, DTS, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access, Crystal Reports 9/10.

Confidential

ETL Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multi dimensional views for data analysis.
• Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Used SSIS to implement the slowly changing transformation, to maintain historical data in data warehouse.
• Created Views to reduce database complexities for the end users.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS.
• Generated ad hoc reports using MS Reporting services and crystal reports.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating Indexes.
• Used the HTML code to make the report manager more functional and customizable.

Environment:

SQL Server 2005, DTS, SQL Profiler, T-SQL Windows 2003 Server, ASP.NET framework, MS Project, Performance Tuning

Confidential

ETL Developer

Responsibilities:

• Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.
• Developed Technical Design specifications and Source to Target Mapping STTM specifications for each legacy system interface with Enterprise system.
• Designed and developed physical and logical Data Models using Erwin and developed SQL Server Database objects including Tables, Views and Indexes.
• Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database.
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on the fly.
• Designed and implemented Job scheduling, setting up alerts, User logins and access rights based on user roles, permissions and security requirements.
• Analyzed and designed disaster recovery and replication strategies based on business requirements.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.

Environment:

MS SQL Server 2000 Enterprise Edition, T-SQL, Windows Server 2003, .net, C , Microsoft Excel, Visual Studio, JavaScript, asp.net.