SUMMARY:

• Over Eight years of IT experience including Data warehouse applications mainly focused in DBA and ETL/SQL architecting, modeling, designing, developing, testing and implementing.
• Proven record of successfully completing data warehouse projects through the entire lifecycle and production deployment including working with business teams in identifying system requirements and specifications.
• Excellent understanding of Application Development Life Cycle and expertise in Data modeling and Data Warehousing using Agile Methodology.
• Worked extensively with Data migration, Data marts, Data profiling, ETL Processes for data warehouse.
• Experience in working on Metadata Management.
• Expertise in Development, Performance tuning, Bug Fixing.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Fluent in SQL(PL SQL/T SQL) Coding.
• Developed complex code to load Type-I, Type-II and Type-III dimensions and facts.
• Experience in implementing Changed Data Capture ( Confidential )/Triggers.
• Excellent interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools and business environment with excellent communication and analytical skills.

TECHNICAL SKILLS:

Operating Systems:: Windows XP/2000/NT/98/95, Windows 7, UNIX, LINUX, MAC OS, Virtual Platforms Parallels

Tools: SAP Business Objects Data Services (4.2/4.0/3.2/3.1 )/Data Integrator XI 11.5, Informatica 9.x/8.x, IBM Datastage (8.0/7.5/7.1), Oracle Data Integrator, Sybase Power Designer (15.x,16.x), Toad, SQL Server

Languages: PL/SQL, T-SQL, XML, Perl, C/C++, Verilog, VHDL, Embedded C, RDBMS Database Development

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008/2012, Terradata, Sybase.

Hardware: Assemble/Disassemble PC s. Install, configure, troubleshoot and repair.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Data Architect/ETL Lead

Responsibilities:

• Development of ETL using SAP Data Services 3.2/4.2 and Informatica.9.5
• Migrating data using BODS and Informatica ETL tools. The data migration included identifying various databases where the information lay sc Confidential ered, understanding the complex business rules that need to be implemented and planning the data transformation methodology and Created, Tested and Executed data integrator jobs using designer to transfer data from source to target.
• Worked on BODS 3.2 to BODS 4.2 upgrade.
• Working on multiple projects simultaneously and completing all the tasks that are assigned on timely basis.
• Documenting existing BODS and Informatica Jobs.
• Document ETL requirements on Sybase Power Designer and Excel files.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
• Created ODBC connections and datastores in BODS and Informatica.
• Created (BO Data Integrator) mappings to read/write data into flat files and read Excel files.
• Running and maintaining Jobs in Business Objects Data services on LINUX and windows Platform.
• Debugging and performance tuning of sources, targets and mappings.
• Conducted code reviews meetings, making the team understand the complex code providing test documents and get approval.
• Wrote SQL scripts to test the data that is loaded in all instances and also worked on regression testing.
• User Acceptance Testing and bug fixing during UAT.
• Migrating Jobs from one environment to another environment and loaded data on respective environment database.
• Worked on production data migration and production releases.

Confidential, Irvine, CA

Sr. ETL Developer/QA

• Developed ETL using BODI and SQL test scripts on SQL Server.

• Worked with the team closely to understand the business process, coordinate with business analyst and developers to get specific business rules.
• Expertise in working with various transforms such as SQL, Query, Map Operation, Merge, Look Ups, Case, etc.
• Designed and implemented ETL load solutions using SAP Data Services.
• Unit tested the code multiple times to improve performance.
• Performed Job Validation and Syntax checks and Dry Run to evaluate for errors, execution time and bottlenecks.
• Developed test scripts to test the data that has been loaded.
• Migrated Jobs to higher environments through central repositories.
• Conducted code reviews to make sure the Admin and support team understand the BODI process

Confidential, Plymouth, MN

Data Architect / Sr. ETL Developer / Sr.QA

Responsibilities:

• Interacted with the director to understand the business requirements, functional requirements and data specifications and implemented the business rules to redesign and enhance the existing process.

• Modelled a process to run files and cleanse the incoming data.
• Designed and implemented ETL load solutions using SAP Data Services.
• Developed SQL queries to perform DDL, DML and DCL against databases.
• Used Data Quality transforms like Match, Data cleanse, Global Address Cleanse, USA Regulatory Address Cleanse to cleanse the given data before it is being loaded.
• Worked on cleansing and de-duplicating US and Canada Master files.
• Converted Fixed length files to delimited files and Vice Versa.
• Conducted code review meetings so the team gets familiarized with SAP DS, flow, transforms, etc.

Confidential, Minneapolis, MN

Sr. Software Developer

Responsibilities:

• Worked on Upgrading SAP Data Service from 3.2 to 4.2 as Administrator which includes in installing Information Platform Services and SAP DS Job server on server machine (Windows Server 2012), SAP DS client on client machines (Windows 7), creating central and local repositories, testing, security setup, etc.

• Worked with the users to understand and deliver as per their requirements.
• Unit tested the developed code, created test scripts and test documents.
• Debugging and performance tuning of sources, targets and mappings.
• Converted Fixed length files to delimited files.
• Converted SSIS packages to SAP DS ETL jobs.

Confidential,| Minneapolis, MN

Sr. Software Developer

Responsibilities:

• Implemented Data Mart to handle 25 years of historic data comprising of a volume of around 70 Million records from numerous source systems and building a Type-II Extended Star Schema.

• Developed code for ongoing loads using triggers on Oracle database and improved performance by lowering our jobs run time in all environments.
• Developed complex code to load Type-I, Type-II and Type-III dimensions and facts.
• Developed triggers, packages, procedures and functions using PL/SQL.
• Worked on Views, Materialized Views, packages, Database triggers and back end programming.
• Worked on Pivoting 90 forms from Vertical to Horizontal.
• Worked on Building Metadata Mart.
• Developed 175 ETL jobs, 2 materialized views, 75 views, 10 complex stored procedures to build data warehouse and 52 ETL jobs, 39 materialized views to build 2 data marts.
• Created Dependency Jobs using shell files on LINUX server.
• Migrating Jobs from one environment to another environment and loaded data on respective environment database.
• 24/7 Production Support.

Confidential, Kalamazoo, MI

Software Developer

Responsibilities:

• Involved in understanding of business processes to learn business requirements.

• Extracted data from different systems into Source. Mainly involved in ETL developing.
• Defined and implemented approaches to load and extract data from database using Informatica.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.