PROFESSIONAL SUMMARY:

• A dynamic professional with 10 + Years experience in Software Industry with core competence in leading EDW/BI Projects using Ab Initio, Data Integration Architect, ETL Specialist, Information Architect, System and Business Analyst
• Erudite in gathering business requirement, preparation of Use case Diagrams, SRSDocuments, High level and low level design documents for Business as well as technical teams.
• Strong experience in designing and developing Business Intelligence solutions using different DW technologies for different Business Verticals .
• Strong experience in Preparing ETL Estimates and co - ordinating with business managers on resource management.
• Strong experience in building up offshore team and improving quality of deliverable to customer.
• Worked as Onsite Technical lead for various DW assignments at different customer sites.
• Experience with Oracle x more than 6 years
• Strong experience in Ab Initio
• Experience in developing logical and physical models using Erwin as modeling tool.
• Good understanding in analyzing the Informatica code.
• Experience working in both SDLC and Agile methodologies for software development
• Strong experience in data profiling and data quality. Worked on developing Audit/reconciliation processes for various customers.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies.
• Extensively worked on EME .
• Experience of working in scheduler like Control M,Autosys etc.
• Experience in writing and debugging UNIX, Linux and Shell scripting.
• Experience in data integration of heterogeneous source databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, XML files, etc.
• Involved in writing Complex queries using SQL for validating the data generated on Report from Data Warehouse tables
• Have effective working relationships with business/client team to understand requirements, develop tactical and strategic plans to implement technology solutions to meet customer/business expectations
• Possess excellent communication and inter-personal skills and has been actively involved in customer coordination.
• Experience in Discoverer,Oracle,SQL,PL/SQL

TECHNICAL SKILLS:

ETL tool: Ab Initio

Relational Databases: - Oracle, SQL, SQL Server, DB2, Microsoft Access, Toad

OLAP tool: Discoverer

Programming languages: - C, C++, PL/SQL HTML, Java, UNIX Shell Scripting

Operating systems: - Windows XP/2003/2000/NT/98/95, UNIX, Solaris

Other Tools: - Erwin, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Data Architect

Responsibilities:

• Data Analysis
• Data Profiling
• Data Modelling
• Discussion with SME
• Data mapping document from Source to Stage and stage to DW
• Working closely with Informatica team for Analysis of ETL mappingand suggest for fixes
• Working with DBA for database changes based on the analysis
• Working closely with offshore team for helping them clarifying queries in Development

Environment: Erwin,Informatca

Confidential

Ab Initio Team Lead

Responsibilities:

• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Worked on ETL effort estimates and preparing SRS for applications for couple of projects
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio
• Interact with business and document the requirements
• Understand and enhance the current architecture
• Review the functional and technical Design Documents.
• Prepare estimates for the CRs and upcoming projects
• Prepare project/Module implementation plan.
• Prepare deployment plan and support transition activities.
• Review of Ab Initio code
• Participated in Architecture and Design review with Customers .
• Worked with Data Architects in designing Physical model for.
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Managing the offshore team as Architect and Technical Lead.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log, Requirement doc, Technical spec, SOW, project Estimates etc.

Environment: Ab Initio, Db2, UNIX Shell Scripting, EME,Autosys

Confidential

Ab Initio Architect /Data Analyst

Responsibilities:

• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Worked on ETL effort estimates and preparing SRS for applications for couple of projects
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio
• Interact with business and document the requirements
• Understand and enhance the current architecture
• Review the functional and technical Design Documents.
• Prepare estimates for the CRs and upcoming projects
• Prepare project/Module implementation plan.
• Prepare deployment plan and support transition activities.
• Review of Ab Initio code
• Participated in Architecture and Design review with Customers .
• Worked with Data Architects in designing Physical model for.
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Managing the offshore team as Architect and Technical Lead.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log, Requirement doc, Technical spec, SOW, project Estimates etc.

Environment: Ab Initio, Db2, UNIX Shell Scripting, EME, Control M

Confidential

Ab Initio Architect /Data Analyst

Responsibilities:

• Data Analysis
• Data Profiling
• Data Modelling
• Discussion with SME
• Data mapping document from Source to Stage and stage to DW
• Working closely with ETL team for Analysis of ETL code and suggest for fixes
• Working with DBA for database changes based on the analysis
• Working closely with offshore team for helping them clarifying queries in Development
• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Worked on ETL effort estimates and preparing SRS for applications for couple of projects
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio
• Writing Ab Initio code by using the different component like join,Reformat,Sort,Partition by Key
• Check-in, check out of Ab Initio code in EME
• Unit testing
• Interact with business and document the requirements
• Understand and enhance the current architecture while integrating the new systems
• Review the functional and technical Design Documents.
• Prepare estimates for the CRs and upcoming projects
• Prepare project/Module implementation plan.
• Prepare deployment plan and support transition activities.
• Review Data Integration/Presentation code components
• Participated in Architecture and Design review with Customers.
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Managing the offshore team as Architect and Technical Lead.
• Coordinating UAT with testing team and Clients and Creating the UAT plan. Compiling Daily status reports.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log, Requirement doc, Technical spec, SOW, project Estimates etc.
• Environment: Ab Initio,Oracle, UNIX Shell Scripting, EME

