SUMMARY

• Business Intelligence professional with over 10 years of experience in Data Modeling, Requirements Gathering, ETL Informatica Development, Talend, Oracle programming/Lead, Redshift, Postgres Oracle Business Intelligence for industries like Finance, Marketing, Telecom Sales, Media and Entertainment
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Experience in Informatica designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Key generation etc.
• Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2) mappings.
• Intermediate experience in developing OBIEE Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Good Exposure in data profiling on wide variety of data and DataModelling in EDW.
• Experience in Oracle BI Apps that include OBIEE, ETL Tools and DAC.
• 9+ years of Professional Experience in Informatica PowcerCenter Design
• Experience in Amazon Redshift Database Setup and Optimal Design.
• Experience in using S3 Buckets and AWS data pipeline and Data copy command from S3 Buckets to Amazon Redshift.
• Postgres database and Functions coding.
• Requirements Gathering and translation of Business Requirements to Technical Logics
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
• Worked in various Heterogeneous Source Systems like Oracle, MS SQL Server, MY SQL, Flat files and Legacy systems.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Hybrid Schema.
• Data warehousing experience using Informatica Power Center Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, ETL, Data mart, OLAP, OLTP.
• Expertise in creating Tables, Clusters, Partitions, views, Synonyms, Indexes, Joins and Sub-Queries. Stored Procedure/Functions, Triggers, Jobs, PAA and Packages using PL/SQL.
• Experience in oracle Administration such as Installation, Schema Creation, Security, Backups and Restorations.
• Exposure knowledge of Informatica Migration and Upgrade.
• Expertise in creating very detailed design documents and performing Proof of Concepts (POC).
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Sound experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data .
• Expertise in using Exception Handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.

TECHNICAL SKILLS

ETL tools: Informatica8.6/9.1,9.5,Talend,Pentaho, DAC, Tableau, Perforce Automated tool

Databases: MS SQL Server 2005/2008/2012 , MYSQL, Oracle 8i/9i/10g/11g, Amazon Redshift, Postgres, Greenplum

Tools: Toad, SQL Developer and PG Admin, Aginity Workbench

OS: Windows XP/2000/NT/98/95, Linux, Unix, Windows 10,Windows Server 2012

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Sr Database ETL Developer

Responsibilities:

• Involved in Database Setup, Design of Amazon Redshift Database
• Involved in Data copy form Mysql and Oracle OLTP systems to Amazon Redshift Database using S3 Buckets and Redshift templates
• Responsible for Full Copy and Incremental Copy of OLTP tables into Redshift.
• Responsible for Optimal design of tables using Sort Key, distribution key and tuning of Redshift queries using WLM and Redshift packaged tables.
• Responsible for Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• Involved in DataModelling of Partner Billings Star and integrating the data into existing EDW model
• Worked with Business team to gather the Functional Specifications for Guideline Reports.
• Involved in Providing Technical support to Offshore Dev team and guided them through all the phases of Project
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Extensively worked on transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Designed pre defined Mappings to load the data in slowly changing dimensions. Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2) mappings.
• Developed Mappings using Informatica http and Web services transformation for Extracting data from workday.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements
• Handled the planning of the Work allocation and daily calls with Offshore resources.
• Determined various bottle necks on testing phase and successfully eliminated them to great extent.
• Worked extensively in testing the code of various datamarts and identified bugs in the code .
• Reviewed test case documents and UT documents for the quality analysis done.
• Involved in proving extracts and reports in Tableau.
• Developed the Adhoc Dashboards in tableau according to the Business Requirements

Environment: Informatica P.C 9.5, Tableau Desktop9.0, Informatica, Aginity Work Bench, Windows Server 2012,My SQL,Oracle,AWS Redshift.

Confidential, Palo Alto, CA

Informatica Architect (ETL)

Responsibilities:

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• Involved in maintaining the Redshift tables and tuning of tables using Analyze and Vacuum commands.
• Responsible for tuning of ETL loads into Redshift database
• Involved in DataModelling of Varicent Data and integrating the data into existing EDW model
• Involved in designing the encrypted data flow of highly secure data from Varicent.
• Worked with Business team to gather the Functional Specifications for Guideline Reports.
• Designed functions in Postgres for extracting the data from all source systems to the target system.
• Created pre defined mapping transformations, mapplets, sessions and worklets for complex code in Postgres.
• Handled the planning of the Work allocation and daily calls with Offshore resources and guiding them in Project
• Determined various bottle necks on testing phase and successfully eliminated them to great extent.
• Worked extensively in testing the code of various datamarts and identified bugs in the code
• Prepared test case documents and UT documents for the quality analysis done.
• Involved in proving extracts and reports in Tableau.
• Handled the Code Deployments to Production using Automated tool Perforce

