SUMMARY

• 9+Years of experience in software development and maintenance projects.
• 5+ years of experience in Ab Initio - GDE (Co-op 2.15, 3.15) and 4 years working knowledge in Confidential Lotus notes, DB2, Cognos TM1, Hyperion technologies.
• Currently working in Phoenix, AZ as a Lead Developer.
• Having strong domain knowledge on Banking &Financial and Healthcare services.
• Working experience in various stages of software development, SDLC both Agile and Waterfall process. Currently working on Kanban Model with SDLC Agile.
• Strong experience with Microsoft Visio to represent Flow-Diagrams, Data Model, Process Architecture, Solution Architecture (SAD), Job dependencies and hierarchies.
• Hands on Experience on Data Mapping as per the business rules and transformation discussed and aligned with the upstream/source system and the product owner.
• Ability to identify the Technical and Business implication of the Business Need Request initiated by client.
• Ability to work in a geographically distributed virtual team environment and to build relationships with internal and external organizations.
• 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.
• Experience working on Ab initio ETL tool including designing, developing, implementing Ab Initio graphs in complex, Data Warehousing projects.
• Have worked in finding a solution to read a complex xlsm sheet data(15 sheets in a single xlsm file with macros) through Abintio(2.15), Required for successful business processing of Global Payment Reporting.
• Achieved Eminence Excellenceaward.
• Worked in end to end systems in AMEX and have extended knowledge from Financial Capturing system, Accounts Receivable system till the Data Loads.
• Experience in understanding of 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.
• Had experience in end to end process of lotus notes applications.
• Had good experience working with worldwide clients. (US, AP, Japan, Europe, China and LA)
• Experience in cost management, time management, risk management, and integration management.
• Experience in Data Analysis and reporting tools.
• Knowledge in Hadoop Technology.
• Active participation in helping team members and all project and office related activities.
• Contributed beyond the projects towards organization/ Account initiatives.
• Extensive Hands-On experience to work in the USA & Canada IT Industry.

TECHNICAL SKILLS

ETL: Ab Initio GDE(1.15/3.03) and Co-op (2.13,2.15 and 3.15) & Control M

Operating Systems: Windows, UNIX

Language: Shell Scripting, Java, Confidential Lotus Notes, Java script, XML

Tools: MS Visio, Cognos, Hyperion

Database: DB2, SQL, Teradata, Domino

Domain: Banking & Finance, Health Care, Sales & Distribution

Other Utilities: TSO/ISPF, Confidential Utilities

PROFESSIONAL EXPERIENCE

Confidential, DE

Lead Ab Initio Developer

Responsibilities:

• Working as a lead Ab Initio developer in understanding the requirements of the End Users/Business Analysts and developing applications for ETL Process using Ab Initio.
• 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
• Requirements gathering and Deliver Analysis & Design of the project with Quality deliverables as per SDLC Agile Process.
• Creation of product backlog and solution architecture document.
• Redesigned existing graphs based on client requirements.
• Leading the technical team coordinating efforts towards analysis, design, preparation of functional specification documents and detail design documents.
• Ensuring adherence to Quality Standards on the deliveries made.
• Code reviews, test results reviews and handling Installation of Projects for new implementations and enhancements for our customer.
• Deliver new and high quality solutions to clients in response to varying business requirements.
• Interaction with E2E Analysts on the Implementation requirements and Supporting system testing and user-acceptance testing.
• Self and independent testing of enhancements made in the system with respect to the new business requirements, Bug Fixing.
• Estimation & Tracking of the Maintenance requests.
• 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.
• Supporting the project in production post Implementation until it gets handed over to production team.
• Analyze and maintain operational cost benefit for completion of projects.
• Maintain technical system support documentation and provide technical leadership and mentoring to the team less familiar with the system.

Confidential, Buffalo, NY

Ab Initio Developer

Responsibilities:

