EXPERIENCE SUMMARY:

• Highly Skilled on handling end - to-end Data warehousing projects and implementation in various capacities.
• Excellent in Organizational Skills, client relationship, people management, project planning & estimation.
• Ability to guide and manage medium to large teams
• 18+ Years of experience in Data Warehouse and Client Server(2-tier, 3-tier architecture) solutions in various roles as a Data Architect(Kimball and Inmon approach), Lead, Systems Analyst and Technical Mentor.
• Dimensional (OLAP) and OLTP Data Modeling experience using Star Schema, Snowflake schema and 3 NF modeling(Logical and Physical) using tools Erwin 4.x and Visio.
• Good knowledge on Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice versa.
• Hands-on experience with various Data Integration platforms such as Informatica Power Center 9.x/7.x/6.x/5.x, DataStage 11.3, SQL Server Integration Services.
• Involved in L1 and L2 application support, Issue analysis, Identification of bug and the workaround. Response to functional queries, Understanding & analysis of user requirement for minor enhancements.
• Experience with Business intelligence reporting systems Business Objects 6.0, Cognos 8.x and SQL Server Reporting Services 2000/2005.
• Excellent working knowledge with Oracle SQL and PL/SQL, DB2 UDB, MS SQL Server and Teradata SQL(DDL & DML), Stored Procedures, Triggers, Performance related transactions and DTS services.
• Worked in Banking, manufacturing, Telecom, Pharma domains.
• Executed all phases of the Software Development Life Cycle(SDLC).
• Superior communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.

SKILLS/TOOLS:

Data Modeling: Erwin 8.x, Oracle Designer, MS Visio 2000/03/05

ETL: Informatica Power Center 9.x/7.x/6.x/5.x, Informatica Data Quality, DataStage 11.3 and Business Objects Data Integrator.

Business Intelligence: Business Objects Desktop and Web intelligence, Cognos 8.2,OBIEE, SAP-BW 3.1/4.7/7.0. , SQL Server Reporting Services 2000/20005, Crystal Reports.

Database: Oracle 10g/9i/8i, DB2, SQL Server 2005/2000/7. x, Teradata13.0, MS Access.

BigData technologies: Map Reduce,MongoDB, HDFS, Hive 2.4, SQOOP1.4, Flume, Scala and Spark.

No SQL data bases: HBase.

Tools: & Utilities/Others: Control-M, Visual Studio 6.0/2003/2005 , SQL *PLUS, MS Office 2000/2003, Visual Source Safe,, TOAD 7.5, AutoSys.

Languages: SQL, PL/SQL, Visual Basic 6.0, ASP 3.0,, Unix/Linux Shell Scripting for Scheduling Informatica Jobs

Operating Systems: HPUX 11.11i, MS-DOS, Windows 95/98/2000/NT/XP and Sun Solaris UNIX.

Exposure/Trained in: C, C++, SQL Server Integration Services

PROFESSIONAL EXPERIENCE:

Confidential, RTP, NC

ETL Architect / Data Modeler

Responsibilities:

• Analyze and Review the Business Specification Documents, Interacted with the business user to collect requirements.
• Prepared the flow documentation for conversions.
• ETL Process design, specifications and development of mappings.
• Manage day to day ETL development activities and data loads.
• Extensively worked in the performance tuning of programs, ETL procedures & processes.
• Data analysis and validation, understanding the data quality issues.
• Created and documented Logical Data Model(LDM) and Physical Data Model(PDM) using Erwin.

Environment: Informatica 9.1, Oracle 10g, UNIX, Autosys, Core FTP & Windows XP

Confidential, Charlotte, NC

ETL Architect / Data Modeler

Responsibilities:

• Analyze and Review the Business Specification Documents, Interacted with the business user to collect requirements.
• Data analysis and validation.
• Designed ETL processes and mapping specification documents for ETL requirements
• Developed custom technical artifacts such as coding standards, technical specification, test specification.
• Designed & development of ETL mapping, workflows.
• Involved in data base development activities like procedures, function and triggers.
• Performed ETL Administrator jobs like maintaining Folder/User level Privileges, Stop and Restart the services.
• Resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Processed data into HDFS by developing solutions.
• Analysed the data using Map Reduce, Hive and produce summary results from Hadoop to downstream systems.
• Worked extensively with HIVE DDLs and Hive Query language (HQLs).
• Developed UDF, UDAF, UDTF functions and implemented it in HIVE Queries.
• Implemented SQOOP for large dataset transfer between Hadoop and RDBMs.
• Used Sqoop widely in order to import data from various systems/sources (like MySQL) into HDFS.
• Created components like Hive UDFs for missing functionality in HIVE for analytics.
• Developing Scripts and Batch Job to schedule a bundle (group of coordinators) which consists of various.
• Exported the analysed data to the relational databases using Sqoop for visualization and to generate reports for the BI team.
• Involved in ETL, Data Integration and Migration.
• Used different file formats like Text files, Sequence Files, Avro.
• Assisted in creating and maintaining Technical documentation to launching HADOOP Clusters and even for executing Hive queries.
• Assisted in Cluster maintenance, cluster monitoring, adding and removing cluster nodes and Trouble shooting.

Environment: Erwin 8.6, Informatica Power Center 9.1, DataStage 11.3, Oracle 10g , Hadoop, Map Reduce, HDFS, Sqoop1.4, LINUX, Hive2.4, Hbase, Hadoop Cluster and JAVA, Tableau 9.3