Environment: Amazon Redshift,Informatica P.C 9.1, OBIEE,Tableau Desktop8.3,SQL Developer, Aginity Work Bench for Redshift, Windows Server 2012,Oracle,Salesforce

Confidential

Sr. Software Engineer

Responsibilities:

• Involved in end to end implementation of migrating the code from Informatica to Greenplum(Post Gres)
• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• Involved in setup of Redshift Cluster and creation of tables in Redshift .
• Maintained the backup of tables in production on Amazon Redshift cluster
• Responsible for tuning of tables in Redshift tables and tuning of complex queries and changing the table structures according to the optimal performance of queries.
• Worked with Financial team to gather the Functional Specifications for Guideline Reports.
• Designed functions in Postgres for extracting the data from all source systems to the target system.
• Created pre defined mapping transformations, mapplets, sessions and worklets for complex code in Postgres
• Extensively used Transformations like Router, Lookup (connected and unconnected), Update Strategy, Source Qualifier, Joiner, Expression, Stored Procedures, Aggregator, Sequence generator, Sorter, Filter, Joiner, Normalizer, Rank, Transaction control Transformation.
• Designed pre defined Mappings to load the data in slowly changing dimensions.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Provided production support by monitoring the processes running daily.
• Configured the session so that Power Center Server sends an Email when the session completes or fails.
• Debugged and sorted out the errors and problems encountered at testing phase.
• Designed and created Oracle Database objects, tables, Indices, Clusters, Views, Procedures, Packages, and Functions.
• Designed and created Postgres functions using PGPSQL
• Determined various bottle necks on testing phase and successfully eliminated them to great extent.
• Worked extensively in testing the code of various datamarts and identified bugs in the code
• Prepared test case documents and UT documents for the quality analysis done.

Environment: Informatica P.C 9.1, OBIEE, Tableau Desktop8.1, Amazon Redshift, Aginity Work Bench for Redshift, Windows Server 2012,Oracle,Salesforce,Toad

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• Worked with Financial team to gather the Functional Specifications for Guideline Reports.
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• Created pre defined mapping transformations, mapplets, sessions and worklets.
• Extensively used Transformations like Router, Lookup (connected and unconnected), Update Strategy, Source Qualifier, Joiner, Expression, Stored Procedures, Aggregator, Sequence generator, Sorter, Filter, Joiner, Normalizer, Rank, Transaction control Transformation.
• Designed pre defined Mappings to load the data in slowly changing dimensions.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Worked extensively with DAC for scheduling, monitoring loads and have hands on experience in installing and configuring BIAPPS with various Business modules
• Provided production support by monitoring the processes running daily.
• Scheduling and monitoring automated daily and weekly jobs in DAC.
• Configured the session so that Power Center Server sends an Email when the session completes or fails.
• Debugged and sorted out the errors and problems encountered at testing phase.
• Designed and created Oracle Database objects, tables, Indices, Clusters, Views, Procedures, Packages, and Functions.
• Determined various bottle necks on testing phase and successfully eliminated them to great extent.

Confidential

Software Engineer

Responsibilities:

• Analyzed the High Level Design and Low Level Design Documents.
• Involved in Extraction, transformation, Loading and Implementation
• Managed the sources like Oracle and External Sources like Flat files.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Extensively worked on transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Created reusable transformations and mapplets.
• Identified and tracked slowly Changing Dimensions.
• Involved in Performance tuning and achieved optimal performance with the applied changes to the existing mappings.
• Created and tracked efficiently Mapping Parameters and Variables.
• Involved in Unit testing and prepared Test Case Documents(TCD).
• Migrated the code from Development Repository to QA Repository.

Confidential

IT Assistant

Responsibilities:

• Coordinated scheduling of students and teachers for the purpose of maintaining computer lab operations and activities.
• Instructed students and teachers in computer lab technology and software applications (e.g. answers questions, keyboarding, Apple Works, reading/math specialized programs, etc.) for the purpose of enhancing their understanding of lab operations and reinforcing academic concepts.
• Maintained computer hardware and software applications inventory for the purpose of ensuring availability of equipment and/or instructional material in computer lab.
• Maintained computer lab (e.g. instructional materials, appropriate software, sets up materials for daily activities, etc.) for the purpose of ensuring availability of equipment and programs to enhance the instructional program.
• Monitored student activities while in computer lab for the purpose of maintaining a safe environment that is conducive to learning. Performs routine and preventive maintenance of computer lab and classroom equipment (e.g. dusting, cleaning, virus scanning, creating/clearing Internet bookmarks, defragmenting, etc.) for the purpose of ensuring the availability of equipment in safe operating condition.
• Prepared documentation (e.g. reports, instructions, memos, etc.) for the purpose of providing written support and/or conveying information.
• Troubleshoot malfunctions of hardware and/or software applications for the purpose of determining appropriate actions to maintain computer lab operations.