We provide IT Staff Augmentation Services!

Sr Etl And Datawarehouse Developer Resume Profile

Denver, CO

Professional summary:

  • 14 years of working experience in Information Technology industry with a strong background in Analyzing, Designing, Developing, Testing and Implementation of Database and Data Warehouse applications' development in various verticals such as Telecom, Retail, Sales and Supply Chain.
  • 6 years of experience in design, development and implementation of Data Warehouse/Business Intelligence Solutions, ETL using SSIS and Data stage along with Data Integration and Reporting.
  • Strong Data modeling experience using Star/Snowflake Schemas, Reengineering, Dimensional data modeling, Fact Dimension tables, and Physical Logical data modeling.
  • Experience with Data Extraction, Transformation and Loading ETL from different data sources like Oracle, MS SQL Server, etc. into a common analytical data model using SQL Server Integration Services.
  • Highly experienced in MS-SQL Server 2008 R2 and 2012 development and database Administration.
  • Strong experience in T-SQL, PL/SQL Stored Procedures and Functions.
  • Experience in performance tuning of SSIS Sources, Targets, Mappings, and Transformations developed batch processes and ETL tools to update the Data Warehouse.
  • Extensive experience in creating and maintaining database objects like Tables, Views, Indexes, Constraints, Sequence and Synonyms.
  • Experienced in SQL Server Reporting Services SSRS .
  • Extensively worked on UNIX shell scripts which were used in manipulating source data in flat File format and scheduling Datastage ETL jobs.
  • Expertise in error handling, debugging and problem solving in SSIS/SSRS
  • Highly experienced at Onsite Coordination US for requirement analysis, UAT facilitation, Production deployment and Release management.
  • Good experience in Oracle development and deployment for enterprise solutions.
  • Proficient experience in Coding, development and performance review of Month End Billing Stored Procedures for Telecom Billing solutions.
  • Currently working as a senior SSIS and SSRS developer, SQL Server DBA and release coordinator.
  • Worked 2 years for Lender Processing Services and Oversite Dataservices as a senior DBA and release coordinator with Intersoft.
  • Worked as Project manager for Merck Account Life Sciences in Cognizant Technology Solutions, Kolkata managing 4 projects in CSP vertical with MDM Technology Siperian .
  • Worked as a Senior Datawarehouse developer for Phillip Morris PMI Account in IBM, for the design-build project LERAS and BORA, End2End Datawarehousing solutions in Marketing and Sales portfolio for Cigarette manufacturing and Packaging using SSIS and SQL Server.
  • Worked for the US Telecom giant and client of IBM, AT T for their ETL development and support in their Datawarehouse solution.
  • Worked with IBM India for Walmart, in the support maintenance project as functional consultant for data analysis.
  • Actively participated in the ISO 9001:2000 Quality Audit and Certification for ITC InfoTech.
  • Possesses very well communication and written skills and good in process oriented work environment.

TECHNICAL SKILLS:

  • Database MS SQL 2008 R2/2012
  • ETL Tools SQL Server Integration Services 2012 2008 R2
  • Programming Languages C, Visual Basic 6.0, PowerBuilder 7, UNIX Scripting
  • Web ASP, HTML, VB Script, XML
  • Configuration Management Tool SVN, VS-Team Foundation Server
  • Development Tools Visual Studio.NET
  • Functional Areas Requirement Analysis, DWH Schema design
  • Reporting Tools SSRS, Crystal reports
  • Verticals Telecom, Tobacco manufacture and sales, Background
  • Check and immunization, Mortgage industry

PROFESSIONAL EXPERIENCE:

Sr ETL and Datawarehouse developer

Confidential

  • Following features have been implemented:
  • Intersoft developed a robust web application for ADB which has the dynamic rule engine which would enable them to sell drug screening packages to students prior to their joining the university. It would also help them to track and maintain the students' records for different departments and courses of a university on their immunization certificates and statuses.
  • Currently working for American Databank, who does background and drug screening for students enrolled in different universities all over the US and also does corporate background checks.
  • Sr SSIS and SSRS developer and Datawarehouse Architect
  • Pricing engine including order processing with including CC authorization and PayPal integration.
  • Multi Tenancy and Role based security.
  • Data Entry portal for Applicants.
  • Client Admin portal to verify the entries made by student.
  • Rule Engine development in SQL CLR used to implement the complex Compliance rule and UI rules for data entry.
  • SSRS reporting for clients as well as applicants
  • Migration from legacy system
  • Dashboard design using different widgets for admin and students.
  • MS Onsite coordinator, Database Admin and Release management.

Roles and Responsibilities

  • Co-ordinated Joint Application Development JAD sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
  • Coordinated offshore and onsite team.
  • Developed technical specifications for the ETL process flow.
  • Involved in architecting and Designing the Source - Target mappings.
  • Designing the OLAP database schema using Snowflake/Star schema methodology.
  • Development of ETL code using SSIS and reports using SSRS.
  • Deployment of .Net code and Database changes, UAT/production release and coordination, system testing, Jira UAT ticket management and coordination with offshore team.
  • Technologies
  • SSIS, SSRS, .NET, Visual Studio.NET 2010, MS SQL Server 2012, MVP Framework, WCF.

Confidential

Confidential legal decisioning technologies for today's dynamic mortgage servicing industry. Worked in the development of their web application which would track and maintain the court cases and court hearing dates for its clients on home mortgages.

Following features have been implemented:

  • File Ingestion with Data Scrubbing and Business Rule Implementation.
  • Multi Tenancy and Role based security.
  • Different section for different type of users like Attorney, Paralegal.
  • Multiple reports and dashboard to view case progress.
  • Scalable design to handle more loads when more Bank clients with more states will be
  • operational.
  • Migration from legacy system

