SUMMARY

• Overall 11+ years of experience in Information Technology with a strong background in Analyzing, Designing, Developing, Testing, Implementation and Maintenance of Analytical, Database and Business Intelligence applications development in various verticals such as Insurance, Banking, Retail and Manufacturing.
• 6+ Years of IT Experience in Analysis, Design, Development, Implementation, Testing and supporting of Data Warehousing and Data Integration solution using Informatica Power Center.
• 2+ years of experience in Alteryx platform, and involved in data preparation, data blending, and the creation of data models, data sets using Alteryx.
• Knowledge in Full Life cycle development of Data warehousing.
• Experience in using Informatica Power Center 9.01/8.1.1, Informatica Data Quality, PL/SQL, UNIX, Shell scripting,, Erwin Data modeling tool.
• Experience with dimensional modeling using star schema and snowflake models.
• Good understanding of the business rules completely based on High level document specification and implements the data transformation methodologies.
• Extensively worked with Informatica performance tuning involving source level, target level and mapping level bottlenecks.
• IBM Certified Developer/Designer having with 8 years of Data Warehousing experience using Informatica Power center 10.2x/9.6x/9.x/8.x, Informatica Power Mart 7.x/6.x, Power Exchange, Cognos and OBIEE.
• Experience in several implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
• Handful working experience in Data warehousing development with data migration, data conversion and extraction/transformation/loading using Informatica Power Center to extract & load data into relational databases like SQL Server, Oracle, Teradata, DB2.
• Expert in all phases of Software development life cycle (SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance
• Have good experience in extracting and generating statistical analysis using Business Intelligence Tool Tableau, OBIEE and Cognos for better analysis of data.
• Knowledge of job workflow scheduling and monitoring tools like CA7 Mainframe
• Well exposure to On-site, Offshore and Near-shore models and having good co-ordination skills in handling On-site/Offshore teams.
• Experience in working with all stake holders of the project including Enterprise Architects, BI/DW Data Modelers, Data Analysts, Business Analysts, System Analysts, PMO and various levels of Business Users including Business Executives and Top Management.
• Experience in training Business Users in the developed/modified systems.
• Well versed in using Software development methodologies like Rapid Application Development (RAD), Agile Methodology and Scrum software development processes.
• Experience in Change Management Tool JIRA, Maximo, SCCD & Service Now.
• Experience in design and coordinating of middle layer services such as BizTalk, Direct Connect, NDM services etc.
• Experience in Design and Development of ETL methodology for supporting Data Migration, data transformations & processing in a corporate wide ETL Solution using Teradata TD 14.0/13.0/12.0.
• Experience in integration of various data sources definitions like SQL Server, Oracle, Teradata SQL Assistant, MYSQL, Flat Files, XML and XSDs.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Excellent written, communication skills and possessed analytic problem skills in evaluating business and technical processes and issues, develops and implements system enhancements to facilitate overall operations.
• Involved in Analysis, Requirements Gathering, SRS (Software Requirement Specifications) & HLDD (High Level Design Document) & LLDD (Low Level Design Document).
• Involved in analyzing existing logical and physical Data modeling using Erwin.
• Responsible for creating & running SQL scripts for DDL, DML operations on Oracle DB.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Involved in data migration to import legacy data from one system to the other.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Team Player, motivated, able to grasp things quickly with analytical and problem-solving skills.

TECHNICAL SKILLS

Databases: Oracle11g/10g/9i/8i,SQLServer2008/2005/No SQL, Teradata 13/V2R6, Mainframe GDG, XML And Flat Files

Operating System: UNIX/Linux, Windows XP/2000/2008, IBM z/OS

Development Tools: Win Scp Putty, Bit bucket, GIT & Jenkins, Art factory, U deploy

BI/ETL Tools: Informatica, Informatica Cloud, SQL Plus, SSIS, TOAD, SQL Developer, OBIEE, Autosys, Cognos, AIS 4.21

Languages: PL/SQL, T-SQL, C, C, .Net

Applications: MS Project, Word, Excel, PowerPoint, SharePoint and Top Team

Data warehousing: Informatica Power Center 9.6/9.5/9.1/8.6/8.1 , Informatica Power Mart 8.x/7.x/6.x, Informatica Power Exchange 9.x/8.x/7.x, Repository Manager,Designer, Workflow Manager, and Workflow Monitor.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Lead ETL Informatica Developer

Responsibilities:

• Actively involved in interacting with business users to record user requirement and business analysis.
• Documented Data Mapping/Transformation as per the business requirement.
• Created the tables in target tables in production environment.
• Creating and maintaining source-target mapping documents for ETL Development Team.
• Created mapping using Designer and extracted data from various sources, Transformed data according to the requirement.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded the warehouse.
• Designed and developed ETL workflows and datasets in Alteryx.
• Used Alteryx for Data Preparation and then Tableau for Visualization and Reporting.
• Developed Cloud mappings to extract the data for different regions (APAC, UK and America).
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Created File watcher jobs to setup the dependency between Cloud and Power Center jobs.
• Extensively worked on Unit testing for the Informatics Code using SQL queries and debugger.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Created the jobs in CA7 mainframe to schedule the workflows.
• Used Teradata utilities FAST LOAD, MULTI LOAD, TPUMP to load data.
• Created (or edited existing) Informatica mappings and sessions to accomplish data migrations. Sources were Oracle, DB2 and flat files and load into target.
• Created Complex mappings using transformation like Connected/Unconnected Lookup, Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Analysis and data profiling new data sources to design logical and physical data models for the new dimension model. Design, development and implementation of backend Redshirt tables and ETL jobs in Snaplogic and Informatica to transform data from varied sources systems, i.e. Reltio, Salesforce, to the target dimensional model.
• Maintenance of Snaplogic ETL jobs at Stanford University, Ezesoft, Intuit, Veoliana to transform data and load into Confidential /Longview EPM tool
• Worked with Nice Actimize team on issues, which have been reported by client.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Coded the scripts for loading the data into Oracle Database from flat files using SQL Loader.
• Re-designed ETL mappings to improve data quality.
• Adhoc data cleansing, data transformation and standardization using Alteryx
• Wrote, tested and implemented Teradata Fast load, Multi load and BTEQ scripts, DML and DDL.
• Migrate the code using U deploy and Art factory. Own the change management using service now and maintaining bug status using JIRA tool

Environment: Informatica 9.6, Putty, SQL Developer, Harvest, Application Lifecycle Management (ALM). Unix, Linux 2.6.x, Windows 7,10, Oracle 11g, Teradata, Erwin, UNIX, PL/SQL, Autosys Informatica Cloud, Service Now, JIRA, U Deploy, Art factory

Confidential

Informatica ETL Developer

Responsibilities:

• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Data Lineage analysis of the existing Informatica and Snaplogic pipelines to generate lineage documentation of existing ETL data flows.
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalize, Filter).
• Experience in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Extracted data from SAP ECC 6.0, SAP R3 using SAP BCI extractors.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Involved in Informatica Data Masking using Informatica ILM tools& Data Subset Data Mapping.
• Develop the ETL Mapping, Sessions and Workflows Using ETL tool Informatica.

