SUMMARY:

• Technical Lead with 9+ years of experience in Software design, development, testing, integration and deployment using Informatica, Pentaho, UNIX, Oracle, PL Sql, Teradata, Sybase and Business Intelligence tools.
• Possess extensive technical knowledge in using and supporting enterprise wide IT applications in various Industries such as Private Banking - Global Wealth Management, Communication & High Tech, Supply Chain and HR. Have profound knowledge and experience in the areas of capturing requirements, working experience in designing star and snowflake schema, performing Extract Transformation and Load processes.
• Over 9 years of experience in Informatica ETL tool during which worked upon 9. X / 8. X / 7. X versions of the tool and implemented end to end solutions for Private Bank- Global Wealth Management (GWM) data store, C&HT, Supply Chain and HR Data warehouses.
• Overall 5 years of working experience as ETL Lead. Currently working as Scrum Master and managing a team of 8 people (onshore-offshore) to provide end to end solutions for Client and Credit business areas for Global Wealth Management. In the past, have handled Onshore - offshore team model of roughly 10-15 members.
• Working experience of Pentaho Data Integration tool. Currently working and leading a conversion project from in-house Java engine to Pentaho.
• Working experience of Java based ETL engine tool, which is an in-house ETL tool for Global Wealth Management.
• Working experience in designing star and snowflake schemas.
• Experience in integration of various data sources like Oracle, Sybase, SQL Server, Teradata, Flat Files and XML Files.
• Experienced with Agile and Waterfall SDLC Methodology to implement Data warehouse solutions.
• Good understanding of Informatica administration and Informatica configurations.
• Strong working experience in Sybase, Oracle 11g/10i/9i/8i, PL Sql, Teradata and Unix shell scripting.
• Working experience of various scheduling tool such as CA scheduler, Crontab scheduling, TIDAL and $U scheduler tools.
• Good understanding of Business object, SAP HANA and OBIEE reporting tools and over 6.5 years of data integration experience to provide the data for reporting needs.
• 1.5 years of experience in Hyperion brio and BOXI reporting tool. Additionally, trained in SAS BI data integration tool.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn project's business requirements. Excellent communication skills, management and leadership qualities.

TECHNICAL SKILLS:

Programming Languages: Shell Scripting, perl scripting, PL Sql

Databases: Oracle 9i/10g,11g MS SQL server, Teradata, Sybase

Data Warehousing technologies: Pentaho Data Integration, Informatica power center 9.X/8.X/7.X, Informatica Power Exchange, Java ETL Engine

Reporting Tool: Hyperion Brio, BOXI, Business Object, SAP HANA, OBIEE

Operating Systems: Windows 7/XP/2000/NT/98, Linux, Solaris, Macintosh

Database tool: Toad, Sql Plus, Teradata Sql Assistant, SQL Browser

Cyber Security Tools: CyberArk Asset Management Identifier (Id/Password management tool)Scheduling & Code Deployment tools: SVN, YART, ARM, StarTeam, TIDAL, $U Scheduler, CA scheduler, Autosys

Other tools: SAS BI tool, Remedy, Mercury Quality Center, JIRA, Scrun, Kanban

PROFESSIONAL EXPERIENCE:

Confidential

Associate Application Developer

Responsibilities:

