PROFESSIONAL SUMMARY:

• Around 8 years of experience in the software industry that involves analysis, design, build, testing, support and maintenance of
• Information Systems for clients in Banking and Capital Market & Airline industry primarily in AbInitio, UNIX (korn shell and bash shell), Oracle. Extensive experience in working with Abinitio as a ETL tool for implementing transformations and conditions.
• Worked on various Abinitio components like Reformat, Sort, Rollup, Dedup Sort, Normalize, Lookups, Input Table, Output Table, Input File, Output File, Partition Components, Subscribe, Publish, Batch Subscribe etc.,
• Extensive knowledge in EME checkins, checkouts, command line interface, air commands.
• Reading the data from the Mainframe file i.e., JCL library file and processing it through the Open systems/Abinitio or putty.
• Reformatting every mainframe file to convert the data from ebcdic data to ascii data.
• Processed the Input Layouts and handling the large volumes of data.
• Analyzing the requirements from the Clients Perspective through the Order specification form
• Created the Structured, Unstructured, Hybrid graphs based on the requirements.
• Worked on Different jobs like Analysis, Extraction, prescreen, Prospects, Interim file Processing, Test file processing, Final file processing, Portfolio review, forms handling for the data
• Created lookup files for different reports having value ranges which varies from negative values, positive values for the sub codes
• Zipping and unzipping the files from Abinitio processing
• Well versed with Abinitio parallelism techniques and worked on Ab Initio Graphs using Data parallelism and Multifile System (MFS) techniques.
• Developed Abinitio graphs to fetch data from DB2, Sybase, Oracle, Teradata, Netezza, Excel, Flat Files, XML files and Mainframe.
• Hands on experience in development of Data Warehouses/Data Marts using Abinitio Co>OP, GDE, Component Library, Oracle and UNIX for mainly Banking/Financial/Credit Card industries.
• Expert of Automation, Innovation, Data Mining and Tuning in Abinitio and UNIX shell scripts.
• Experienced in interacting with EME Data store with several air commands.
• Experience on Abinitio ACE CDA (Common Data Acquisition) frame work.
• Knowledge about advance concepts of Abinitio like Metaprogramming, PDL and Continuous graphs.
• Designed and encouraged use of Reusable graphs in Abinitio to promote reusability, eliminate coding redundancy and ease maintenance of Version control.
• Responsible for Debugging and Troubleshooting Abinitio graphs.
• Developed various UNIX shell wrappers to run various Abinitio jobs.
• Experienced in managing critical issues under stringent timelines during Production support.
• Proven abilities in improving Application performance, capacity planning.
• Diagnosed production issues to ensure a timely recovery and minimal impact to our business users.
• Ability to provide effective, efficient and low - cost solution simultaneously on several projects.
• Conceptual innovative problem solver with excellent analytical, organizational and communication skills.
• Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn modern technologies and tools quickly.
• Expertise in developing applications using Microsoft technologies such as .NET Framework, Web applications using ASP.NET, ASP .NET MVC, Win Forms using Microsoft Visual C#.NET and VB.NET, Database access using ADO.NET and Entity Framework as ORM Mapping tool for Data Access layer and distributed applications using WCF, WPF, XML Web Services and Messaging system.
• Creating/consuming Web Services including WCF with XML, WSDL, UDDI and SOAP.
• An exclusive experience working with User Controls with VB.NET code-behind files, debugging and Quality Testing of the code.

TECHNICAL SKILLS:

ETL Tools: AbInitio GDE 1.1x, 3.0x, CO>OP 2.1x,3.0, Metada Hub, Data profiler, Informatica, Erwin 4.1/3.7, Microsoft Visio 2007.

Tools: Maestro, Auto Sys, Tivoli Work Load Scheduler

Operating Systems: Windows 95/98/NT/ME/00/XP, UNIX, MS-DOS, Sun Solaris 5.8, Linux 8x.

Languages: C, C ++, Shell Scripting, SQL

Databases: Oracle 11g, IBM DB2, Microsoft Access, Teradata 15.0

Big Data: Hadoop Cloudera Implementation basic proficiency

Scripting Languages: Java Script, VB script, jQuery, Angular JS, Angular 2, Type Script, Gulp JS, Node JS, React JS, Ext JS

Version Controls: Team Foundation Server (TFS), SVN, Visual Source Safe (VSS).

Web Technologies: ASP, XML, XAML, XSD, XSLT, Angular JS, JSON, HTML 5, CSS, Bootstrap, SCSS.

Web Services: IIS, IBM Web Sphere, REST, SOAP.

PROFESSIONAL EXPERIENCE:

Confidential, TORRANCE, CA