Confidential

Ab Initio Lead

Responsibilities:

• Requirement analysis
• Design of Data repository and Data marts
• Preparation of LLD
• Estimation of the work
• Maintenance of SOA 2b system
• Leading the team and conduct coordination between client, onsite and offshore team .
• Interacting with client and understanding business & technical requirement.
• Closely working with client Architect for the design of datawarehouse
• Worked on ETL effort estimates and preparing SRS for applications for couple of projects
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio
• Writing Ab Initio code by using the different component like join,Reformat,Sort,Partition by Key
• Check-in, check out of Ab Initio code in EME
• Unit testing
• Understand and enhance the current architecture while integrating the new systems
• Review the functional and technical Design Documents.
• Prepare estimates for the CRs and upcoming projects
• Prepare project/Module implementation plan.
• Prepare deployment plan and support transition activities.
• Review Data Integration/Presentation code components
• Participated in Architecture and Design review with Customers.
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Managing the offshore team as Architect and Technical Lead.
• Coordinating UAT with testing team and Clients and Creating the UAT plan. Compiling Daily status reports.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log, Requirement doc, Technical spec, SOW, project Estimates etc
• Creating conceptual design and Physical design of Datawarehouse

Environment: Ab Initio,Oracle, UNIX Shell Scripting, EME,MS Visio

Confidential

Project Lead

Responsibilities:

• Writing Ab Initio code by using the continuous flow
• Check-in, check out of Ab Initio code in EME
• Unit testing
• Interact with business and document the requirements
• Understand and enhance the current architecture while integrating the new systems
• Review the functional and technical Design Documents.
• Prepare estimates for the CRs and upcoming projects
• Prepare project/Module implementation plan.
• Prepare deployment plan and support transition activities.
• Review Data Integration/Presentation code components
• Participated in Architecture and Design review with Customers.
• Developed Ab Initio graph using Continuous flow
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Managing the offshore team as Architect and Technical Lead.
• Coordinating UAT with testing team and Clients and Creating the UAT plan. Compiling Daily status reports.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log, Requirement doc, Technical spec, SOW, project Estimates etc.

Environment: Ab Initio,Oracle, UNIX Shell Scripting, EME

Confidential

Project Lead

Responsibilities:

• Requirement analysis and design of the system
• Preparing HLD, LLD, UTP and Integration test plans
• Presentation of the system to client
• Making Ab Initio graphs
• Participating in Integration testing with QA people.
• Check-in, check out of Ab Initio code in EME
• Unit testing
• Interact with business and document the requirements
• Understand and enhance the current architecture while integrating the new systems
• Review the functional and technical Design Documents.
• Prepare estimates for the CRs and upcoming projects
• Prepare project/Module implementation plan.
• Prepare deployment plan and support transition activities.
• Review Data Integration/Presentation code components
• Participated in Architecture and Design review with Customers.
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Managing the offshore team as Architect and Technical Lead.
• Coordinating UAT with testing team and Clients and Creating the UAT plan. Compiling Daily status reports.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log, Requirement doc, Technical spec, SOW, project Estimates etc.

Environment: Ab Initio,Oracle, UNIX Shell Scripting, EME

Confidential

Ab Initio designer,OLAP developer,OWB Developer

Environment: Ab Initio,Oracle Warehouse Builder, Discoverer,Oracle, UNIX Shell Scripting, EME,SQL,PL/SQ

Responsibilities:

• Making Ab Initio graphs
• Creating Reports using Discoverer
• Unix Shell scripting
• Requirement analysis and Design
• Tuning ab initio graph
• Unit testing
• Check-in, check out of Ab Initio code in EME
• Creating mapping in OWB
• Working in initial load and incremental Load strategy

Confidential

Data Analyst

Environment: Oracle,SQL,PL/SQL,Developer 2000,Visio

Responsibilities:

• Preparation of technical specifications and requirement gathering
• Database Design
• Validations and Unit testing
• Presentation of system
• Working in PL/SQL blocks, procedure,Trigger,Packages
• Working in Developer 2000 Forms
• Working in reports by Developer 2000 Report Builder
• Preparation of technical specifications and requirement gathering
• Enhancement of system based on user’s requirement
• Presentation of system to the client
• Optimizing sql queries