• Working as a Scrum Master to handle all the requirements related to Client and Credit business areas using Agile Methodology. As Scrum Master, working on performing estimation, resource allocation and designing the system to fulfill the requirement.
• Working and leading a project to convert 1 Java ETL Engine to Pentaho Data integration tool. As part of this effort, converting close to 800 Java transformations to Pentaho ktr by end of Q3.
• Designed and developed new informatica jobs to perform system integration for new Credit application.
• Performed Proof of Concept for functional batch id management to store the password in CyberArk application (AIM) and provide the encrypted password during runtime in stead of hardcoding the password in informatica relational connections. After proof of concept, designed the infrastructure to scale the AIM utility to any system/tool and lead the effort to change more than 4000 existing informatica jobs to use AIM to get the password. Now working on implementing this concept to other line of businesses.
• Worked upon re-architecting Scrum and Kanban Agile board within our project and introduced many new standards in scrum board to efficiently track the progress, status and stage of individual JIRA stories to support continuous development module using Agile methodology.
• Worked upon standardization of jobs/processes within our team by converting 1 out of 3 In-house Java ETL Engine code to Informatica code. Hence, created close to 200 new Informatica jobs, improved code quality, and reduced production issues by 10-15%.
• Worked upon design and development of Informatica jobs to generate standard denormalized data feed so that the same data can be distributed to multiple team/applications without developing individual informatica processes for each team.
• Working on a Proof of concept for Vormetrics database level encryption for various databases and identifying the performance impact to determine the viability of Vormetrics encryption in our databases and Linux servers.
• Regularly work with Lead Design Authority for Asset Management to interact with different teams within GWM/GIM space, understand their systems, perform risk assessment of their current architecture and provide recommendation to improve their current architecture and mitigate any current/future risks.
• Worked upon identifying redundant/obselete jobs running against different DBs and converting/decommissioning those jobs. So far, participated in decommissioning more than 20 Databases.
• Gathered requirements from Data Analyst team, designed and developed new Informatica and CA jobs to load data to bring Mexico, Chile and Brazil Accounts and Clients information to America and International data store

Confidential

Team Lead

Responsibilities:

• Gathered new requirements from business as well as Functional specification document, performed analysis and provided ETL Design and project estimation.
• Understood existing ETL design and business reporting requirement, identified the issue in the existing ETL, performed gap analysis and provided new design for better performance and data accuracy.
• Identified and changed existing full data Refresh to incremental refresh at the source as well as target end to improve the ETL performance.
• Worked on DB upgrade from 10g to 11g, which involved testing and upgrading each ETL for the DB upgrade and migration.
• Provided project Estimation and work plan for end to end project.
• Worked on Dollar U scheduler job development and kintana deployment packages to QA and production environment.
• Managed a team of 6 people in onshore-offshore model.

Confidential

Team Lead

Responsibilities:

• Interviewing, selecting and on-boarding resources to build a Business Intelligence team in India and US to start a new project with a new client.
• Handling Knowledge transfer for the new module from different vendors and creating knowledge repository for the new project.
• Involved in Requirement gathering, BRD review, Functional Specification Document and RTM review & finalization by directly interacting with Business and Functional analysts.
• Leading interaction with Functional SME to map the requirement with Source systems and work upon technical design for the requirement.
• Preparing project Estimation and work plan for the end to end project including Development, QA and deployment efforts.
• Leading and working on creating the ETL workflow, peer review for ETL code and suggesting performance improvement of the design to the team members. Also, implementing Informatica logic to support Near real time reporting.
• Working on validation of BO reports as part of Business Acceptance testing (BAT) for end result.
• Handling and addressing resource planning and staffing for the project.
• Managed a team of 15 people in onshore-offshore model.

Confidential

Team Lead

Responsibilities:

• Understand and document Functional and Technical Design Documents and review the design documents created by other members.
• Design the ETL logic, leading code build, peer review for ETL code and suggest coding standard and performance improvement of the design to the team members.
• Ensure proper implementation of the solution design which includes building prototypes before the actual build, coding, Code Reviews, taking care of coding standards, documentation and deployment.
• Ensure smooth Project Operations by delivering within project deadlines maintaining healthy SLA thereby achieving project and company goals.
• Building Near offshore (Argentina) team, transitioning work to them and supporting them in gaining expertise to handle the application during US hours.
• Managing, distributing and assigning work to offshore team of 10 people and handling day to day project and resource management.
• Creating and providing project status and monthly variance analysis reports, CPI (Cost Performance Index)/SPI (Schedule Performance Index) for base/derived measurement information specifications to client and project management.
• Involved in drafting and finalizing the New Service Level Agreement consisting of new team structure as per the ongoing client business change.
• Coordinating teams between US, Argentina and India delivery centers.