OBJECTIVE:

Utilize my technical, consulting and leadership skills to obtain a challenging and growth oriented Full - time position and contribute to the organization’s success.

SUMMARY:

• About 11 years of professional IT experience in Confidential domain.
• About 5 years of Exclusive Experience in Ab Initio (GDE, Co>operating system).
• Expertise in ETL tools using Ab Initio (GDE, Co>operating system) and SQL Loader for data migration to Enterprise Data Warehouse.
• 2 years on Experience in Building and Implementing HL7 Interfaces between Various Hospitals and Major Laboratories in the US.
• Experience in preparing code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications, etc.
• Worked with ODS (Operational Data Source), Data validation and cleansing process using Ab Initio.
• Experience in Ab Initio EME/Sandbox to implement version control and impact analysis to manage various project across the organization.
• Ability to demonstrate command and use of industry accepted Ab Initio best practices.
• Strong development skills including the ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, production, support and documentation of the complete project.
• Worked extensively in the GDE (Graphical Development Environment) configuring, connecting, and testing the components to produce executable flow graphs on UNIX environment, Proficient with various Ab Initio Data Cleansing, Parallelism, and Transformation and Multi File System techniques.
• Thorough knowledge of DML (Data Manipulation Language), Unix Shell scripting
• Developed various UNIX shell wrappers to run Ab Initio and Data base jobs. Practical experience with working on multiple environments like production, development, testing.
• Used Conduct>IT and Plans for job scheduling wherein created several plans using resources.
• Very Good Programming skills using UNIX/Shell Scripts and PL/SQL for Automation of ETL process.
• Strong skills in defining and implementing solutions, tools, processes and procedures to provide enterprise data integration and ETL services that meet business requirements
• Extensive knowledge in Dimensional Data Modeling, Star schema, Snow-Flake schema, OLAP, OLTP and thorough understanding of Data-Warehousing concepts
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and Possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent Knowledge of Data Warehousing Concepts.

TECHNICAL SKILLS:

ETL Tools: Ab Initio Co>Operating System 3.0, GDE 3.0

Operating Systems: Windows XP/2000/NT, Linux, UNIX

Languages: C, VB 6.0, XML, SQL, PL/SQL

RDBMS: Oracle11g, DB2, Teradata V2R6.1, MS Access

Scripting: UNIX Korn shell.

EDI Specialist: HL7 Interfaces, Orders and results Interfaces and Results only Interfaces.

Practice Management systems: EMR and EHR

PROFESSIONAL EXPERIENCE:

Confidential, Green bay, WI

SR Ab initio Developer

Responsibilities:

• Serving as a Medical Claim Data SME.
• Analyzing the raw data and providing solutions to the business team, prepare the load plan and execute the load plan.
• Responsible for developing graphs using Ab initio.
• Understanding of the working of adjudication of claims processing systems pertaining to various health care vendors (payers) with no or limited documents available for the same and create Business rules and transformations in order to process the adjustments and claims processing.
• Documentation of the Issues encountered and co-ordinate with the Business rules and get the responses and issues resolved.
• Help and coordinate with the off shore developers and provide feasible solutions.
• Share project updated and Client implementation status with the On-shore Managers from the client’s side.
• Other responsibilities included overseeing the off shore operations, Training the New hires on Confidential and Claims adjudication.
• Worked in the Data Management Team on Data Extraction, Fictionalization, Subset, Data Cleansing, and Data Validation
• Involved in all the stages of SDLC during the projects. Analyzed, designed and tested the new system for performance, efficiency and maintainability using ETL tool AB INITIO
• Responsible for requirement gathering and development of Expiration Date Fictionalization project.
• Document ways to automate manual processes.
• Maintaining sandbox by storing all the work in a sequential order.
• Developed UNIX shell scripts for the purpose of parsing and processing data files.
• Quick reports generated for the users and data analysis on Test Beds on numerous occasions.
• Co-ordinate with development for future changes in the file or table structures to accommodate future testing requirements.
• Managed a combination of project, technical and managerial skills with proven abilities in solving complex problems, while exceeding performance expectations. Also cooperated and communicated among architects and business groups to achieve common business goals.

