PROFESSIONAL SUMMARY:

• 12+ years of experience in overall SDLC including user Interactions, requirement analysis, design, development, testing, debugging, deployment, production support and maintenance of various data warehouse applications using ETL tools, Informatica for banking domain projects using Agile/SCRUM & Waterfall methodologies .
• Expertise in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Pow er Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor using Informatica 9.x/8.x
• Extensive experience with Data Extraction, Transformation and Loading (ETL) from disparate data sources like Flat Files, XML, Mainframe Sequential & VSAM Files and relational databases like Oracle, Teradata, SQL Server.
• Developed complex Mappings, Reusable Mapplets, Transformations, Sessions and Workflows using Informatica ETL tool to extract data from disparate source systems and targets.
• Worked with various transformation like Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, lookups, Sequence Generator, XML , Update Strategy, Union,Stored procedure etc.
• Involved in performance tuning of sources, targets, mappings, transformations and sessions including database query level optimizations.
• Proficient in RDBMS Concepts, SQL, PL/SQL programming (Stored Procedures, Functions, Packages, Views, Materialized Views and Triggers etc.).
• Developed Linux Shell Scripts to transfer files between servers for IBM Connect - Direct tool, remove old files and move raw logs to the archives, emails etc.
• Actively worked with business teams and business analysts in requirement gathering discussions to develop detailed design of solution.
• Experienced in documenting high level design, low level design, source to target mappings (STM) document, unit test plan, unit test cases and deployment documents.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / iBots, DAC , creating reports or Dashboards, cache monitor, security implementation and building OBIEE Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
• Strong in writing OracleSQL and Enhancement of PLSQL, Procedure, function and Package .
• Hands on experience in working with BMC Remedy&Service now - Ticketing &Change Request Management applications.
• Experience in scheduling tools like Informatica Scheduler, CA7 andDAC for ETL jobs.
• Experience in leading team and acting as offshore-onsite team coordinator.
• Good understanding of Big Data Hadoop Ecosystem tools like HDFS, HBase, Apache Spark, SparkSQL, Hive, Impala, Pig etc.
• Strengths include Excellent interpersonal and communication skills and ability to provide solutions from functional and technical perspective to meet deadlines, quickly build client rapport, mentor staff and a team player.

TECHNICAL OVERVIEW:

ETL Tool: Informatica 8.x, 9.x, IICS , Mainframe

Reporting Tools: OBIEE 12c, OBIEE 11g

Databases: Oracle 10g/9i/8i, Teradata, SQL Server, MySql

Ticketing Tools: SeviceNow, BMC Remedy

Operating Systems: Windows, UNIX

Languages: SQL, PL/SQL, UNIX Shell Scripting

Other Tools: Connect: Direct NDM Transfers, GitHub, Artifactory, uDeploy, BlueZone (Mainframe), CA7 Scheduling tool, Toad, Toad Data Modeler, Putty

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Extensively involved in business requirements discussions to understand the scope of work, Designing ETL solutions, Development, testing, Deployment, Support and maintenance of solution.
• Created detailed design documents, Source to target mappings (STM), Unit test case documents, code review and internal & external quality assurance documents, Release components documents, Deployment documents, Change records, Support documents (Runbooks).
• Worked on converting old application processes involving Unix scripts to read flat files and load to Oracle database into Informatica ETL solutions.
• Extensively involved in creating application architecture diagrams, updating the same for changes, documenting and resolving architecture standard exceptions like connections encryptions, old versions of tools etc.
• Extensively involved in Informatica and Oracle database upgrade activities.
• Design, Development and Document the ETL strategy to integrate different Source Systems.
• Involved in performance tuning of Informatica code and Database queries optimization.
• Coordinated the UAT with business users and worked on defects reported in UAT or in production.
• Created CA7 jobs to execute Informatica workflows, mainframe NDM jobs, managed jobs repository.
• Code deployments to UAT and PROD using GitHub, Artifactory, uDeploy and managed packages naming conventions for the same.
• Coordinated with Database, ETL, midrange teams and other teams to resolve any environmental issues.
• Coordinated and managed globally located Team members, carried out status meetings.
• Mentored and provided trainings to new team members and helped them to resolve any issues.

