SUMMARY:

• Over 7 years of IT experience in the Design, Analysis, Development, Modeling, Implementation and testing of various applications, Decision Support Systems & Data Warehousing applications.
• Over 6.5 years of experience in Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.
• Apart from the daily deliverables, have effectively worked in Metrics which shows up the performance of the complete account under BNFS vertical.
• Served as a Lead for PMT (Performance Measurement Team) and PAT (Product Assurance Team)
• Knowledge of full life cycle development for building a data ware house.
• Worked on Traditional SDLC and Agile(SCRUM) Methodology.
• Ability to work in a geographically distributed virtual team environment and to build relationships with internal and external organizations.
• Expertise in requirement gathering, analysis of customer data for different secondary switching area (SSA), mapping of functional requirements of the downstream applications in Infinys Rating - Billing System.
• Excellent analytical, problem solving, logic defining and technical debugging skills.
• Good Interpersonal, written and verbal communication skills.
• Lead medium to large sized teams both at onsite and at offshore and has good record of providing quality and timely deliverables.
• Knowledge in EME check - in, check - outs and sandbox creation
• Worked on TRMC tool for maintaining EME repository, code promotion, creating tags and save files
• Worked on Continuous flows, Conduct>It and XML processing.
• Received several commendations for consistently surpassing Service Level Agreement targets, including delivery, application availability, and support call turnaround time
• Migrated jobs from development to QA to Production environments.
• Good Experience in Scheduler Tools like OP>CONSOLE,CTRL+M,Tivoli Schedulers.
• Ensure quality customer deliverables while leading and driving advanced / complex projects to successful completion
• Sound Skills in structured query language (Oracle SQL).Experience with all phases of SDLC including design, development review and maintenance
• Extensive experience in sizing cost for development projects, project design, project development, testing, implementation, change management, status reporting and all the other Delivery processes involved in Dev and maintenance projects
• Developed a Mainframe tool for Confidential corporate billing to generate the client unbilled and billed reports in CSV and TXT format under Account Receivable System.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Ab Initio.
• Experience in Unix Shell Scripts including Korn Shell Scripts.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows

RDBMS: Oracle 9i,Teradata

ETLTools: Ab Initio Co>OS 2.13, 2.14, 2.15, 3.0, 3.15, 3.2 and GDE 1.13, 1.14, 1.15, 3.x, Informatics

Other Tools: SQL*Loader, MS VISIO.

WebTechnologies: HTML,XML, CSS, JavaScript, AngularJS

Languages: C, C#, C++, COBOL, SQL, PL/SQL, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential,NJ

AbInitio Consultant

Responsibilities:

• Closely interacted with the Business Analyst team for understanding the Business
• Proficient with transactional database systems like SQL Server and Oracle.
• Developed reusable graphs for the purpose of data extraction and data manipulation for various processes.
• Involved in project Application Development and Maintenance (ADM Services), Requirement Gathering and have working knowledge of SDLC process
• Participated in daily Scrum meetings(Agile methodology) and escalated issues blocking progress.
• Implemented triggering of QlikView Task via Autosys using EDX in order to invoke Dashboard refresh via Autosys Tool independent of Server.
• Scheduling Autosys jobs and running the job flows.
• Written the Unix scripts for receiving the all country wise files and run through OC
• Understand client business strategy and develop technical roadmap to support that business strategy
• Worked closely with Unix System Administrators during new database creations for setting up filesystem layout, CPU, Memory and paging space configuration.
• Managing Hadoop Cluster architecture and monitoring the cluster.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Working with Oracle Support / Metalink doing OWC for support related issues
• Work closely with the Project Delivery, Business, Development, Quality Assurance and other technical stakeholder groups as a support representative for the upcoming projects contributing in various stages of project life cycle
• Provide support to the System Testing team and bug fixing of the application.
• Support during UAT and in corporation of any changes required in the developed application.
• Developed MsSql accounting applications that extracted data from SQL tables.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Provided pre and post production as well as QA support. Prepared Scripts for UAT.
• Takeover the owner ship of the RNM application.
• Created the connectivity between Mainframe to Unix to transfer the daily incremental files from Mainframe to Unix

Environment: AbInitio 3.2, Oracle, Agile, UNIX, ACE, Operational Console, Informatica, UAT, OC, RUM, Autosys 11.3

Confidential,PA

AbInitio Consultant

• Experience of all phases of Software development life cycle SDLC including requirement analysis, design, development, testing, troubleshooting, debugging, implementation, UAT (User Acceptance Testing) and post implementation support.
• Used EME Technical Repository Management console to Manage the objects in EME
• Maintained metadata in EME and designed parameter driven graphs. Tuned graphs for better performance.
• Constraints, Indexes, Views and PL/SQL, T-SQL (Stored Procedures, Triggers, Functions and Cursors)
• Assisted with implementation/upgrade of AutoSys and JAWS, troubleshoot errors, and documentation/procedures.
• Managed Backup and disaster recovery for Hadoop data with log file.
• Works successfully with agile-based development methodologies and teams.
• Designing and developing complex Ab-initio code for new data model
• Created generics graphs for common functionalities across graphs such as cleansing files, creating surrogate key, etc
• Conducted various training sessions with users to make them familiar with new data warehouse
• Written Shell Scripts for validating FTP Flat files. Developed Unix Shell scripts to automate the data load processes to target data warehouse.
• Developed the UI panels using JSF, XHTML, Appian, Oracle, AngularJSetc.
• Build shell scripts to clean up the files and other functions.
• Wrote procedures, triggers etc to enhance the performance by using PL/SQL.
• Worked extensively in UNIX environment by accessing the files, changing permissions to them and building scripts.
• Worked on resolving the data lineage issues by modifying the existing graphs and addressing the dependency analysis errors
• Maintained metadata in EME and designed parameter driven graphs.Tuned graphs for better performance