Environment: AbinitioGDE 1.15.9/3.1.2 , Co>Operating System 2.15/3.0,UNIX, Oracle 11.2

Confidential, WI

Sr Abinitio Developer

Responsibilities:

• Converting the Existing code and Fine tuning the Plans.
• Worked on creating the comparison reports between the old and new platform.
• As an Onshore SME, over looked at the offshore operations and plan the overall project delivery.
• Involved in the Unit Testing and QA review of the test data and debugging any issues.
• Specific duty includes Team Management, Resolution of Team’s issues, understanding requirements, client Interaction on various forums to discuss the status of the project with the Client, query clarification etc.
• Involved in different stages of developing the code which includes developing, perform code walk-through, unit testing and supported regression, Assembly and system testing and migration.
• Created UNIX shell scripts for FTP, merge and send success/failure mails and to automate stop/start of information servers.
• Extensively used Ab Initio built in string, math, and date functions.

Environment: Ab Initio, GDE 3.1.2, Plans, Oracle 11g, UNIX.

Confidential, New Jersey

Sr Interface Implementation Analyst

Responsibilities:

• Responsible for End to End Interface Implementation.
• Gather requirements and Conduct the Kick off call with all the stake holders.
• Create Project plan and share the Project timelines and Major Milestones with the Vendor and Hospital contact person.
• Build the HL7 Interface between the Hospital and the vendor, worked on both Orders and Results and ROI Implementations.
• Create Test design Test plan, Test all test cases and Work with the Vendor on the Testing the Interface and get a sign off on the Test plan.
• Post Completion of Testing, turn the Interface Live, based on the agreed go-live date.
• Provide Post Live Support and monitor the Interface during the Post live support phase.
• Use to Train new hires on Confidential Domain and also conduct trainings on Interface Implementations.

Environment: Legacy Mysis interface console, Allscripts Interface Engine (AIE), AIX UNIX, Oracle 8i/9i, Windows XP/NT/2000.

Confidential

Associate Analyst

Responsibilities:

• Extensively used Ab-Initio ETL tool in designing & implementing Extract Transformation & Load processes. Different Ab Initio components were used effectively to develop and maintain the database.
• Understood the business requirements with extensive interaction with Business analysts and reporting teams, and assisted in developing the low level design documents.
• Maintained locks on objects while working in the sandbox to maintain the privacy.
• Used inquiry and error functions like is valid, is error, is defined and string functions like string substring, string concat and other string * functions in developing Ab Initio graphs to perform data validation and data cleansing.
• Implemented a 4- way multifile system in the test environment that is composed of individual files on different nodes that are partitioned and stored in distributed directories in multifile system.
• Partition Components (Partition by Key, by Expression, by round Robin) were used to Partition the large amount of data file into multiple data files.
• Extensively used File management commands like m ls, m wc, m dump, m copy, m mkfs etc.
• Responsible for 24 X 7 production support of Ab Initio Process.
• Debugged the failures from the log files and re ran the jobs, by analyzing the checkpoints with in graphs
• Monitored Daily loads, Submissions of extracts and been the point of contact for customers.
• Involved in Comprehensive end-to-end testing.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques like using lookup Tables, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.

Environment: Ab Initio GDE 1.10, Co-op 2.10, UNIX, Oracle 8i, DB2, UNIX, Windows 2000.

Confidential

Associate analysis

Responsibilities:

• Monitor the Daily jobs that ran.
• Troubleshoot if any Issues by reviewing the error logs.
• Written UNIX Shell scripts for processing of data and handling large volume of data.
• Document and Create Internal documents for trouble shooting the jobs.

Environment: Oracle 8i, SQL, SQL*Loader, Shell scripting, and UNIX.