SUMMARY

• 10+ years of experience in IT industry in data warehousing applications. 10 years of ETL Experience in Ab - Initio
• Preparation of high level system specification based on the business requirements. Training, mentoring and guiding the team on product knowledge
• 10+ years as Developer/Senior Developer. Experience spanning all phases of software development life cycle viz. Requirement Analysis, Design, Development, User Training, Implementation and Production Support
• Extensive hands-on experience in core Ab Initio concepts like Parallelism, MFS, and PDL.
• Experience in using EME for version controls, impact analysis and dependency analysis.
• Developed generic Ab Initio graph for loading teradata using Fast load or API based on data volume.
• Addressing the complete life cycle for all data integration projects including data warehouses and data marts, data migration and information hubs
• Exposed to the Implementation of OLAP Applications and Analytical Report analysis
• Experience in SQL/PLSQL, Coding Procedures, Functions, Database Packages and Triggers
• Expertise in Oracle 10i/9i/8.x/7.x
• Coordination and management of projects to successful completion
• Technical mentor with excellent communication and client liaison skills
• Also worked extensively in Oracle/Teradata database
• Wrote scripts for batch scheduling on Linux 3.1/4.1
• Have profound knowledge and experience in Dimensional Modeling and Enterprise architecture

TECHNICAL SKILLS

Development: Ab Initio (Co>Op sys 3.1, GDE 3.2), PL/SQL, C, C++, COBOL, Oracle 8i/9i/10g, Teradata V2 R5 and SQL Server 7.0, SQL* plus, SQL* Loader

Operating Systems: Windows XP/2000/98/95, UNIX

Methodologies: Agile, Waterfall

Industries: Airlines/Travel, Finance

PROFESSIONAL EXPERIENCE

Confidential, Tampa

Lead ETL Developer

Responsibilities:

• Defined management and customer requirements and produced project plans.
• Lead a team of Ab-initio ETL developers (associates and consultants) and ensured quality delivery of requirements to the stakeholders/business user.
• Responsible for scheduling project deliverables, goals and milestone and experience in cost management, time management, risk management, and integration management.
• Collaborated with stakeholders/support groups and users to expedite incident resolution as well as change plans. Coordinated meetings to gather status/requirements and develop standardized documentation, verification, sign off and freeze requirements to build estimation and UAT completion with the stakeholders/business user.
• Collaborated with other tech leads and support teams to ensure integrated end-to-end availability, reliability, and performance.
• Responsible for converting business requirement elicitation and transmuting them into technical specifications.
• Reported to both business and technology leaders to provide status updates on the critical milestones of the project and generated project measurement reporting for management and stakeholders.
• Responsible to follow-up and define release process and to ensure quality delivery to the business user.
• Responsible for publishing periodic project status reports and regularly review the progress with management, customers, and key stakeholders.
• Developed statement of work, integrated project plan, resource plan, contingency plan, and other related project management artifacts.
• Handled and worked on DW/BI project designed using Ab Initio, BRE and Unix shell scripts

Confidential

Senior ETL Developer

Responsibilities:

• Experienced in analysis, process modeling, program management and solution development.
• Experienced in waterfall methodology and agile methodology wrote user stories based on the requirements gathered from all the stakeholders.
• Experienced in analyzing the complexity of the existing application and providing estimates while migrating to new applications.
• Organized and facilitated Agile and Scrum meetings, which included sprint planning, daily scrums or standups, sprint check-in, sprint review & retrospective.
• Operated in 3-week sprints with flexibility on length based on immediate functionality concerns.
• Ensured application availability and data integrity through preventative maintenance and upgrades.
• Analyzed & supported the existing system to provide inputs to estimate new request change.
• Automated routine maintenance tasks and common issues.
• Extensive usage of the multifile system where data is partitioned into four partitions for parallel processing in various Ab-Initio graphs.
• Collaborated with other team tech leads and support teams to ensure integrated end-to-end availability, reliability, and performance
• Responsible for providing overall day-to-day input/support for dwh developers in their work efforts. Guided the dwh developers in solutions needed to efficiently complete the tasks.
• Worked with Confidential business users and customers to implement global business processes