Senior ABINITIO DEVELOPER

Responsibilities:

• Designed and developed parameterized generic graphs
• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Psets, XFR, deployed scripts, DBC files for connectivity
• Performed unit testing, Integrated testing, involved in UAT, code review and performed code migration to different environments
• Involved in production migration activities as well which included tag creations, code migrations, job executions and monitoring
• Reading the data from the Mainframe file i.e., JCL library file and processing it through the Open systems/Abinitio or putty.
• Reformatting every mainframe file to convert the data from ebcdic data to ascii data.
• Processed the Input Layouts and handling the large volumes of data.
• Analyzing the requirements from the Clients Perspective through the Order specification form
• Created the Structured, Unstructured, Hybrid graphs based on the requirements.
• Worked on Different jobs like Analysis, Extraction, prescreen, Prospects, Interim file Processing, Test file processing, Final file processing, Portfolio review, forms handling for the data
• Created lookup files for different reports having value ranges which varies from negative values, positive values for the sub codes
• Zipping and unzipping the files from Abinitio processing.
• Created the Data Detailed View file process and transferring them through the FTP and SFTP process
• Created sample Records for analyzing and testing large volumes of data
• Maintenance of the graph at distinct phases to process all the requests and for the main process to complete
• Well experienced in using Partition (Partition by key, partition by round robin) and De-partition components (Concatenate, Gather, and Interleave, Merge) to achieve data parallelism
• Proficiency in using Oracle database and thorough knowledge in SQL programming
• Extracted data from various databases sources like Teradata, Oracle, Delimited flat files.
• Worked on a POC on how to create rules, rule cases using BRE (Business Rules Environment - Web version & ACE)
• Developed SQL scripts for data validations
• Participated in regular project status meetings & Defect triage meetings
• Involved in writing the file watcher scripts in UNIX
• Involved in Requirement analysis and breaking down the requirement and providing the estimates for the project
• Developed the code with latest Ab Initio features of Continuous flows, Data profiling, compressed lookups, XML utilities & components
• Worked on exception handling by gathering all the rejected records to flat files
• Implemented Lookups instead of joins, in-memory sorts to minimize the execution times while dealing with huge volumes of data
• Enhancement of existing graphs in each release by adding extra functionality or changing existing transform (xfr files) functions
• Worked along with the developer to set up the daily and monthly batch processing jobs.
• Performed code reviews and supervised junior developers
• Implemented Lookups, lookup local, In-Memory Joins and rollups to speed up various Ab-initio Graphs
• Profile & Analyze Source Data usage with DQE. (data coming from Mainframe Extracts, Oracle tables & UNIX flat files)

Environment: AbInitio GDE 3.1.6, AbInitio, Co>operating system 3.1.2, UNIX, Oracle 11.2.3, Putty, Windows 7, Beyond Compare, Microsoft Visio, Mainframes

Confidential, MOORESVILLE, KY

ABINITIO DEVELOPER

Responsibilities:

• Worked with Business users to get the detailed requirements for the Design of Ab Initio process.
• Create and Support new/existing job runs through Operational Console scheduler.
• Improve the performance of Ab Initio graphs by using various performance techniques.
• Worked and held responsible for applications like STAMP and HRCS.
• Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented an elevated level Conceptual Data Process Design for the projects.
• Responsible for checking the data lineage, data profiling and data management for STAMP application.
• Involved in Developing the Abinitio Graphs for the Coverage, Claims Compare applications.
• Involved in all the stages of SDLC during the project. Analyzed, designed and tested the new system.
• For performance, efficiency and maintainability using ETL tool ABINITIO.
• Extracted West Claim Related Files and translated into WHSEFUL format and Compare with East Claims related WHSEFUL format files.
• Designed and developed the graphs using the GDE, with components sort, reformat, replicate, assign key, join, merge, gather, and concatenate components.
• Various inbuilt functions like lookup, lookup match, lookup local, string filter out were effectively used in various transform functions.
• Created User defined functions for the project requirements.
• Involved in Data integration to combining data from several data sources.
• Handled frequent change requests to the existing feeds on a tier basis, Coverage rules by adding
• New columns to the feeds mapping, adding new fields and changing data type of the columns based on Claims Compare.
• Also used components like trash, run program and run SQL components to run UNIX and SQL commands in AbInitio. Handled the tasks of identifying system deficiencies and implementing effective solutions
• Handled the responsibilities of managing technical risks throughout the project.
• Drove impressive improvements across the business because of IT implementations.
• Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making on proposed IT implementation projects.
• Created High Level Technical Design and Detailed Design (DDL) documents (HLD) in the initial stages of a project.
• Developed graphs using Ab Initio components and utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
• Shared knowledge with the developer on EME repository check-ins and check-outs.
• Implemented Ab Initio Plans and continues flows for some applications.
• Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
• Worked on Batch jobs using UNIX shell scripting.
• Performed unit testing, Integrated testing, involved in UAT, code review and performed code migration to different environments.
• Migrated ETL code changes from development environment to System, Integration and Production environments using the RLM tool.