• Developed graphs separating the Extraction, Transformation and Load Process to improve the efficiency of the system
• Involved in designing Load graphs using Ab Initio and tuned the Performance of the queries to make the load process run faster.
• Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files
• Translated business-reporting requirements into data warehouse architectural designs and analyzed source and target data models and made necessary changes
• Created High level Design, Detail Design, Unit Test Cases documents following CapitalOne standards
• Worked on various projects related to capture web Analytics data, Search Engine marketing data
• Worked with various vendor's Adobe Site Catalyst, 360i, Silver Tail regarding the file transmission and naming pattern's.
• Involved in building many utilities to improve the performance like Load Status utility, job monitoring utility and helped other teams in using these utilities over many platforms in CapitalOne.
• Build a generic loading graph for Mload and api which improves the performance and this generic graph was added to enterprise patterns
• Worked with Control M (Job Scheduling) team to schedule the jobs for many applications. And also defined the job dependencies. Performed daily maintenance and administration of DW production runs until the schedule is transitioned to operational team
• Analyzed and reviewed the Detailed Design schema with the Designers so as to have proper understanding of the requirements
• Responsible for interacting with the business analyst and client representatives to develop technical specifications that meet documented business requirements
• Responsible for providing requirements to improve re-usability of components and development of cutting edge coding standards and provide feedback related to product integration, internally developed infrastructure components, and application templates based on project experience

Confidential, MORRISVILLE, NC

Ab Initio Developer

Responsibilities:

• Understand the business process and gather requirements from business users along.
• Implemented Star Schema models for the above data warehouses by creating facts and dimensions.
• Carried the detailed profiling of operational data using Ab Initio Data Profiler/SQL Tool to get better understanding of the data that can be used for analytical purpose for Business/User groups.
• Created, Managed and run large-scale data processing system.
• Used ACE to create the generic graphs.
• Participated Agile Iterative sessions to develop Extended Logical Models and Physical Models.
• Created mapping document and ETL design document.
• Developed Ab-Initio graphs using Ab-Initio Parallelism techniques, Data Parallelism and MFS Techniques with the Conditional Components and Conditional DML.
• Identified the required dependencies between ETL processes and triggers to schedule the Jobs to populate Data Marts on scheduled basis
• 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.
• Involved in after implementation support, user training and data models walkthroughs with business/user groups.
• Automated the entire Data Mart process using UNIX Shell scripts and scheduled the process using TWS, Job Track after dependency analysis.
• Extensively used the Teradata utilities like Fast load, Multiload, TPump, DDL Commands and DML Commands (SQL).
• Supported Testing Team with data verification, loading the Data in Test Environment, provided sqls for testing the Test cases.

Confidential

Application Developer

Responsibilities:

• Solo developer of this tool form Design phase to deployment phase.
• Requirements gathering form client for the tool development.
• Involved in Estimation and Project plan preparation along with Project Manager.
• Performed Local DB2 setup to test LEI query process.
• Performed LEI Activities and Connections setup process.
• Agent Creation and coded with lotus script for automation of process.
• Coding using Notes Formula Language, Lotus Script in various places
• Performed Testing and validation process.
• Provided complete setup Instructions to Administrator.
• Application Maintenance for six months.
• Maintained good coordination between Project Manager, Administrator, Database team and client.
• Received very good appreciation from the client.

Confidential

Application Developer

Responsibilities:

• Analyzed business requirements, designed and coded the applications.
• Followed agile process to implement requirements and defects.
• Followed RTC which gives clear idea about whole work of team at a Glance.
• Followed different requirements and defect tracking tools like CQ Web, Governance Board Tool,
• Involved in creation and design the application with forms, subforms, views, pages, X pages and various design elements.
• Participation of Business calls with client to understand new setup of Nextgen DISC.
• Major role played in new nextgen setup process of AP geographic DISC instance.
• Major role played in migrating data from World Wide Instances to Nextgen DISC instances.
• Worked on Importing and Exporting data from the MS Excel and Msword to the Lotus notes client.
• Performed lotus script, java script agent creation and modifications.
• Maintain interaction with worldwide users and business design consultants.
• Performed financial data validations which are the key point to users.
• Performed code reviews and version control tracking.
• Involved in testing and validation and support activities.
• Lead and support the team for successful deliveries.
• Maintain clear documentation of load files of each and every release in PCB (project control book)