SUMMARY:

• Over 12+ years of IT experience with a strong background in SDLC, Data integration tools using Informatica Confidential center, Databases using Oracle & Greenplum and Reporting using Tableau and Cognos. Experience in full - cycle software development including requirement gathering, prototyping, and proof of concept, desing, documentation, Implementation, testing, maintenance and production support.
• 10 years of Business Intelligence Data warehouse experience
• 9 years of ETL Informatica experience(Integration,Testing,Production Support)
• 3 years of Informatica Confidential Exchange CDC 9.x experience
• 5 years of Tableau 9.x experience
• 2 years of Cognos experience
• 4 years of Data modeling experience
• 5 years of Greenplum database experience
• 12 years of Oracle database experience
• 2 years of Oracle DBA experience
• 6 months of IBM infosphere Datastage 9.1
• Onsite Offshore Coordinator / Project Lead. Managed a team of 12 members. Scrum Master and driven the sprint iteration. Successful end to end project delivery for Confidential &Water (Integration, Testing and Reporting). Intoduced Informatica PWX CDC for incremental data load.
• Informatica ETL monitoring automation
• Leveraged the backend log files and designed unix script to read the log file line by line and pull the failure code, time of failure and start time. Compare the start time with current time and check if any session is running long based on that send email to ops team. 30% of monitoring effor is saved and helped team to concentrate on service now tickets.
• Informatica ETL & SQL Performance tuning
• Implemented ETL partitioning techniques and sql code optimization reduced over all datawarehouse load time from 5 hrs to 2 hrs. This gave the business benefit of near real time report generation.
• Oracle to Greenplum Conversion Automation
• Designed an automation script using PL/SQL procedure to convert the Oracle DDL to Greenplum standard, Benefited overall project which reduced the manual effort and saved 10% of the project cost.

TECHNICAL SKILLS:

Technology and Tools: Enterprise Data Warehouse End to End warehouse setup Data integration, Dimensional data modeling and Report development for business analytics Informatica PWX CDC 9.x,10.x Installation, Upgradation to 10.1, Troubleshooting and configuring DBMOVER.cfg, PWXCCL and PWXORAD files. Effectively designed Informatica CDC to capture change data from ERP source system, also implemented soft delete logic to remove the deleted records from EDW tables. Informatica ETL 8.x9.x,10.x ETL design for external source integration from flat file to RDBMS system. Handling slow changing dimension. Used Parameters and Variables to implement Object Orientation techniques and facilitate. Implemented partitions for better performance Data modeling Good exposure in Data modeling concepts and design strategies. Self - Service data model: Working on self-service data model design in which we create ERP process driven models (E.g., Procure to Fulfill, Budget to Close) with relevant facts and dimensions attributes hooked up. In Tableau, we have created data sources for each model and published as extract so, that end users can create their own reports. Tableau 9.x10.x Developed accurate and timely reports. Mastered the ability to design and deployrich Graphic visualizations using tableau Charts,Parameters,quick filter,context filter and dashboard action. Leveraged Tableau backend metadata tables workbooks, views, users, view stats, background jobs, schedules, Designed detail dashboard to collect report hits and user data. Greenplum 4.3 Extensively worked on Greenplum database and leveraged the benefits of Greenplum MPP architecture by designing the GP User defined functions, created YAML files to load external data using GP loaders. Query optimization, proper table design with right distribution key

PROFESSIONAL EXPERIENCE:

Confidential - Tampa, Florida

Sr ETL Developer

Environment: Database: Greenplum 4.3, ETL: Infosphere Datastage 9.2 Language: Oracle SQL, Greenplum functions

Responsibilities:

• Participate in daily scrum call understand the tasks allocated as per the sprint iteration and prioritize the task accordingly
• Metadata driven model, Enhance the existing setup based on the business scenario
• JIRA analysis and fix, on an average 3 JIRA fix per day
• Code migration using SERENA and BITBUCKET
• Autosys job monitoring
• Automate the existing manual monitoring process.
• New table integration to warehouse
• Dynamic query generation using Greenplum UDF.