Confidential, Charlotte, NC

ETL Architect/ Data Modeler

Responsibilities:

• Involved in requirement collection, analysis and design .
• Created and documented Logical Data Model(LDM) and Physical Data Model(PDM) using Erwin.
• Data analysis and validation.
• Involved in all data base development activities like procedures, function and triggers.
• Database tuning.
• Handling change requests, code deployments.
• Data mapping and migration of existing data.
• Experience in using Automation Scheduling tools such as Autosys
• Created and configured Workflows, Worklets and Sessions to transport the data to target using Informatica Workflow Manager and Schedule the jobs using Autosys.
• Research and develop new technologies and procedures to further streamline/automate process both within the group as well as the department.
• Coach, mentor and lead personnel within a technical team environment.
• Check environments validation after regular OS and DB patches

Environment: : Erwin 8.6, Informatica 9.1, Oracle 10g, UNIX, Autosys, Core FTP & Windows XP.

Confidential, Charlotte, NC

Data Modeler /ETL Architect

Responsibilities:

• Analyze and Review the Business Specification Documents, Interacted with the business user to collect requirements.
• Created and documented Logical Data Model(LDM) and Physical Data Model(PDM) using Erwin.
• Involved in writing data mining query’s and data analysis and validation.
• Designed ETL processes and mapping specification documents for ETL requirements
• Developed custom technical artifacts such as coding standards, technical specification, test specification
• Designed & development of complex informatica mappings and mapplets.
• Involved in ETL design, process flow, workflows and executing batch jobs.

Environment: : Erwin 8.6, Informatica Power Center 8.6.1, Oracle 10g, DB2,UNIX, Core FTP & Windows XP.

Confidential, Charlotte, NC

ETL Architect

Responsibilities:

• Involved in requirement collection, analysis and design.
• Designed Conceptual data model.
• Created and documented Logical Data Model(LDM) and Physical Data Model(PDM) using Erwin.
• Data analysis and validation.
• ETL Process design, specifications and development of mappings.
• Manage day to day activities and data loads.
• Designed ETL processes and Created Technical specification documents for ETL requirements
• Coordinate with the DBA to modify existing database objects.

Environment: Erwin 7.3, Datastage 9.1, Oracle 10g, UNIX, Core FTP & Windows XP.

Confidential, Charlotte, NC

Data Modeler

Responsibilities:

• Analyze and Review the Business Specification Documents, Interacted with the business user to collect requirements.
• Designed Conceptual data model.
• Created and documented Logical Data Model(LDM) and Physical Data Model(PDM) using Erwin.
• Data analysis and validation.
• Designed ETL processes and Created Technical specification documents for ETL requirements
• Developed custom technical artifacts such as coding standards, technical specification, test specification
• Involved in ETL design and development activities.
• Designed & development of complex informatica mappings and workflows.
• Coordinate with offshore team.

Environment: : Erwin 7.3, Informatica Power Center 8.6.1, Oracle 10g, Teradata, UNIX, Core FTP & Windows XP.

Confidential, Piscataway NJ

ETL Lead Developer

Responsibilities:

• Analyze and Review the Business Specification Documents, Interacted with the business user to collect requirements.
• Worked with significant number of conversions with legacy systems, to meet global and business requirements.
• Prepared the flow documentation for conversions.
• ETL Process design, specifications and develop the test cases.
• Manage day to day activities and data loads.
• Extensively worked in the performance tuning of programs, ETL procedures & processes.
• Coordinate with offshore team.

Environment: Informatica Power Center 8.6.1, Power Exchange 8.6.0,SAP (BAPI/RFC's, IDOC's), SAP Logon, IDE8.6.0, IDQ8.6.0, Oracle 10g, Erwin 7.3, Mainframe, DB2, SQLSERVER 2005, UNIX, Core FTP & Windows XP.

Confidential, Sandiego, CA

ETL Lead Developer

Responsibilities:

• Involved in gap analysis and requirements collection.
• Analyzed and Reviewed the Business Specification Documents.
• Designed data model and ETL processes for daily and weekly batch processes.
• Created and documented Logical Data Model(LDM) and Physical Data Model(PDM) using Erwin.
• Created Technical specification documents for ETL requirements
• Developed custom a technical artifacts such as coding standards, technical specification, test specification
• Facilitated and supported Functional unit test, Integrated test cycles 1, 2, and 3.
• Successfully implemented configuration management while moving the development objects into quality and subsequently into production systems
• Involved in ETL design and development activities.
• Designed & development of complex informatica mappings and workflows.
• Coordinate with offshore team.
• Data analysis and validation.

Environment: Informatica 8.5, Toad 8.0, Oracle 10G, PL/SQL, UNIX, Cognos 8.2, Business Objects 6.5, Win XP, UNIX and Oracle

Confidential, Rochester, NY

ETL Sr Developer

Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Created Technical specification documents USCR and CI.
• Analyzed and Reviewed the Business Specification Documents.
• Used SQL Developer tool to issue SQL commands matching the business requirements for loading and creating and analyzing tables.
• Cognos User administration.
• Day to day operational support activities.
• Implemented onsite-offshore model for 24X7 production support.
• Coordinate with offshore team.
• Data analysis and validation.
• Handling change requests.
• Data analysis and validation.

Environment: : Informatica 7.1, Toad 8.0, Oracle 10G, PL/SQL, UNIX, Cognos 8.2, Report net MR2, Trillium, VSS, Frame work manager, Win XP, and UNIX.