We provide IT Staff Augmentation Services!

Ssis Developer Resume

Vernon Hills, IL

PROFESSIONAL SUMMARY

  • Almost 8 years of experience in all the phases of the Data warehousing and Business Intelligence solution life cycle. Coherent with Data Cleansing, Data Conversion, Performance Tuning, System Testing. Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
  • Microsoft Certified Professional – SQL Server 2000 Design and Implementation70-229
  • Expertise in using SSIS, SSAS, SQL Server reporting services for Authoring, Managing and Security.
  • Strong knowledge in Microsoft mining and implement solutions by MS Analysis Services.
  • Designed FACT & Dimensions Tables, Physical & Logical Data Models using ERWIN Tool.
  • Expert on Star, Snowflake, and Unified data models, Normalization and De-normalization.
  • Hands on experience in implementing object oriented methodology and other techniques.
  • Ability to work effectively in fast paced Environments.
  • Designed and developed enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
  • Experienced in generating on-demand (ad-hoc reports) for business analysis or management decision using SQL Server Reporting Services.
  • Experience in various Database Design techniques, Data Modeling, Creating ER Diagrams using tools such as Visio and Erwin
  • Designed and developed more than 50+ enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources
  • Extensive experience in performance monitoring and tuning, troubleshooting, enterprise level replication. Knowledge of extracting and transforming data using tools like SSIS, BCP, DTS and Linked Server.
  • Experienced in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills

PROFESSIONAL EXPERIENCE

Confidential,Vernon Hills, IL Oct 10– Sep 11
SSIS Developer
The BI team wanted to create “cohort” files that will be used for Direct Marketing team Analysis tool. A cohort is a group of customers and/or prospects that have unique characteristics. Each cohort will receive a different set of marketing activities. The performance of each cohort will be measured by Ogilvy

  • As in team of Enterprise Analytics, responsible for the designing and developing ETL packages to support various reporting goals for internal and external clients.
  • Created Data Models for the Cohort Files using ER Studio.
  • Expertise in handling ETL loads on various RDBMS and POS system like SQL Server, Oracle, DB2 and AS400.
  • Created SSIS packages to extract data from Excel and CSV files and Populated Sql Server Tables.
  • Created Complex Rekeying Scripts to follow the Business rules and specifications.
  • Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development.
  • Expertise in troubleshooting ETL packages.
  • Manage customer expectation by clearly documenting and maintain project deliverables, plans and status throughout the life of project as per company standards.

Environment: MS SQL Server 2008 Enterprise Edition, SSIS 2005, MS SQL Server Analysis Services, Visual studio 2008,T-SQL, BIDS, MS Excel, Visio, ERStudio, Analysis Service, Data Analyzer, Windows NT, ETL Tools.

Confidential,Market Street, PA Mar 10 – Aug 10
Senior SQL Server Developer
SSIS/SSRS Developer
Lincoln Financial Group (LFG) is one of the leading financial companies around United States in retirement plans, mutual plans and annuities. LFG offers services to company and employer with need in retirement plan 401K mutual plan and annuities. My project was to automate the migration of data from DDL to the Data Mart using various ETL tools like SSIS, SSAS and to create reporting dashboard.

  • Continuously interacted with end user to gather business requirements.
  • Deployed and configured the reports in the Report Server.
  • Created Subscription of Reports in different formats like PDF, Excel, etc. to be executed automatically on weekly or monthly basis.
  • Efficiently created charts using DunDas tool in SSRS.
  • Involved in full reporting cycle from design to security.
  • Used SSIS\'s fuzzy grouping functionality for naming standardization and cleaning.
  • Implemented SSIS Packages with various Task & Containers and deployed them
Designed and implemented ETL processes to make data available for reporting purpose within a data warehouse.
  • Experience in designing, creating, processing of cubes using SSAS.
  • Expert in calculating measures and dimension members using multi dimensional expression (MDX).
  • Used SharePoint to create a portal that stores the various dashboards in SharePoint document libraries.
  • Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
  • Prepared stored procedure, views, scripts and triggers to be pivoted and executed for the reporting purpose.
  • Involved in creating Internal and External reports based on the business request and ad-hoc requirements using SSRS 2005/2008.
  • Work on analyzing of data to prepare Executive summary report using charts, Graphs and Gadgets.
  • Create Unit Test script for all stored procedure, views and triggers to make sure working on the business logic and requests.
  • Populate reports into SharePoint portal site from SSRS.
  • Create dashboard and scorecard systems using Performance point server.
.

Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Server Reporting Services 2008, MS SQL Server Analysis Services, Visual studio 2008,T-SQL, BIDS,SSRS, MS Excel, C#.Net, MS Access 2000, Visio, Erwin, Analysis Service, Data Analyzer, Windows NT, ETL Tools.