Environment: ABINITIO CO>OP 3.1.5.5 ABINITIO GDE 3.1.7.4, Oracle, Windows 7, Operational Console, RLM, Red Hat UNIX

Confidential, MORRISTOWN, NJ

ABINITIO DEVELOPER

Responsibilities:

• Optimize run times of graphs to mitigate the risk of missing Service Level Agreements as data volumes increase with time. Also devise strategies for optimizing server utilizations for shared services.
• Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
• Helped in setting up the batch jobs using Autosys and UNIX Shell scripting.
• Developed graphs using Ab Initio components and utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
• Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
• Helped the developer to check-in, check-out and tag updating based on the rules levied by the client.
• Performed unit testing, Integrated testing, involved in UAT, code review and performed code migration to different environments.
• Involved in source to target data field mapping discussions, Production support, Abinitio support.
• Developed various graphs which include Extracts, Packages, and Schedule for executing one of query based on period and loading it into the Funds database.
• Used different Abinitio components like Subscribe, Batch Subscribe, Publish, Multi publish, Continuous update table, Read XML, Write XML, partition by key and sort, dedup, rollup, scan, reformat, join and fuse in various graphs.
• Also used components like trash, run program and run SQL components to run UNIX and SQL commands in AbInitio. Implementing application level tactical solutions and enterprise-wide strategic solutions for Disaster recovery.
• Perform root cause analysis on all batch processes and resolve critical production issues and validate all data and devise integrity checks on databases and provide L3 support to all ETL applications.
• Provide support for System Integration Testing (SIT) and code and implement defect fixes
• Migrated ETL code changes from development environment to System, Integration and Production environments using the RLM tool

Environment: ABINITIO CO>OP 3.1.5.5 ABINITIO GDE 3.1.7.4, Oracle 10G/11G, Windows XP Pro, Operational Console, RLM, Red Hat UNIX

Confidential

SQL BI Developer

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.
• Created & executed several SSIS packages to perform ETL operations of the data from source server destinations server and OLTP to OLAP.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL server.
• Extensive use of DAX expressions in tabular models as per business requirements.
• Worked with Exception handling with @@error and with Try/catch.
• Worked on AGILE methodology in development of Database Objects in SQL Server 2008/2005.
• Experience in providing Logging, Debugging and Error handling by using Event Handlers, and Custom Logging, break point, data viewers, check points for SSIS Packages.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS.
• Created Multi-Dimensional Cubes using SSAS for the Data Warehouse.
• Created Production Deployment Scripts for SSAS Cube & Roles.
• Conducted weekly Crystal Reports training session for the reports team. Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the reports.
• Build, Published and Scheduled SSRS Reports for both Dev and Test Environment.
• Database backups and troubleshooting production databases and cube sync processing issues and SSAS issues.
• Performed system data analysis. Created, modified, documented, and enhanced data specifications included identifying and mapping data elements from source systems into staging areas, the data warehouse, data marts, and OLAP cubes.
• Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, Crystal Reports 11/12, Windows 2008 Advance Server, VB.NET, MS Excel, and MS Office, SQL Server Management Studio 2012. SQL Server 2008R2/2005 Enterprise Edition, Linux, .NET Framework 4.5, XML, SharePoint, TFS 2010, Tableau.

Confidential

SQL Developer

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005/2008.
• Created and executed several SSIS packages to perform ETL operations of the data from source server to destinations server and OLTP to OLAP.
• Experience in providing Logging, Debugging and Error handling by using Event Handlers, and Custom Logging, break point, data viewers, check points for SSIS Packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Transfer Data from Database to Data Warehouse using SSIS ETL packages such as look up, union-all, multicast Transformations.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the reports.
• Build, Published and Scheduled SSRS Reports for both Development and Test Environment.
• Developed and optimized complex data and reporting solutions using SSRS to deliver drill through, drilldown, linked and parameterized reports
• Involved in Enhancing existing reports look and feel using SSRS.
• Created Star Schema for OLAP cube generation and extensively worked dimension modelling for analysis service using SSAS

Environment: MS SQL Server 2008/2005, Reporting Services (SSRS), Integration Services (SSIS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio 2008, XML, MS Excel and MS Access, Crystal Reports 7/8, Windows 2008 Advance Servers Excel, and MS Office.