SUMMARY

• Fifteen Years hands - on experience in Software Development; architecting, analysis, design, development of data warehousing business systems wif expertise in Pharmaceuticals, Retail, E-Commerce, BFSI and Manufacturing, tourism domains.
• Strong noledge of dimensional modeling and data warehousing best practices.
• Ability to gather business requirements from teh Business Analysts and transform into functional requirements. Deep understanding of challenges wif data management, data acquisition, data integration and data quality architecture.
• Creating Schemas, building logical and physical models using ERWIN.
• Extensive experience in architecting, developing and managing full life cycle of ETL deliverables.
• Informatica administration & upgrades. Extensive noledge in performance tuning and advanced Informatica features.
• Hands on noledge as a senior ETL developer using Informatica tool on multiple projects.
• Extensive noledge as BI and report developer using various tools like COGNOS, Business objects, etc.,
• Architecting teh data warehouse solution for industries like retail, healthcare, pharma, e-commerce and food product companies.
• Expertise in in ETL tools Informatica, Sql Server DTS/SSIS, Sagent ETL, Talend and PL/SQL, BTEQ and MLOAD scripts.
• Hands on experience on Informatica CDC, IDQ, MDM
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, Teradata, DB2, Flat files and XML, XML parsing, XML source files & UNIX.
• Expertise in installation of Informatica, configuration, performance tuning, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into teh staging area and Design ETL processes that span multiple projects
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Training noledge on BIG DATA - Hadoop, MapReduce, PIG, HIVE.
• Strong experience managing team, estimation, AGILE, SCRUM process, escalation handling and handling onsite-offsite model.

TECHNICAL SKILLS

Operating System: UNIX (IBM AIX, Sun Solaris, HP UX), LINUX, Windows 2000/NT

Languages: SQL, PL/SQL, Korn Shell, BTEQ,PERL,XML

DB/Utilities: Teradata 14, Oracle 9i/10g/11g, SQL Server 2000, MS-Access, DB2, MLOAD,FASTLOAD,TPUMP,TPT

ETL Tools: Informatica 8.6/9.1,9.5,9.6

BI Tools: COGNOS, BO, TableauOracle GUI Tools Toad, ERWIN, SQL Developer, PL/SQL Navigator

Modelling Tools: ERWIN, VISIO

Documentation Tools: MS Word, MS Excel, HP ALM, VSS.

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. Datawarehouse developer/Architect

Responsibilities:

• ETL(Informatica) and BI(COGNOS) process development for various departments like RMS, International, Inventory and Planning in AEO.
• Working wif business requirements and will act as a business/technical analyst to identify and understand source data systems.
• Creating and maintaining standard development life cycle documentation as part of all development project tasks.
• Building ETL process using Informatica 9.6.1 /9.1.5 tool.
• Estimated and designed teh ETL process based on teh requirements specifications.
• Accessing data from various sources like relational, XML, COBOL, Unstructured data.
• Developing medium and complex Mappings, Workflows creation
• Promoting to production and scheduling by using teh Scripts and Control-M
• Creating shell scripts to handling files transfer from source system and dropping teh extract to Internal partners designated file location.
• Creating wif Informatica Data Quality (IDQ) in teh discovery and coding of cleansing, de-duping and enrichment processes used to enhance teh quality of information
• Understand data quality requirements and recommends/develop solutions to meet those needs.
• Analyze, troubleshoot, diagnose data quality workflow issues; recommend and implement appropriate solutions.
• Provide high quality detailed analysis, design and build processes to support specific projects wif regard to Data Quality profiling and DQ rule coding
• Perform data gathering, data profiling, data quality assessment, and data mapping.
• Ensure data quality solutions are fit for purpose and deliver against business requirements.
• Building process for data cleansing and create teh data environment for MDM.
• Building process using teh fast Export, Multi Load utilities of Teradata.
• Extensively wrote BTEQ scripts in Teradata
• Adapt ETL processes to accommodate changes in source systems and new business user requirements.
• Performance tune new/existing programs that load data into teh data warehouse.
• Map source system data to data warehouse models, meet wif Data Modelers and DBAs to review design strategies for new ETL processes.
• Created basic and advanced reports and dashboards usingCognos
• Strong technical analytical skills and an ability to provide creative solutions to problems.
• Participate in certain aspects of business user consulting, system analysis, and general system designs.