Confidential, Schenectady, NY

BI Consultant/Onsite Coordinator

Environment: Database: Greenplum 4.3 Reporting: Tableau ETL: Informatica 9.6.1/Informatica PWX CDC Language: Oracle SQL, Greenplum functions Project Execution: Agile Methodology

Responsibilities:

• Responsible for Enterprise Datawarehouse setup, data integration using Informatica, data quality and report development.
• Consultswith end users on recommendations for new reports and to improve existing reports.
• Implemented Informatica PWX CDC in source Oracle ERP instance and made it run 24/7 with soft delete logic built in. Also, the soft delete logic was published on internal forum which benefited other project teams to implement similar strategy.
• Familiar with dbmover, pwxccl, pwxorad configuration files and PWX Navigator for creating data maps and database rowtest
• Data Quality process to ensure the data consistency between source ERP and target ODS tables.
• Designed dimensional modeling SCD type 2 for 3 business key reports to maintain history using Informatica.
• Informatica ETL performance tuning using Informatica key range partitioning.
• Involved on ETL Functional testing and Report testing.
• System Integration Testingand
• ETL design to store history data based on mapping variable “creation date” parameter.
• Categorized tables by FACT and DIMENSTION. Designed conceptional, logical and physical data model
• Trained end users about the basis of tableau and helped them to convert excel based reports to Tableau visualization
• Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security
• Worked extensively onjoining tables, multiple data connections usingblending, worked on DataExtractsandmanaging queries
• Tableau report development based on the business requirement, educated the user about tableau capabilities and the advantage of visualization. Designed Tableau dashboards for leadership team with the key business KPI's like Commercial, Inventory and Order management.
• Familiar with Tableau LOD functions and Tableau 10.1 features
• Worked on TableauSite Admin taskssuch aspublishingworkbooks,settingpermissions,managing ownerships, working withSites, providing access to the users and adding them to the specificgroups and Projects,Scheduling Refreshes and Subscriptionsin Tableau Server
• Agile planning and execution of development of DW/BI components
• Performance tuning of long running Greenplum user defined functions. Leveraged the feature of temporary tables break the code into small sub part load to a temp table and join it later with the corresponding join tables. Table distribution keys are modified based on the data granularity and primary key column combination

Confidential, Schenectady, NY

Programmer Analyst

Environment: Database: Greenplum 4.3 Reporting: Cognos/Tableau ETL: Informatica 9.6.1 Language: Oracle SQL, Greenplum functions Project Execution: Agile Methodology

Responsibilities:

• Responsible for project delivery Datawarehouse migration from Oracle to Greenplum.
• Lead the team of 8 members. Agile planning and execution of development of DW/BI components
• Estimating the efforts required for OPS and Greenplum migration activity and preparing the estimation plan
• Informatica infrastructure setup for Greenplum. Greenplum Driver,ODBC connection and GPLOAD setup
• Optimized the performance of the Informatica mappings by analyzing the session logs and understanding various bottlenecks (Source/target/transformations).
• Working on POC of Oracle to Greenplum migration and POC for Cognos to Tableau report conversion
• New report development using Tableau, worked extensively on custom sql, data blending and data extracts
• Built interactive dashboard using right techniques and visual best practices provided by Tableau
• Converted 20 Cognos report to Tableau report
• Used following charts to make Viz more interactive Donut chart, Packed Bubbles, Stacked Bars, horizontal Bars, Trend Lines, Geo Graphic charts.
• Familiar with Tableau Parameter, Filters, hierarchy, Group, and dashboard actions
• Performance Tuning for long running SQL’s
• Performance Tuning for long running ETL’s
• Peer review of reports created by the team
• Review of Unit Test plan prepared by the team

Confidential, Schenectady, NY

Technical Lead/Senior Software Engineer

Environment: Database: Greenplum 4.3 Reporting: Cognos ETL: Informatica 9.1 Language: Oracle SQL, Greenplum functions Project Execution: Agile Methodology