Environment: Informatica 9.6, Putty, SQL Developer, Harvest, Application Lifecycle Management (ALM), Oracle 11g, Toad 8.0, B2B Data Transformation, FACT, T-SQL

Confidential

OBIEE Report Developer

Responsibilities:

• Planning and discussion with business analyst to understand the technical business requirement.
• Interacting with business users for requirement gathering and making the technical and functional document the same as required.
• Solution Development Effort Estimation.
• Created new reports and dashboard with advanced features of OBIEE 11g
• Solving the technical Issues encountered Defect resolution.
• Production implementation activities and deployment.
• Maintenance, Enhancement and support involving Coding, Review and Testing.
• Worked closely with various teams / stakeholders on account of discussions and during issues with the applications.

Environment: OBIEE 11g TOAD, Putty, SQL Developer, Harvest, Application Lifecycle Management (ALM), SQL, PL/SQL.

Confidential

OBIEE Report Developer

Responsibilities:

• Analysis of current Cognos reporting environment and convert the Cognos reports to OBIEE Reports.
• Create various Reports, Analysis & dashboards to meet business requirements.
• Interact with business users (clients) for requirement gathering and document the same as required.
• Create database objects like SQL, PL/SQL proc, MV etc, to meet business requirement.
• Review code with team/client as and when required.
• Involvement in estimation and assignment of work.

Environment: OBIEE 11g TOAD, Putty, SQL Developer, Harvest, Application Lifecycle Management (ALM), SQL, PL/SQL, Cognos 8 BI.

Confidential

OBIEE Report Developer

Responsibilities:

• Created simple to complex Reports as per requirements using OBIEE Answers and done modelling using OBIEE RPD so as to support reporting requirements.
• Created reports that have multiple pages, cascaded prompts, master-detail relationships, etc.
• Created report that allows drill up, drill down, drill through, provides filter to select top/bottom performers, starting hierarchy, etc.
• Involved in implementation of security on OBIEE Reports using user roles and created burst reports to deliver scheduled report outputs to user via email.
• Involved in Impact Analysis of requested changes, providing high level effort estimation and assigning work to team members
• Created/Reviewed Technical Specification/Unit Test Plans and executed unit test cases.
• Handled responsibility of creating release notes/deployment guide.

Environment: OBIEE 11g TOAD, Putty, SQL Developer, Harvest, Application Lifecycle Management (ALM), SQL, PL/SQL, Cognos 8 BI.

Confidential

DB2 Developer and Analyst

Responsibilities:

• Involved in developing new application reports, debugging the existing reports,
• Customizing the existence reports according to User requirements.
• Development of Complex Dashboard reports, Scorecards with drill through capabilities using Cognos 8.3.
• Created reports with calculations, conditions using Report studio. Developed the various report with conditional formatting by using conditional explore.
• Preparation of design Documents, Test Cases.

Environment: OBIEE 11g TOAD, Putty, SQL, PL/SQL, Cognos 8 BI.