PROFILE:

• Technically accomplished IT professional with enriching experience of 8 years in generating value for stakeholders.
• Professional experience in IT in the areas of Application Software Development, Analysis, Design, Testing, Implementation and co - coordinating offshore activities, maintenance of systems, Team lead and Technical manager roles.
• Experience in managing end to end project life cycle starting from requirements till post production support
• Portfolio level metrics and status reporting to client directors and program managers.
• Extensive experience in design, Develop and implementing data ware house application using various Business Intelligence tools like Informatica, Business objects & Micro Strategy.
• Extensive experience in working on various databases like Oracle, Teradata, Sybase, DB2.
• Lead 24X7 production support and provided continuous support to Business users
• Extensive experience in Data analysis, Functional testing and System Integration testing.
• Extensive experience in preparing estimations for projects using various estimation models.
• Extensive hands on experience in various data warehouse technologies using Informatica, IDQ, COGNOS, and Business Objects.
• Expertise in analyzing data quality, data organization, metadata, and data profiling.
• Expertise with Teradata query performance and tuning, collect statistics and secondary indexes.
• Good knowledge about HADOOP and HIVE technologies.
• Possess the ability to think outside the box and come up with creative and unique ideas in order to maximize opportunities. An excellent problem solver and seek to build solid relationships with peers, partners, and other colleagues.

TECHNICAL SKILLS:

ETL Tools: Informatica v9.6, IDQ

Database Tools: Oracle, DB2, MS-Access, Teradata, SQL server

BI / Reporting Tools: Business Objects, COGNOS

Big Data: Hadoop, HIVE

Teradata Utilities: Fastload, Multiload, BTEQ

Operating System: Windows, Linux

Query languages: SQL, T-SQL, PL/SQL

Scheduling Tools: ESP, CA Workload.

Project Management: MS Project, MS EXCEL

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Preparation of estimates and proposals for projects and review internally with senior leadership.
• Create design and review with stake holders including client teams
• Setup and execute project plans with respect to Development and Testing.
• Onboarding & Off-boarding resource (On/Off shore teams) based on the requirement.
• Interacts with client management to report the team’s testing matrices and provides recommendations for quality improvements.
• Lead ETL requirement design & development activities; Map Source to Target, Business Logic, ETL Flows, ETL Framework, scheduling and dependencies
• Responsible for Integration test strategy and plan.
• Pro-actively address customer issues and prepare alternative solution as and when required.
• Review and approve deliverables (test plans, test strategy, results etc. from on/off shore teams.
• Work with development team and trouble shoot design issues and provide solution on critical development issues.
• Mentor onshore/offshore team members to ensure quality of the product.
• Provides escalation support for off-shore teams.

Technologies: Informatica, Oracle, DB2, SQL Server, Unix, Windows, BO, Crystal Reports

Confidential

ETL Senior Developer

Responsibilities:

• Create design and review with stake holders including client teams
• Setup and execute project plans with respect to Development and Testing.
• Work with development team and trouble shoot design issues and provide solution on critical development issues.
• Participate in design reviews and provide recommendations.
• Design and execute data quality rules based on the data and business rules.
• Coordinated with the Business Analysts, Data Architects, DM’s and users to understand business and functional needs and implement the same into validations.
• Review ETL requirements and propose best practices.
• Help business and other stake holders in the validations
• Preparation of various status reports and review with management.
• Setting up data quality guidelines and execute.

Technologies: Informatica, BO, Oracle, DB2, Teradata, UNIX & Windows.

Confidential

ETL Developer

Responsibilities:

• Responsible for development and implementation of the project.
• Responsible for setting up ETL architecture guidelines.
• Designed tables, semantic views and ETL Design.
• Coordinated with the Business Analysts, Data Architects to understand business and functional needs and implement the same into an ETL technical design document.
• Working knowledge on pervasive data integrator, teradata scripts & performance tuning
• Provide mentoring & guidance to onshore & offshore team members including client team members.
• Excellent SQL coding & tuning skills with in-depth knowledge in analyzing SQL Explain plans and performance tuning.
• Conduct training and knowledge sharing sessions with ETL support and operations teams and internal stakeholders as needed.
• Recommend continuous improvement of the ETL architecture and processes

Environment: Informatica, Teradata, Teradata Tools and Utilities, Teradata SQL Assistant 12, BTEQ, Oracle.