Environment: IBM Cognos 10.2.1/10.2.2 (Framework manager, Analysis Studio, Report Studio), Informatica 9.1.5/9.6.1 (Powercenter,Repository Manager, Mapping designer,Workflow Manager,etc), XML, Iseries, ERWIN, Teradata, MLOAD,BTEQ,FASTLOAD,TPT, Oracle 11g, Linux, Windows, PLSql, Shell Scripting, XML, XML parsing, XML source files.

Confidential, TN

ETL Architect - Informatica Powercenter/IDQ

Responsibilities:

• End to end responsibility of deliverables.
• Developed ETL processes using Informatica extract data from SAP,DB2,Oracle,SQLServer and flat files
• Performed data analyst role to do data profiling, data mapping, data validation, data manipulation, data analysis, use case, test cases, etc.
• Used IDQ extensively in Data Cleansing techniques
• ImplementedIDQ dataqualityassessments and implementations includingdatadiscovery, standardization, data cleansing, address validation, matching, consolidation, bad record management
• Working wif Business team in defining Data quality rules and coordinating wif development teams of source systems in fixing data quality issues using IDQ.
• Interface directly wif teh customer and business owners to document functional and business requirements.
• Articulate requirements, make recommendations for process and business flows, develop consensus on requirements, and document requirements via teh approved process and templates.
• Creating artifacts for HLD, LLD.
• Developed error handling based on teh data quality requirements.
• Prepare deployment process and code migration from development to QA, QA to Production.

Environment: Informatica 9.5.1/9.1.5, Power Center, PowerExchange, Repository Manager, Mapping Designer, Workflow, IDQ, SAP R3, SQLServer 2008, 2012, Oracle 11g, TSQL, DB2, Unix, Windows.

Confidential, PA

ETL Lead

Responsibilities:

• Worked as Onsite Lead and managed Off shore team.
• Develop ETL process using informatica 9.6.1 to load Dimension and Fact tables.
• Analyze teh existing PL/SQL codes and create teh mapping logics for data migration.
• To build error handling based on teh data quality requirements.
• Prepare deployment process and code migration from dev to QA, QA to Production.
• Create Source to Target mappings document, design documents, configuration and support documents.
• Maintain coding standard and reusability in teh objects created in informatica.
• Working wif DBA to improve teh performance of teh ETL Process.

Environment: Informatica 9.6.1/9.1.5, Oracle 11g, PL/SQL, UNIX Scripts, TIBCO, UNIX, Windows, COGNOS 10.2.1, ERWIN

Confidential, FL

Sr. Informatica developer

Responsibilities:

• Create high and low level ETL design to meet user requirements.
• Create other ETL artifacts such as functional requirement document, design documents and deployment document etc.
• Independently develop complex Informatica mappings, sessions and workflows as per teh design specifications.
• Deploy and Support production ETL jobs.
• Report development using Tableu.
• Evaluate, determine root cause and resolve production issues.
• Propose, implement and adhere to best practices, standards and processes.

Environment: Informatica 9.0.1/9.1.6, Oracle 11i, PLSql procedures, DB2 views, Unix Scripts, DB2, AS 400, Unix, Windows, UC4 scheduling tool, Tableau 8.1.5 reporting tool

Andersons, OH

Sr. ETL/MDM Architect - Informatica Powercenter Architect

Responsibilities:

