SUMMARY:

• Over 7+ years of experience in the IT industry as a Ab - Initio Developer & Lead for Data Warehouse DB2 and Unix applications.
• Excellent understanding of the System Development Life Cycle (SDLC). Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Specialized in ETL methodology for supporting data analysis in a corporate-wide-ETL solution using Ab Initio.
• Experience in writing scripts using UNIX shell script.
• Mentoring team to follow the design and Implementation standards with best practice.
• Experience in interaction with the Business Analysts, identifying the needs, requirements of the system and involved in requirement study of the system.
• Experience to create vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem-solving skills.
• Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem-solving skills.
• Create new methods to clients to improve the process and reduce the costs
• Generate weekly change reports to classify the infrastructure and development changes.
• Monitor database maintenance activities such as backup, reorg, runstats.
• Proactively monitor performance, diagnose problems and tune queries and database.
• Scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
• Using Export/Import utilities for data export/import between different databases.
• Worked on enhancements of systems and change of code for the changing requirements from the client side
• Added value to the project by publishing different plans so that our process failures do not affect the Business at any time.
• Resource management and utilization.
• Build value add service for end users.

TECHNICAL SKILLS:

ETL Tools: Ab- Initio (GDE Co>Operating system 3.2.2.0)

RDBMS: IBM DB2

DB Tool: TOAD

Big Data: Hadoop FS. Read and Write hdfs using abinitio

Scheduling Tool: Control - M

Languages: SQL, XML, Korn Shell Scripting and PL / SQL.

Platforms: Linux, UNIX, Windows.

Incident/Problem Tools: Service Now, Manage Now.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

AbInitio - Senior Consultant

Responsibilities:

• Designed, developed and unit tested Ab Initio graphs for the Enterprise Data warehouse projects.
• Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Worked with different data architects and DBA’s to develop the reusable Ab initio graphs.
• Extracted data using abinitio graphs from various sources like databases, delimited flat files.
• Updated and remediate existing Business Intelligence scripts and payment applications to reflect changing business data requirements.
• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
• Loading data from various data sources and legacy systems into different data warehouse using Abinitio graphs.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.

Confidential

AbInitio - Senior Analyst Programmer

Responsibilities:

• Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users
• Extensively worked with the Ab Initio Enterprise Meta Environment (EME) to obtain the initial setup variables and maintaining version control during the development effort.
• Designed, developed and unit tested Ab Initio graphs for the Global Data files projects.
• Extracted data from various sources like databases, delimited flat files and XMLs.
• Designed and developed parameterized generic graphs.
• Improved performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups in memory joins and rollups to speed up various Ab Initio graphs.
• Created sandbox utility using shell scripts for individual development and testing environment.
• Developed wrapper scripts to periodically notify users in case of any failures with debugging information.
• Developed UNIX Korn Shell wrappers to initialize variables, run graphs and perform error handling.
• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Pset, XFR, deployed scripts, DBC files for connectivity, create Package and exports.

Confidential

Analyst Programmer

Responsibilities:

• Deliver technical solutions to problems identified and architectural recommendations along with process conference for incident, problem, change management and compliance.
• Provides proactive monitoring/oversight of key critical applications to mitigate potential incidents before they impact the customer
• Use debugging/analytical tools to quickly determine root cause and performance bottlenecks with system/application
• Automating, optimizing, and executing process improvements on existing processes. Assists in the development and deployment of preventative maintenance procedures
• Interacts with development team to ensure quality standards are adhered to during development and implementation.
• Interacts with the product engineering teams via Retrospectives/Post-Implementation Reviews to ensure quality standards are adhered to during development and implementation.
• Provide first response to reported production incidents followed by resolution or escalation as necessary and status reporting.
• Monitor and manage change quality, and identify proactive/preventative opportunities with a strong focus on high availability and system resiliency.
• Ensure root cause analysis is done and that proactive/preventative measures are taken to avoid a reoccurrence
• Monitor the resolution of defects by development teams within the warranty period
• Regularly communicate requirements for preventative solutions and resolutions to the Service Delivery Senior Performance Analyst and/or Service Delivery Manager/Director.
• Ensure the deliverables are meeting the quality requirements and deadlines.