PROFESSIONAL SUMMARY

• A dynamic professional with 15 + Years experience in Software Industry with core competence in leading EDW/BI Projects using Ab Initio, Data Architect, Data Analyst, ETL Specialist,, Oracle,PL/SQL Pentaho Kettle, System and Business Analyst
• Erudite in gathering business requirement, preparation of Use case Diagrams, SRS
• Documents, 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
• Knowledge of big data and Hadoop
• Experience of Pentaho Kettle

TECHNICAL SKILLS

• ETL tool Ab Initio, ACE appconf, Pentaho Data integrator(Kettle)
• Scheduler Control M, Autosys, Operation console
• Relational Databases- Oracle, SQL, SQL Server, DB2, Microsoft Access, Toad
• OLAP tool Discoverer
• Experience in Developer 2000
• Programming languages - C, C++, PL/SQL, UNIX Shell Scripting
• Operating systems - Windows XP/2003/2000/NT/98/95, UNIX, Solaris
• Other Tools - Erwin, MS Visio

PROFESSIONAL EXPERIENCE

Confidential

Data team Lead

Responsibilities:

• Involved in MDM activities
• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Working on data mapping for developing the ETL code
• Review the functional and technical Design Documents.
• Review of Kettle code
• Supporting SIT, UAT testing
• Analysis and fixing of ongoing issues

Confidential

Run Lead

Responsibilities:

• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Work in Design of the ETL application
• Working on data mapping for developing the ETL code
• Development of ETL code using Kettle,ab iniio
• Optimization of Kettle code, ab initio code
• Review the functional and technical Design Documents.
• Review of Kettle code
• Supporting SIT, UAT testing
• Analysis and fixing of ongoing issues
• Installation of Websphere application server, configuration of SSO
• Working with Vendor to configure the existing application
• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Work in Design of the ETL application
• Development of ab initio graph, Unix script
• Work on ops console
• Use Express>IT framework and create appconfig
• Review the functional and technical Design Documents.
• Prepare deployment plan and support transition activities.
• Review of Ab Initio code
• Supporting SIT, UAT testing
• Importing Metadata in Metadata hub
• Working in DQ rule specification in Metadata Hub

Confidential, IL

Lead Data analyst

Responsibilities:

• Requirement analysis
• Discussion with Development team Regarding impact of the requirement
• Discussion with integration team to analyze downstream application impact
• Understanding the canonical model
• Developing mapping document
• Understanding the defect and discussion with development team for resolution
• Work directly with business stakeholders as part of elaboration sessions to identify interface data requirements.
• Perform detailed analysis on source and target metadata and data, and formulate a position on functional design, data mapping and transformation rules/logic.
• Represent interface requirements to development and test teams
• Collaborate with the solution architect and developers for interface implementation.
• Own and manage updates to the to the project data dictionary.
• Support internal change control activities including impact analysis and solution options assessment.
• Support effort sizing and estimation activities for interface functional design and data mapping.
• Requirement analysis and design of the system
• Working in orchestration of the new process
• Development of the graphs using using ab initio
• Understanding the existing system and transitioning to offshore
• Onsite coordination
• Optimization of ab initio graphs
• Writing Autosys JIL scripts
• Writing unix shell scripts
• Code review and migration
• Supporting QA,UAT and Prod
• Onshore coordinator

Confidential, IL

Ab Initio developer

Responsibilities:

• Conducting transition and passing this knowledge to offshore
• Understanding the existing system and transitioning to offshore
• Job monitoring using JS Console.
• Resolving abends using ab initio graphs and escalating to the source team if required
• Developing temporary fix ab initio graph,unix script and fixing issue
• Optimization of ab initio graphs
• Onshore coordinator
• All L1 and L2 Support activities

Confidential, NJ

Ab Initio developer

Responsibilities:

• Worked on estimations, perform analysis and gathering requirements by coordinating with the Business users.
• Work in Design of the ETL application
• Development of ab initio graph, Unix script
• Work on ops console
• Use ACE framework and create appconfig
• Review the functional and technical Design Documents.
• Prepare deployment plan and support transition activities.
• Review of Ab Initio code
• Supporting SIT, UAT testing

Confidential, NY

Data Architect

Responsibilities:

• There are 12 sources whose data are pulled from Track simple and fed into Verve system. This project is meant to replace TS and create data using .net API grabber.
• A new data warehouse will be created to feed the data pulled from API grabber
• Data Analysis Data Profiling Data Modeling Discussion with SME
• Data mapping document from Source to Stage and stage to DW
• Working closely with Informatica team for Analysis of ETL mapping 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

Confidential, OH

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
• Writing Ab Initio code
• Check-in, check out of Ab Initio code in EME
• 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.

Confidential, VA

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
• Writing Ab Initio code
• Check-in, check out of Ab Initio code in EME
• 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.

Confidential, TX

Ab Initio Architect /Data Analyst

Responsibilities:

• Writing Ab Initio code
• Check-in, check out of Ab Initio code in EME
• Writing shell script using Unix
• Data Analysis
• Data Profiling
• Data Modeling
• 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.

Confidential, UK

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 data warehouse
• 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 Data warehouse

Confidential, AZ

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.

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.

Confidential

Ab Initio designer, OLAP developer, OWB Developer

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
• 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