• Configured and maintained various components of teh MDM Hub including teh schema, landing and staging tables, configuring BaseObjects, Look-ups, Hierarchies, Queries and Query groups.
• Utilized Informatica Data Quality (IDQ) extensively for loading teh data into Informatica MDM Hub
• Proven experience in improving teh data quality by Match analysis, analysis of teh MDM system performance and tuning teh performance by changing teh existing cleansefunction, match rules etc.
• Strong hands on working noledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Create high and low level ETL design to meet user requirements.
• Create other ETL artifacts such as functional requirement document, data model, source-to-Client mapping, test case matrix, deployment document etc.
• Independently develop efficient Informatica mappings, sessions and workflows as per teh design specifications.
• Design ETL data model.
• Conduct Knowledge Transfer sessions to share noledge wif teh team.
• Support production ETL batch jobs.
• Evaluate, determine root cause and resolve production issues.
• Propose, implement and adhere to best practices, standards and processes.
• Installing and configuring teh Informatica and supporting softwares and utilities.
• Perform testing on connections, scripts, workflows, mappings and other scheduled activities.
• Creating repository backup scripts and automated in Active Batch V8 scheduler.
• Creating strategy documents, installation documents and supporting documents.

Environment: Informatica Powercenter, Informatica IDQ/IDE, Informatica MDM 9.5.1, Windows 2008 R2, MS Sql Server 2008 R2, Oracle 10g/11g, Perl, ActiveBatch V8

Confidential, PA

Technical Architect

Responsibilities:

• Onsite Lead and managed 20 member of Off-shore team.
• End to End responsible for project deliverables
• Working wif users to understand their requirements in order to create Technical Design, Application Design and Component Design.
• Estimated and designed teh ETL process
• Developing Mappings, Workflows and scripts creation
• Implemented CDC in teh projects
• Designing and documenting teh High Level process flow of extracting teh data from teh Source system till loading teh data in Data warehouse.
• Created Process and Technical Design Documents for teh mappings that is built to load teh dimensions in teh data warehouse.
• Development and Code review
• Worked wif testing team in all teh testing phases(ST,SIT,E2E,UAT)
• Client interaction, status updates and meetings
• Good Understanding in protection concepts like Fallback, Raids, and Journals
• Worked wif Teradata 12 utilities like BTEQ, Fast Load, Multi Load and Query man.
• Has experience on implementing business rules in BTEQ scripts.

Environment: Informatica 9.0.1, 8.6.1, PowerCenter, Repository Manager, Mapping Designer, Workflow Oracle 10g, Teradata 12, Unix shell Script, Oracle PL/SQL, Quality Center, MS Office

Confidential

Technical Architect

Responsibilities:

• End to End responsible for project deliverables
• Provide data to Risk Management department via reports. Teh data includes performance monitoring, risk governance in conformance wif regulatory guidance.
• Work wifsenior business executives and key stakeholders to gather detailed business requirements around their data needs and tan plan a roadmap of project activity that generates measurable improvement in business performance metrics/Key Performance Indicators (KPIs)
• Worked in stress testing, portfolio Asset Liability Management (ALM), mortgage banking, multi-family and commercial real estate lending, credit risk analytics or mortgage compliance
• Working wif users to understand their requirements in order to create Technical Design, Application Design and Component Design.
• Estimate and design teh ETL process,
• Developing Mappings, Workflows and scripts creation
• Technical Specification preparation
• Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Imported Metadata from Teradata tables.
• Prepared BTEQ scripts to load data from Preserve area to Staging area.
• Worked on Teradata SQL Assistant querying teh source/target tables to validate teh BTEQ scripts.
• Involved in peer to peer reviews. Identifying Bugs and reporting defects.
• Deployment to test environment and production environment
• Configuration SOP document creation.
• Post production support

Environment: IBM Information Server, IBM Datastage 8.0.1, Unix, Teradata 12, Oracle 10g, Cognos

Confidential, PA

Lead Datawarehouse Developer

Responsibilities:

• Maintaining teh ETL environment in Sagent and developed various reports for internal and external use
• Study teh new requirements for small/medium/big projects and reports.
• Database feasibility analysis
• Worked wif data modeler for schema level changes
• Report Design, coding and Analysis.
• Dashboard(Netacumen Reports) creation for Management to analyse teh daily business.
• Cancel order analysis
• Back order reports
• Daily style selling reports.
• Moving to objects to production and scheduling teh jobs and reports.
• Technical manual and user manual creation

Environment: Sagent Open Studio ETL/Reporting tool, Oracle, SQL Server, Ephiphany and Omniture