Environment: AbInitio 3.1 Teradata, UNIX, Control M, EME, PL/SQL, Oracle, Autosys, JAWS, Agile

Confidential,Washington,MD

AbInitio Developer

• Created Ab Initio graphs, Continuous flows, Conduct IT and utilizing Rollup, Join, Sort, Replicate, Partition components to speed up the ETL process.
• Preparation of the Business Requirements Document, Functional Specifications Document, UI Specifications, Use cases.
• Analyze and resolve issues to ensure high quality deliverables at each stage of SDLC within the guidelines, policies and norms.
• Written AutosysJil scripts for scheduling the workflows.
• Work closely with the Project Delivery, Business, Development, Quality Assurance and other technical stakeholder groups as a support representative for the upcoming projects contributing in various stages of project life cycle.
• Estimation/Sizing of effort/cost required for the project during pre and post Analysis and Planning for all the phases of the project and tacking the status of the project at each phase
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Participate in Submissions POA Architecture Road Maps and Long Range Plans & strategies in the areas of infrastructure Uplift, Demand Management, Automation etc
• Evaluate system utilization related to responsiveness, processing capacity and reliability.
• Design the Continuous Graphs interfacing external systems through MQ Queues & XML data.
• Gather business requirements and converted in to entities and attributes and participated
• Loaded operational data into Staging Tables, warehouse tables using Abinitio GDE and responsible for automating the ETL process through scheduling.
• Organizing events & conducting Presentations, Trainings, Effective Meetings, Project Status Reporting to Senior Management.

Environment: AbInitio 3.0, Oracle, Teradata, UNIX, XML, EME, MQ Queues, GDE, ETL, POA,Autosys

Confidential,Worth, TX

AbInitio -Developer

• Collecting and understanding requirements from Onsite.
• Analyzing requirements and understanding current system
• Worked extensively in UNIX environment by accessing the files, changing permissions to them and building scripts.
• Involved in writing the Unit Test Cases for the applications.
• Created Various Best Practices Documents for Development and Support Activities.
• Developed complex graphs having more than 40 components with emphasis on optimizing performance.
• Developed custom FTP components to automate the file transfer process to different servers.
• Gather and clarify business requirements by interacting with the UK Business Analyst and Design team
• Provide optimized solutions to achieve fast processing of Data using latest concepts of meta programming and customizing framework
• To ensure that all the defects and test results to be updated in Quality Centre and follow up till it gets fixed.
• Involved in effective communication between the team and customer to ensure all the deliverables met on time without revert backs.

Environment: AbInitio 2.15, TeraData, UNIX, FTP, Oracle, EME

Confidential,Pasadena,CA

AbInitio -Developer

• Understanding the Business requirements, co-ordination with designers and Business Analysts directly.
• Developed Graphs according to Business Requirements
• Development of processes to enable file validation/control, transformations, and loading of daily files received from Aviva/NU, Junction, and Confidential to the Barclays Customer System (BCS), and Compliance Audit Archive Store (CAAS) using the existing Ab-Initio ETL framework.
• Accommodated Error Handling of rejected data by making provision for capturing and analyzing the message and data separately.
• Loaded operational data into Staging Tables, warehouse tables using Abinitio GDE and responsible for automating the ETL process through scheduling.
• Created wrapper scripts to execute the graphs. Incorporated features for restart ability and rollback in case of a failure.
• Conducting weekly meetings between development team for status update and highlight issues if any
• Conducting Knowledge sharing sessions amongst team members
• Carried the performance tuning on the Ab Initio graphs to reduce the process time.
• Created several SQL queries and created several reports using the above data mart for UAT and user reports.

Environment: AbInitio 2.15, TeraData, UNIX, GDE, CAAS, BCS, Oracle, EME

Confidential,New York,NY

AbInitio Developer

• Created AbInitio graphs based on business requirements using various Ab Initio components such as reformat, rollup, join, scan, normalize, generate records, validate records etc.
• Worked on improving the performance of AbInitio graphs by using Various AbInitio performance techniques such as using lookups instead of Joins, parallelism techniques (MFS) etc.
• Monitored AbInitio jobs within and also in deployment environments using AbInitio commands and Schedulers.
• Involved in Design and Development reviews and provided Tuning Techniques on AbInitio Graphs
• Involved in creating the documents like Operation Instructions Document, Load Approach Process for Abinitio Application Support.
• Develop or Aid business in building metadata for mappings from source to targets.
• Build process to integrate data from various Legacy applications.

Environment: AbInitio 2.14, TeraData, UNIX, MFS,EME

Confidential,CT

AbInitio Developer

• Played an active role as an Application Developer to develop modules.
• Maintenance and Enhancement of the existing system.
• Analyze/Research and resolve application issues raised through a problem management Ticket in time and fix the issue based on the severity of the issue and the user’s impacted.
• Involved in Capacity planning, resource allocation and dependency analysis.
• Co-ordinate/Assign tasks to the offshore team for on time delivery of the requirements.
• Designed, developed and unit tested Abinitio graphs for Extraction, Transformation and Loading of data from source to target.
• Analyzing the requirement given by client.
• Preparing the various Business deliverables at different phases of SDLC.
• Performed LEI Activities and Connections setup process.
• Agent Creation and coded with lotus script for automation of process.

Environment: AbInitio 2.14, TeraData, UNIX, SDLC, Oracle