SUMMARY:

• More than 12 years of work experience in Object Oriented Design, Modeling, Programming and Testing, Data warehousing, Relational Databases, ETL Tools, Java, J2EE, Big Data (Hadoop Ecosystem) and Project Management.
• Worked on waterfall, iterative, agile (scrum framework) project management methodologies.
• More than 7 years of experience on Informatica development and designing the work flows and mappings.
• Extensively used Informatica Power Center for design and development activities.
• Proven experience in all phases of Software Development Life Cycle (SDLC).
• Involved in database design, analysis, data storage, cost base analysis and backup strategy.
• Defining database governors for individual and batch ids.
• Expertise in Data warehousing, system integration, performance tuning, batch designing and object oriented designing.
• Expertise on UNIX Shell Script programming.
• Expertise on relational databases including Oracle, PL/SQL and involving stored procedures, triggers, functions, indexes, and packages.
• Expertise on data warehousing techniques and handled all types of SCD data.
• Hands on experience on RDBMS concepts and involved in the performance tuning of batch process which involves high volume data.
• Hands on experience on Informatica Data Quality and Informatica Meta data Manager Tool.
• Hands on experience in MS Visio, VPN, Putty, winSCP, FTP, Test Director, etc.
• Hands on experience in Object Oriented Programming using Java and J2EE related technologies.
• Strong knowledge of Design including J2EE Design Patterns Singleton, MVC, DAO, Builder, Business Delegate, Session Facade, Service Locator etc.
• Good domain knowledge in Banking and Financial industry.
• Self - learning on Apache Hadoop technologies, Python scripting and Scrum master.
• Good knowledge on HDFS architecture, reading and writing data from HDFS.
• Strong analytical skills with ability to quickly understand client’s business needs.
• Involved in requirement gathering and requirement elicitation discussion.
• Ability to accept challenges, passion to learn.
• Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.
• As a Subject Matter Expert (SME) for Historical Operational Data Store ( Confidential ) application provided ideas to improve the performance of batch process and meeting the System Level Agreement

TECHNICAL SKILLS:

Data warehousing Technologies: Informatica 9.1, SQL Loader, Data Junction

Databases: Oracle, DB2 UDB, SQL Server, MS Access, Postgres

Programming Languages: Java, J2EE SQL, Unix Shell scripting, PL/SQL, Markup languages

Source control: VSS, CVS, CMSynergy, Middleware IBM MQ Series

ETL Tools: Data Junction, Informatica 9.1, 9.6

Web/App Server: WEBLOGIC, WEBSPHERE, Tomcat, Oracle 10g

Tools: SQL Developer, Informatica, Informatica Data Analyzer, Eclipse, SQL Loader, IBM Data Studio, Test Director, Microsoft Visio

Software Methodologies: Waterfall, Iterative, Agile, Scrum

Big Data Apache: Hadoop stack

PROFESSIONAL EXPERIENCE:

Integrated Lead Providers Systems Analyst

Confidential, Bloomington, IL

Responsibilities:

• Liaison between data provision team and end users to identify the required data for daily analytics needs.
• Data model discussion with DBAs and data stewards.
• Solution and Design discussion with the technical team.
• Analyze the other downstream applications and integrated the new platform data with other applications.
• Data profiling by using Informatica Analyzer tool.
• Generate daily balancing report to genrate the prospects with the urgency information
• Informatica mappings to load Accepted, Rejected and Deleted prospects.
• Configure the FTP scripts to transfer the file without prompting the password during batch execution.

ENVIRONMENT: DB2, MS Visio, UNIX Shell Scripts, Informatica 9.6, IDQ, PL/SQL, Auto flow, Control M, IBM Data Studio, HP Service Manager

Integrated Auto Quotes Systems Analyst

Confidential, Bloomington, IL

Responsibilities:

• Liaison between data provision team and end users to identify the required data for daily analytics needs.
• Data model discussion with DBAs and data stewards.
• Solution and Design discussion with the technical team.
• Analyze the other downstream applications and integrated the new platform data with other applications.
• Data profiling by using Informatica Analyzer tool.
• Knowledge transfer between offshore team and BAU team.

ENVIRONMENT: DB2, MS Visio, UNIX Shell Scripts, Informatica 9.6, IDQ, PL/SQL, Auto flow, Control M, IBM Data Studio, Python, HP Service Manager

Strategic Data Migration Systems Analyst

Confidential, Bloomington, IL

Responsibilities:

• Strategies on migration activities with the guidance of PM and business partners.
• Review on data migration scripts and Informatica flows.
• Prepare the validation scripts to compare the data.
• Data profiling and comparing data between old and new platform.
• Identify the data gap between old and new data warehouse.

ENVIRONMENT: DB2, MS Visio, UNIX Shell Scripts, Informatica 9.6, PL/SQL, Auto flow, Control M, IBM Data Studio, HP Service Manager