Confidential,Bloomfield, CT March 09 – Aug 09
SSIS\\SSRS\\SSAS Developer
SalesForce.Com is a project of migration of data from Oracle 10 to SQL Server 2008. This Project was initiated because of Great West Merging with Cigna. The Scope of this project was to create a centralized application Sales Force.Com, after merging.

  • Under general direction develop, design, document and evaluate Business Requirements.
  • Design Process and deliver design specifications.
  • Created SSIS Package that implements Logging, Event Handling, Configuration files.
  • Document all the Data Mapping, Data Flow documents for migration.
  • Developed SSRS Report according the business needs. Incorporated Drilldown, Linked and Sub report functionality.
  • Created materialized views in Oracle to migrate data from Oracle to SQL Server using SSIS.
  • Created batch jobs to and implemented windows scheduler to schedule the SSIS packages to run on daily basis.
  • Created Fallout reports, Log reports for these SSIS packages, which helps in easy maintenance.
  • Link the SSRS Reports to ASP.NET pages.
  • Wrote MDX queries and created OLAP report sourcing from SSAS cube.
  • Created and updates cubes (measures, dimensions, hierarchies, relationships), defined calculation (calculated members, named sets), KPIs, perspectives using SSAS and MDX.
  • Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.
  • Excellent hands on experience in creating groups and measures, KPIs.
Designed, administrated and developed Star Schema Data marts.
  • Created Complex SSIS packages which incorporate C# code to open excel application and write data in a specific cell, using OXPPI (Office XP Primary Interop Assembly).
  • Followed Change Management procedure and documented coding policies and naming conventions used in Proc’s & Packages.
  • Generated .net application that involves, using third party tool ASPOSE.
  • Followed SDLC implementation methodology and version control using VSS.

Environment:
MS SQL Server 2005,2008, Visual studio 2008, SSIS, SSRS 2008, ER-Win, Visio, Crystal Reports 11, ADO, ODBC, ASP.Net, C#.Net, Oracle 10g.

Confidential,Wallingford, CT Nov 08 – Feb 09
SQL Server Developer/ SSRS, Crystal Report Writer
Gen8
CheckFreePay provide a means for bill payers to pay certain of their bills in person at any of more than 11,000 locations across United States. CheckFreePay establishes relationship with the biller, then set up agents who pay on CheckFreePay behalf, then forward the money and billing data. Gen8 is the application which enables to do this process.

  • Under general direction develop, design, document and evaluate database systems
  • Maintain structural design of various databases, including back-end databases for database-driven Web sites, based upon logical data models by employing program and business requirements and analysis
  • Imports data to existing databases; develop standards and procedures;
  • Involved in Design and development of the different reports and Dashboards for various application.
  • Designed and maintained the SRP reporting environment.
  • Used SSIS extensively to migrate and transform data from legacy database system.
  • Involved in creating complex packages with Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the report.
  • Created Tablix Reports which has the flexibility of the table region and the crosstab reporting features of the matrix region.
  • Embedded different cross tab report with independent Group Aggregate into one module using Navigation and Linked report feature of the report builder.
  • Used sub reports functionality for complex report calculations and added .net code for user friendly reports.
  • Created shared data source, implemented expression using iff, switch etc to display calculated values in each cell.
  • Created stored Proc which spans rows across different tables in different servers using OpenRowset and Openquery.
  • Ability to manage projects from planning through execution/completion under the pressure of fast-paced, time-sensitive environments.

Environment:
MS SQL Server 2005,2008, SSIS, SSRS 2008, ER-Win, Visio, Crystal Reports 11, ADO, ODBC, C#.Net, Autosys, Millennium and IIS.

Confidential,Mason, OH Jun 08 – Sep 08
SQL Server Developer/ SSAS/Report Writer
Anthem Sales Compensation System (ASCS)
Anthem Blue Cross and Blue Shield is a subsidiary of WellPoint Inc. Now one of the largest healthcare providers, WellPoint, Inc. provides health care benefits to more than 28 million individuals. The Project ASCS was launched to correct the defects, and for the enhancement of CQ items regarding modification to company’s policy, Claims processing, Creating new process for mass load of data to reduce the amount of keying and increase accuracy to provide the faster processing of the manual premiums.

  • Involved in Design and development of the different reports in Sales Dashboards for various sales application.
  • Designed and maintained the reporting environment.
  • Implemented dynamic sorting in report columns during runtime, which is a very useful feature for end users.
  • Used sub reports functionality for complex report calculations.
  • Created parameterized report either passing parameter through report screen or through URL.
  • Implemented SSIS Packages with various Task & Containers and deployed them
  • Re-buildSSAS in SQL Server 2005 including Dimension model, Star Schema, Fact tables, Dimension tables, Cubes and writing MDX expressions for cube calculations and KPIs.
  • Identified and created Data Source Views for OLAP cubes.
  • Defined advanced attribute and dimensions properties in SSAS for OLAP cubes.
  • Identified and defined Fact relationships in SSAS for OLAP cubes.
  • Defined unknown members and null processing properties for OLAP cubes.
  • Defined Granularity within a measure group and drill through actions for cubes.
  • Wrote MDX queries for the Business Intelligence Solution.
  • Created complex stored procs & UDF’s to perform for various .net application developments.
  • Migrated data from Access database to MS SQL server and involved in various SQL script development.
  • Created reports which change their background color dynamically depending on the input report parameters.
  • Deployed and configured the reports in the Report Server.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, T-SQL, BIDS,SSRS, MS Excel, VB.Net, MS Access 2000, Visio, Erwin, Analysis Service, Data Analyzer, Windows NT,

Hire Now