Confidential, Tampa, Florida

Senior Developer

Responsibilities:

• Experienced in developing generic graphs and creating detail data flows with source and target mappings and convert data requirements into low level design templates.
• Developed generic graphs to serve the instant requests from the business.
• Worked in parallelized Ab initio environment to process 1+Tera bytes of data daily.
• Developed graphs using various Ab Initio components such as Join, Rollup, Lookup, Partition by Key, Round Robin, Gather, Merge, Dedup sorted, Scan and Validate
• Worked on all the Ab Initio components and well versed with various Ab Initio Transform, Partition, Departition, Dataset and Database components, application tuning, and debugging strategies.
• Used Toad to verify the counts and results of the graphs.
• Involved in System and Integration testing of the project.
• Wrote several Shell scripts, to remove old files and move raw logs to the archives.
• Tuned Ab Initio graphs for better performance.
• Processed and Transformed delta feeds loaded from the external systems on daily basis.
• Developed dynamic graphs to load data from data sources into tables and to parse records.
• Responsible to handle incident resolution and production system deployments while ensuring SLAs are met

Confidential

Senior Developer

Responsibilities:

• Developed dynamic graphs to load data from data sources into tables and to parse records.
• Worked with the project team in optimizing and tuning of SQL statements, used phases/checkpoints to avoid deadlocks to improve the efficiency.
• Parameterized plans and graphs to process data as per the business inputs & customized the existing graphs as per the updated design documents
• Gathered the knowledge of existing operational sources for future enhancements and performed optimization of graphs.
• Extensively involved in Ab Initio graph design, development and performance tuning.
• Performed root cause analysis for user requests.
• Parameterized plans and graphs to process data as per the business inputs & customized the existing graphs as per the updated design documents.
• Performed QA activities on data warehouse structure and prepared unit test cases and system integration test plans.
• Responsible to handle end to end release activities, UAT support and participated in change management procedures by checking in the changed code into Ab Initio EME.
• Developed a utility to check the existences of trigger files in the file landing zone & streamlined the process to consolidate data received from different external systems into the repository.
• Developed Ab Initio graphs to build business rules to extract data from oracle, mainframe, and flat file to validate, transform and load data to oracle database or flat file.
• Verified and validated the historical data loaded into the application through operational jobs and managed incidents.
• Prepare RTM (requirements traceability matrix) document and performed regression testing.
• Analyzed structured, unstructured data and created reports.

Confidential, Tampa, Florida

Application Eng

Responsibilities:

• Analyze the requirements and come up with the design document representing the same.
• Development of new Ab Initio graphs.
• Creating plans to define the workflow.
• Writing shell scripts.
• Developing wrapper scripts to run Ab Initio graphs
• Played vital role in identifying the defects and provided concrete solutions.
• Preparing and updating checklists, review logs, defect logs and unit test cases.
• Involved in unit testing and UAT.
• Review and analyze the graphs to improve performance.
• Preparing JIL files for job scheduling in Autosys.

Confidential, Tampa, Florida

Ab Initio Developer

Responsibilities:

• Developed number of Ab-Initio Graphs based on business requirements using various Ab-Initio Components such as Partition components, meta-files, reformat, roll-up, join, join with db, sort, dedup sort, and scan, normalize, gather, replicate, Broadcast, input/output/update table components etc.
• Involved in the preparation of ETL Ab-Initio standards documentation, naming conventions and creating technical design documents.
• Developed Ab-Initio graphs for Data validation using validate components.
• Responsible for cleansing the data from source systems reporting the data quality levels on system-by-system basis using Ab-Initio.
• Created various Ab-Initio graphs to run parallel by choosing proper partitioning methods for performance enhancements, introducing multifiles and improving the performance of Ab-Initio graphs by using Various Ab-Initio performance techniques.
• Responsible for creating summary tables using Roll-up & scan components.
• Modified and developed Unix Shell scripts to run Ab-Initio jobs.