Re-engineering Technical Lead/Database Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Analyze the database design and backup strategy.
• Facilitate discussion with DBAs to understand the database design.
• Analyze the application code and design to reduce the storage.
• Discussion with business to understand the data retention requirements.
• Design the solution to meet the business requirements without any data loss.
• Converting legacy load components to Informatica mappings with change history pattern.
• Design the workflows and mappings to identify the change history records and move it into new change history table.
• Developing required mappings using Informatica power center.
• Create Metadata data lineage for the files which are redesigned.

ENVIRONMENT: Oracle 11g, MS Visio, UNIX Shell Script, OEM Tool, Informatica 9.6, PL/SQL, UNIX scripts.

Occupation Report Technical Lead

Confidential, Minneapolis, MN, USA

Responsibilities:

• Actively involved in the strategy and finalized the approach to use Informatica web service.
• Recommended Informatica web service as the enterprise integration pattern with other systems.
• Discussion with portfolio architects, data architects to decide on strategic approach on data integration and exposure patterns.
• Creating required design artifacts for the projects.
• Create blue print and TIA for the application.
• Guiding the team on best coding standard and optimized approach.
• Capture end to end Metadata lineage between source and target.

ENVIRONMENT: Informatica Power Center 9.6, (Source Analyzer, Mapping Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Oracle 11g, MS Visio, UNIX Shell Script.

Technical Initiatives Technical Lead

Confidential, Minneapolis, MN

Responsibilities:

• Road map to build reports with BI tools by understanding the user requirement and better user experience.
• New strategies on BDIL/ Confidential data integration platform & BI initiatives
• Discussion with portfolio architects, data architects to decide on strategic approach on data integration and exposure patterns.
• Creating required design artifacts for the projects.
• Create blue print and TIA for the application.
• Guiding the team on best coding standard and optimized approach.
• Database re-engineering activities to reduce the DB size and avoid any kind of operational concerns.
• Solution to archive or purge the data based on RIM requirement.

ENVIRONMENT: Informatica Power Center 9.6, (Source Analyzer, Mapping Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager, Power Exchange), Oracle 11g, MS Visio, Windows, UNIX Shell Script, PL/SQL, SQL Loader, Power Designer.

Technical Lead

Confidential, Minneapolis, MN, USA

Responsibilities:

• Discussion with portfolio architects, data architects to decide on strategic approach on data integration and exposure patterns.
• Creating required design artifacts for the projects.
• Create blue print and TIA for the application.
• Guiding the team on best coding standard and optimized approach.
• Interacting with all cross commits.
• Periodic status update to the project team
• Capture end to end Metadata lineage between source and target.
• SIT & UAT support.

ENVIRONMENT: Informatica Power Center 9.1, (Source Analyzer, Mapping Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager, Power Exchange), Oracle 11g, MS Visio, Windows, UNIX Shell Script, PL/SQL and Power Designer.

AITT Technical Lead

Confidential, Minneapolis, MN

Responsibilities:

• Confidential is a 18TB of data store which stores historical and operational data.
• Migrating 18 TB of data without impacting to business is a challenging task.
• Careful planning with DBAs and business partners without impacting their day to day activities.
• Migration plan activities like hard and soft cutover.
• Optimize batch execution.
• Impact analysis by turning on Data Guard at Database level.
• Redesigning the batch to reducing the archival log generation.
• Validate the ETL, UNIX Shell scripts and DB migration.
• Guided the migration team on setting up application server and configuring TWS and NDM client.
• Co-ordinate with cross commits and operations team.
• Involved in code migration and testing activities.
• Designed the system to run dual batch for period 2 -3 weeks.

ENVIRONMENT: Informatica Power Center 9.1, (Source Analyzer, Mapping Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager, Power Exchange), Oracle 11g, MS Visio, UDB, Windows, UNIX Shell Script and PL/SQL.

Technical Lead

Confidential, Minneapolis, MN, USA

• Confidential is a nightly batch application with the SLA of 6 AM CST.
• Potential risk of breaching SLA due to increase in volume.
• Introduced stored procedures to gather stats and copy partition stats which increased the batch performance.
• Pre-schedule the copy partition job which yielded in good improvement in the batch process for high volume files. This idea got implemented during May Conversion 2012 and the batch process were able to handle the high-volume delta files without breaching the System Level Agreement (SLA).
• Solution provided to handle high volume update files. This solution got implemented in production and the system was able to process 60 million records against 150 million records less than 4 hours. Avoided all updates and delete statement which normally time consuming DML statements.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Mapping property changed to run with dynamic partitions which internally triggers and distributes the load between multiple nodes.
• Enabled bulk mode in the DB target mapping which will go for direct load instead of conventional load.
• Discussion with Data Architects to decide on data model, data quality, data integration and exposure pattern.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor
• Worked with sessions and batches using Server Manager to load data into the target database.
• Responsible for development, test and production mapping migration using repository manager.
• Worked on Tuning the Informatica Repository and Mappings for optimum performance.• Effectively played a multi dynamic role facing all challenges and managed working on similar projects as well.

ENVIRONMENT: Informatica Power Center 9.1, (Source Analyzer, Mapping Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager, Power Exchange), Oracle 11g, MS Visio, Windows, UNIX Shell Script, PL/SQL and SQL Loader.