PROFILE:

• A self - managed and result-oriented Project Lead/Engineer with Nine years and 8 Months of experience in Project Development, Crew Supervision, Technical Support/Maintenance and Client Relations. /DevelopmentStrategically manage with strong interpersonal, communication, problem solving and decision making skills.
• Ability to establish and maintain strong alliances; lead and motivate teams; drive projects to successful Completion; convey complex technical requirements/data; exceed customer expectations and achieve Fiscal bottom-line results.
• 9 years and 8 months of career reflecting experience and high performance in System Analysis, design, development, implementation support and maintenance of Relational Database and Data Warehousing Systems using DataStage, Informatica and Teradata Utilities Bteq, Fast load, Mload.
• Involved in many Business Intelligence and Analytics projects which would drive the business to target the customers.
• 3 Years and 9 months of Experience in leading team of 14 members in ETL and Reporting teams for both Water Fall and Agile methodology projects.
• 5 years of experience as Data Analyst.
• Involved in Understanding business requirements, translate them into solutions based on the market intelligence with POC and presenting this to the stake holders.
• Establishes the Design Repository and Metadata Repository for integrating all aspects of these models, and provides oversight of its use in conjunction with integrated Tool sets.
• Responsible in preparing the Design document for ETL framework based on the Requirement Doc.
• Responsible for enterprise application integration (EAI). This includes defining the opportunities for integration, selecting the tools, specifying the shared data & code resources, defining the interfaces and data-flows, and monitoring the success of said integration.
• Expertise in Extraction Transformation and Loading (ETL) and Extraction Loading and Transformation (ETL) processes.
• Strong skills in IBM DataStage (DataStage Enterprise Edition & Server Edition), Teradata Bteq, SQL, Performed Debugging, Troubleshooting and performance tuning.
• Experience in Designing, Developing, Documenting and Testing of ETL Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Experience in Data analysis, Database design, Data migration Production Support.
• Worked on various operating systems like UNIX AIX, Sun Solaris and Windows and Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Committed to continuous improvement, excellent communications, and project management skills. Self-disciplined, focused, solid teamwork and a team player.
• Strong technical writing skills and the ability to work effectively with all levels of the organization.
• Worked on various area of the Project development phase. Have seen a full life cycle of a project development.

TECHNICAL COMPETENCIES:

ETL Tool: DataStage, Informatica

Scheduling Tool: Control M

Database: Netezza, Teradata (SQL),DB2 (SQL), Oracle (SQL)

Operating Systems: Unix, Windows 9x, Windows 2000, Linux

FUNCTIONAL COMPETENCIES:

• Exposure to Retail domain.
• Exposure to banking domain.
• Exposure to SCM domain for manufacturing industry of steel.

PROFESSIONAL EXPERIENCE:

Confidential

Technical / Project Lead

Environment: DataStage, Teradata, Control M, Unix, Windows, SQL.

Responsibilities:

• Successfully lead and manage technology projects ensuring high reliable and up to 100% accessible. I lead managed multiple, full life-cycle projects concurrently, and with my ability to improve technology impact, delivered projects requiring less maintenance cost.
• Leading teams in both Waterfall and Agile methodology projects.
• Leading teams in Implementing ITIL framework for Service and Support.
• Co-ordination for project transition from development to support.
• Acted as single point of contact for multiple vendors, business units, and Information Technology partners during integration.
• Identify and plan risks and escalate unresolved issues on time.
• Leading weekly meetings, helping to facilitate communication and maximize productivity.
• Liaison among departments and managers, acting as sole point of contact to integrate managed workstation environment with minimal downtime.
• Designing Control M jobs to work in efficient way.
• Key player in DataStage and CONTROL M Code reviews.
• Data Analysis on new requirement, production breaks / bug fixes.
• Requirement Gathering for new Enhancements to existing applications.
• Time estimation for issues fixes
• Monitoring production environments: - Control M, DataStage, Teradata (Database) etc.

Confidential

Technical / Project Lead

Environment: Data Stage, Teradata, Netezza, Control M, Unix, Windows, SQL.

Responsibilities:

• Successfully lead, manage and migrated Netezza application to Teradata ensuring high reliable and up to 100% accessible and delivered project requiring less maintenance cost.
• Acted as single point of contact for business units and Information Technology partners during migration, Development and integration.
• Lead weekly meetings, helping to facilitate communication and maximize productivity.
• Liaison among departments and managers, acting as sole point of contact to integrate managed workstation environment with minimal downtime.
• Designing Control M jobs to work in efficient way.
• DataStage and CONTROL M Code reviews.
• Data Analysis for code migration, reliability.
• Analysis on reusability of Teradata Tables/Views during migration
• Requirement Gathering for new Enhancements to existing applications.
• Time estimation for issues fixes.
• Analysis on performance improvement steps of code.
• Implementing ITIL framework for Service and Support.

Confidential

Senior Software Engineer

Environment: Data Stage, DB2, SQL, Unix, Windows.

Responsibilities:

• Gathering requirements and understanding the purpose of requirements how they are going to be used in building business.
• Designing and Development of DataStage Jobs.
• Data Analysis on developed code output as per requirements.
• Designing Control M jobs to work in efficient way.
• DataStage and CONTROL M Code reviews.
• Writing Sql codes, Source to Target mapping document and designing DataStage jobs.

Confidential

Senior Software Engineer

Environment: Data Stage, Oracle 10g, SQL, Unix, Windows.

Responsibilities:

• Gathering requirements and understanding the purpose of requirements ow they are going to be used in building business.
• Designing and Development of DataStage Jobs.
• Data Analysis on developed code output as per requirements.
• Building Data Stage Jobs for above mentioned modules.
• Writing Pl/Sql codes.

Confidential

Software Engineer

Environment: Informatica 7.1.2, Oracle 10g, Sql, i2MDM, Unix, Windows.

Responsibilities:

• Building Informatica Adapters for SPP and SCP modules.
• Writing Pl/Sql codes for SPP and SCP modules related to bucketization, Vessel Requisition etc...
• Creating tables in i2MDM which is accessible by UI.