OBJECTIVE:

I am looking for a challenging role in the area of Business Intelligence / Data Warehouse Implementation that would best utilize my 10.5 years of IT experience in Data warehousing platform for Confidential 500 clients.I have been involved in various Data warehousing and Application Development, Maintenance/enhancement projects involving roles including Technology Lead, Consultant, project management, Requirements gathering, systems analysis, design, development, testing & implementation and maintenance of various BI applications to support business processes and have worked thought leadership initiatives

SUMMARY:

• A competent IT professional with more than 10.5 years of experience in ETL, Data Warehousing projects in all Phases of Software Development Life Cycle.
• Around 4+ years of client - facing experience at Onsite locations USA, UK for clients Citi , Confidential .
• Strong knowledge and exposure in ETL, RDBMS and Data warehousing concepts
• Extensively worked on projects for clients in Banking, Cards and Risk and compliance, which included Data Migration and Data Quality implementation.
• Demonstrated abilities in handling big projects on Data-warehousing within time budgets and calendar schedules while handling multiple tasks.
• Have worked with multiple projects with teams across different time zones and multiple vendors.
• Enthusiastic learner who quickly grasps new concepts and technical skills.
• Expertise in Informatica, Ab initio, Unix, Oracle.
• Has experience in managing and liaising with Business users across various levels in EMEA
• Has sound knowledge and experience of ETL Design and testing with Abinitio using data parallelism and Ab Initio data transform components
• Experienced in Requirement Gathering, Development, Effort Estimation, Coordinating User Acceptance Testing, User Profile Creation & Application Deployment in Production
• Has experience in analysing existing business processes and applying data warehousing skills to enhance productivity and turnaround time
• Excellent communicator with strong information analysis skills combined with flexible & detail oriented attitude.
• Good analytical skills with keen perception and a very efficient team player.
• Requirement Gathering, Estimation, Impact analysis, System design and mapping to the existing business process, and Project Status reporting
• Project Planning, Monitoring and taking bottom line responsibility of project in agreed timelines
• Review of Transformation rules and Requirement document for Functional and Non-Functional requirements
• Design and Development that included High Level, Low Level Design, Unit Test Plan
• Leading the team and Onsite - Offshore coordination
• Project tracking and reporting
• Involved rigorously in Performance Tuning and Troubleshooting
• Test Support & Defect Triage
• Implementation plan preparation and Scheduling Changes
• Implementation, Post-Implementation Support and Production support
• Handled end to end project execution for small and medium projects
• Responsible for identifying the solution and process in alignment to project needs and ensure adherence to development and quality process
• Involved in end to end development phase continued with unit and integration testing
• Maintaining the data integration that has been established to handle complex extraction, data transformations for the banking client
• Facilitating stakeholders and team status meetings

TECHNICAL SKILLS:

• Project Planning, Monitoring and Management
• Effort estimation
• Resource Planning
• Onsite - Offshore coordination
• Client Liaison
• Quality Assurance
• Identify and mitigate risk
• Certified Scrum Master
• Finance
• Confidential ii
• Risk & Compliance
• Requirements Collection and Analysis
• Source System Data Analysis
• Development and Testing
• UAT support
• Implementation
• Risk Analytics
• Business Intelligence Analyst
• Financial Reporting
• ABINITIO GDE-1.14.38,
• GDE -1.15.7.2 and CO ops 2.14.73, 2.15
• EME 2.14.70,2.15,
• Ab initio DASHBOARD,Constellar;
• Informatica 8.6
• Oracle 9i,Oracle 10G
• Unix
• Windows 2000

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead/PM

Environment: Informatica 9,Ab initio,Teradata, Event Engine, UNIX

Responsibilities:

• Involved in requirement gathering, analysis and effort estimation.
• Preparation of the document of the understanding for the requirement analysis and other problem statements
• Involved in the re-designing of the DW architecture.
• Reviewing Codes developed by the team members and mentoring new joiners.
• Development of graphs in AB INITIO, mappings in Informatica.
• Unit Testing and Integration Testing.
• Ensuring Quality and adhering of CMMI L5 standards in project.
• Involved in Project Management activities like Invoicing, allocation and on boarding of resources.
• He is responsible for complete offshore deliverables, resource management and providing technical guidance to offshore team.
• He is also responsible for interacting with multiple stakeholders like BIDW admin team, DBA team, and source system owners.

Confidential

Tech Lead

Environment: Informatica 9, Oracle, Control-M, UNIX

Responsibilities:

• Project tracking and reporting
• Review of transformation rules and requirement document for Functional and Non-Functional requirements
• Analysis for the existing code and preparation of Impact Analysis document
• Development and Unit Testing
• Data Analysis and Performance tuning
• Test data setup, Unit Testing and update the unit test results
• Code & unit test results Review
• Deployment of code to other environments
• Remedy Creation and deploying the code into production.
• Integration Testing and UAT Support
• Implementation plan preparation and Implementation Support

Confidential

Responsibilities:

• Multiple Confidential depending on efficiency in execution - C360, X-Sell, Retention, Lifecycle
• Need to consolidate internal and external data in a central repository
• Require scalable infrastructure for model development, scoring and deployment of models and strategies
• Replace limiting manual processes to create standardized modeling and scoring processes to achieve aggressive risk and marketing NI goals
• Quicker Model/Score Development & Faster Deployment of Models on Delivery Systems
• Simplified and sustainable process and environment
• Better targeting and analysis with richer data
• 16 CPU Server to Support ETL and Queries
• 20 TB Oracle Table Storage
• Separate Server for FICO Model Builder
• 2 TB of Analytical Storage