Responsibilities:

• Handling end user P1 incidents Service now tickets
• Interact with the end users and understand the issue cause and help for a quick fix
• Creating and modifying existing workflows in Informatica for new requirements
• Used informatica debugger to understand the data movement for production fix
• Involved in the Performance Tuning & Preparation of unit test cases
• Involved in testing Change Requests (CR's) that is testing base enhancements to the existing code before implementing in the production.
• Extensively worked with all phases of testing deliverables including creation of Test Strategy, Test plans, RITM, Test case specifications, Test execution, Defect tracking, Resolution, Documenting and Reporting
• Automate the existing monitoring process by using UNIX script
• Update client on weekly basis about the status of the ongoing activities.

Confidential

Technical Lead/Senior Software Engineer

Environment: Database: Oracle 10 ETL: Informatica 9.1 Language: Oracle SQLThis project aims to develop, support ER (Enhancement Requests) and OPS activities for Confidential . ER development involves understanding of ERP modules/functionality, report development using Cognos10 BI, ETL using Informatica, DB changes using PL/SQL or Oracle SQL developer.

Responsibilities:

• Interaction with Business SME's on requirement gathering, understanding the business and functional requirements
• Designing the dimensional model and data load process using SCD Type 2.
• Use Informatica for extract, load and transform operations. This role participates in the design and the movement of data from the operational and external environments to the business intelligence environment
• Designed and developed Informatica mappings to build business rules to load data.
• Responsible for Quality Assurance & Testing Phases including System Testing, User Acceptance Testing (UAT), Integration Testing, Regression Testing, Post deployment testing, shake out testingInvolved in deployment activities
• Ensure the ETL code delivered is running, conforms to specifications and design guidelines
• Unit testing ETL code to ensure it can be delivered and run in a system testing environment.
• Perform root cause analysis.

Confidential

ETL/Data Integration Developer/Senior Software Engineer

Environment: Database: Oracle ETL: Informatica 8.6 Language: Oracle SQL, PL/SQL

Responsibilities:

• Created ETL mappings, sessions, workflows by extracting data from Oracle source systems.
• Involved in supporting the application until it is completely stable in Production.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Controlled Informatica workflow using PMCMD utility
• Used Powercenter transformations like Source, Source Qualifier, Expressions, Sorter, Aggregator, Joiner, Filter, lookup, Sequence generator, Router, update strategy, Target(Table and Flat File)
• Documenting the requirements into meaningful requirement specs.
• Maintain the production business intelligence products and solutions, including resolving production issues.
• Creating a Data Quality process to ensure the data consistency between source ERP and target ODS tables.
• Preparing test plan, test scripts and production support document for all the interfaces. Test data with all conceivable conditions in the SIT and UAT cycles

Confidential

BI Application Support/Senior Software Engineer

Environment: Database: Oracle ETL: Informatica 8.6 Language: Oracle SQL, PL/SQL

Responsibilities:

• Responsible for SLAs of the applications and jobs.
• Worked on various issues on existing Informatica Mappings to produce correct output.
• Unit testing to identify what can be done to improve effectiveness and efficiency.
• Weekly status reports which show various metrics on support hours spent by application, number of issues, SLA miss, etc.
• Proactively participate in performance tuning of jobs which have shown degradation in performance or have started to impact SLAs
• Organized daily technical discussions with the Onsite team and including the individual offshore work stream leads and set expectations for offshore delivery
• Set up Team Meeting every fortnight to stabilize the process, interacted with the client on various forums to discuss the status of the project.

Confidential

Technical support executive

Environment: Database: Oracle 9 Tools: BMC Remedy, TOAD Oracle DBA L1 Support

Responsibilities:

• Monitoring the Trace files and Alert log files. Creating user accounts /Service access requests, Service access deletion and troubleshooting with user accounts
• Handling the Remedy calls/incidents
• Monitor the Oracle Alert logs files, transaction logs and backup logs.
• RMAN Backup, Allocation tablespace size
• Table EXPORT/IMPORT, Move the data between Databases