Roles and Responsibilities

  • Responsible for data migration design and development.
  • Develop mapping documents for data migration from OLTP to the OLAP DB.
  • Designing and architecting the migration datawarehouse database.
  • Development of ETL code using SSIS and reports using SSRS.
  • Deployment of .Net code and Database changes, UAT/production release, system testing and coordination with offshore team.
  • Technologies
  • SSIS, SSRS, .NET, Visual Studio.NET 2010, MS SQLServer 2012, MVC.Net 4 Framework,
  • WCF.

Confidential

Sr ETL and Datawarehouse developer

Confidential a giant in Home mortgage industry, for their newly .Net Web Application LPS. This application would let LPS track and maintain the recovered houses taken over by the banks, who in turn are the clients for LPS and maintain it through its big network of vendors and services. LPS would engage verification inspectors to check the condition of the houses and upload and store photos the vacant properties. The vendors would then visit and maintain those houses for further auctioning of the property.

Following features have been implemented:

  • Role based security.
  • Data Entry portal for admin and users.
  • Photo upload and retrieval using Atmos.
  • Supplier management
  • Supplier/contractor bidding and pricing.

Roles and Responsibilities

  • Responsible in Datawarehouse architecture and involved in data migration and design.
  • Developed and maintained ETL Data Extract, Transformation and Loading mappings to extract the Data from source OLTP system.
  • Designing the OLAP database schema using Snowflake/Star schema methodology.
  • Developed reports using SSRS.
  • Deployment of .Net code and Database changes, UAT release and coordination, UAT ticket management and coordination with offshore team.

Technologies

  • .NET, Visual Studio.NET 2010, MS SQL 2012, SSIS/SSRS.

Confidential

Sr. Developer

Project: MDM Solution

Worked for Merck MDM in MDM-CRM practice, 1 support project for US and the Europe and 3 other development projects for US and China.

Roles and Responsibilities

  • Development and design of MDM application using SSIS
  • Mapping source and target.
  • Testing of ETL and end data as data Stewart.

Technologies

  • SSIS as ETL tool and Siperian as MDM tool in Solaris box.

Confidential

Senior System Engineer

Confidential

Worked with Wal-Mart Inc as MDM Functional Data Analyst for the support of their MDM application, PROFIT.

Responsibilities

  • Requirement Gathering and Requirement Analysis.
  • Remedy ticket management.

Technologies

  • Lombardi, Datastage 8.0, WCC.

Confidential

Worked in the Design Build Datawarehousing project LERAS for PMI for their Cigarette manufacturing, logistics and packaging solution. It is an End2End Datawarehousing developed in SSIS 2008 ETL and BO as reporting with SQL Server 2008 DB as the backend database.

Responsibilities

  • Performing data analysis and gathering business requirements.
  • Datawarehouse Schema Designing and ETL development using SSIS.
  • Test Case creation.
  • Technologies
  • SQLServer 2008, SQL Server SSIS packages ETL 2005
  • Worked in the Confidential project for PMI. It's an End 2 End Datawarehousing solution to PMI in Marketing Sales and Services domain and its market worldwide with input source OLTP system, iSMS which is the front end for the application.

Responsibilities

  • Requirement Analysis, Review, Planning and Effort Estimation.
  • Designing the OLAP database schema using Snowflake/Star schema methodology.
  • Responsible for development of SSIS packages and T-SQL objects.

Sr ETL and Datawarehouse developer

  • SQLServer 2005, SQL Server SSIS packages, Business Objects and MS OLAP 5.0

Confidential This is a project developed for Data warehousing where data from different sources of Confidential legacy systems are systematically migrated into GCP platform for further analysis and decision support.

Responsibilities

  • Communicating with the client to understand the design of the requirement.
  • Responsible for developing code in Ascential Datastage.
  • Developing shell scripts and running the cron scheduled jobs.
  • Responsible for unit testing of the end product.
  • Preparation of different required documentations starting from detail design doc, test cases and deployment docs accompanied with the peer review logs.
  • Responsible for peer review of work items including code and quality documents.
  • Responsible for doing End To End review of the projects under supervision.
  • Development verification/code review.
  • Technologies
  • Ascential Datastage, ORACLE 10g, UNIX
  • Confidential reporting was done using these data from the dimension and the fact tables using web based application using JSP.

Responsibilities

  • Responsible for mapping the Fact and Dimension tables.
  • Responsible for mapping the tables of Unicorn DB with the Fact and Dimension tables.
  • Responsible for developing the jobs for populating the data into the Fact and Dimension tables from unicorn live DB using Ascential Datastage
  • Technologies
  • Ascential Datastage, ORACLE 9i
  • Confidential front-end and Sybase as the database, for Telecom Service Providers.
  • Huge no. of functionalities an services can be achieved with the help of this software starting from giving basic customer care support, registering a new customer, activating its basic Telephony Services and other Value added Services to collecting deposits, doing rating on the CDRs, generating and printing bills and maintaining accounts and payments and many more. Unicorn also supports roaming.
  • Clients: Aircel is the 1 Telecom Service Provider in Tamilnadu and having more than 1 million subscribers. Unicorn 2.3 has been implemented at Aircel for their post paid billing services
  • Multilinks and Benin Telecom in Africa, Seychelles Telecom in Seychelles, etc

Responsibilities

  • At onsite BAP support and maintenance for Aircel site at Coimbatore for Unicorn 2.3.
  • Responsibilities included bug fixing, enhancement, testing, coordinating with offsite support and implementing solutions of Unicorn 2.3 in the production server of the client.
  • At offsite support and maintenance for the African clients for Unicorn 2.3.
  • Actively involved in writing the SQL, PL/SQL queries containing the business logic for the reports.
  • Technologies
  • PowerBuilder 6.0, C , Sybase

Hire Now