Tools: Informatica PowerCenter & PowerExchange - 10.2/9.6.1/8.6.1 , Oracle 12c/11g/10g/9i, Teradata, SQL Server, Connect: Direct NDM Transfers, GitHub, Artifactory, uDeploy, BlueZone (Mainframe), CA7 Scheduling tool, Toad, Toad Data Modeler, OBIEE 11g, Putty, ServiceNow

Environment: Windows 7/10, Linux/Unix, Mainframe

Confidential, Charlotte, NC

ETL / BI Developer

Responsibilities:

• Act as the lead and gatekeeper for OBIEE, monitoring and reviewing the development of new and existing reports. Supporting maintenance activities for stability and reliability of OBIEE.
• Interacted with business team to gather Business Requirements as well as to define business and functional specifications
• Till date developed around ~ 20 Reports in OBIEE in this project at various levels of abstraction using OBIEE functionalities like - Guided Navigation, Section Access Permission, Action Links, In-place Column Drill downs, dynamic report and column names, Pivot and Table Views, View and Column Selectors.
• Developed metadata repository using OBIEE Administration tool (RPD) in Physical, Business Model and Mapping, and Presentation layer.
• Setting up LDAP security, managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Used Presentation variables for passing values from Dashboard prompts to analysis and in guided navigation reports.
• Defined initialization blocks and created repository variables to be used in the expressions mapped logical columns in BMM layer to physical columns in the physical layer.
• Carried outRPD deployments and migrating Repository and WebCat files from Development to Test and Production environment.
• Provided complete solution, end to end including ETL and reporting.
• Developed complex mappings applying varied transformation logic such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, XML, Connected , Unconnected lookups and Update Strategy
• Working with different system like Mainframe, Flat file and DB as Source

Environment : Informatica 9.x, OBIEE 11g / 10g, SQL, Oracle 11g, Toad, Putty, UNIX

Confidential

ETL Lead

Responsibilities:

• Interacting with clients for requirement gathering and Developing Informatica Mapping specifications (HLD and LLD documents)
• Designing Mapping, Workflow and pier testing.
• Involve in requirement gathering from the business users.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• All the jobs are integrated using complex Mappings and Workflows using Informatica.
• Developed several Informatica mappings.
• Developed complex mappings applying varied transformation logic such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected lookups, Sequence Generator and Update Strategy
• Working with different system like Mainframe, Flat file and DB as Source .
• Analyzing Business Logic and developing High Level Design.

Environment : Informatica 9.x, SQl, PL/SQL, Oracle 10g, UNIX, DAC,Toad

Confidential

Informatica Developer

Responsibilities:

• Interacting with clients for requirement gathering and preparing ETL specifications (HLD and LLD documents)
• As ETL designer was responsible for providing Database and ETL design as per the Front End OBIEE design.
• Making sure the project execution is going smooth as per the timelines defined and getting the work done by team members as per the defined timelines.
• Created Informatica mappings using different transformations.
• Created and executed Unit, Integrated test cases in HP Quality Center. Defect analysis and tracking in HP QC.
• Created Informatica scheduler jobs to schedule Informatica workflows.

Environment : Informatica 8.6.1, SQL, PL/SQL, Oracle 10g, UNIX, HP Quality Centre

Confidential

ETL Designer

Responsibilities:

• Interacting with clients for requirement gathering and preparing ETL specifications (HLD and LLD documents)
• As ETL designer was responsible for providing Database and ETL design as per the Front End OBIEE design.
• Making sure the project execution is going smooth as per the timelines defined and getting the work done by team members as per the defined timelines.
• Created Informatica mappings using different transformations.
• Supporting data Load.

Environment : Informatica 8.6.1, Oracle 10g, TeraData,UNIX