SUMMARY:

• Over 13+ years of experience in Information Technology including 9+ years of experience in Enterprise Data Warehousing and Business Intelligence environments.
• 10+ years of experience in Ab Initio on Enterprise Data Warehousing and Business Intelligence environments.
• Hands - on leading and managing experience in Data Modeling, Data Integration, Data Migration, Data Governance implementations on Enterprise Data Warehousing/Business Intelligence and Big Data Hadoop Distributed System.
• Able to plan and execute all phases of life cycle in Data warehousing, Data Integration and Data Migration.
• Extensive working experience on ETL tools Ab Initio 3.2, Conduct>It 3.2, Elementum 3.1, Talend and Informatica.
• Experience with Ab Initio GDE, Ab Initio SDE, BRE, Ab Initio Co>Operating System, Ab Initio EME (Check in and Check out), Ab Initio Metadata Hub, Performance Tuning, Reviewing the development using Ab Initio EME Standards and Review Checklist.
• Had the experiences in Data Profiler, BRE (Business Rules Environment), Ab Initio Configuration Environment (ACE), SFD, BMR and ICFF.
• Had the experiences in Big Data Architecture environments using Hadoop, HDFS, Cloudera, MapReduce, MongoDB, Talend, Netezza and Ab Initio through CATE Sessions.
• Experience in creating mapping, reusable transformations and mapplet using Designer, Power Center Client, Power Analyzer, Power Exchange and Power Center.
• Experience in SQL, PL/SQL, Performance tuning and optimization of Data unload/load.
• Experience in Relational Databases on ORACLE 10/11g, Teradata 7.2, Sybase ASE 1.5, MS SQL Server 2005 and IBM DB2 and, also experienced Teradata utilities: Fast Export, Fast Load, MultiLoad, Tpump, and BTEQ in Ab Initio.
• Extensive experience in UNIX Shell Scripting, AWK, SED, Perl Scripting and Autosys JIL Programming/Scheduling.
• Worked on Client/Server Technology using J2EE, Microsoft Technology Tools.
• Experience in BI Tools: Metreo Vision 3.3, Business Objects 6.5, MicroStrategy 10.0,Actuate Reports, MS OLAP, Visual Basic, ASP 3.0, MS SQL Server, MS Access and Job Scheduling Tools IBM Control-M and Autosys.
• Experience in Data Modeling Schemas (RDBMS, Multi-Dimensional Modeling (Star Schema, Snowflake), MOLAP, ROLAP and HOLAP) using Erwin Data Modeler r7.x.
• Experience in working with very large databases (up to 500 Terabytes) and very large data transactions.
• Experience in Database Administration on Database backup/recovery, migration and performance tuning.
• Functional experience includes Financial, Banking, Investments, Basel Regulatory, Investment Risk Management, Credit Risk Management, Compliance Regulatory, Telecommunications and Healthcare.

TECHNICAL SKILLS:

Language(s): C/C++, COBOL, JCL, J2EE, JMS, XML, XSDL, SQL, PL/SQL, SED, AWK, UNIX Shell/Perl Scripting

GUI: Visual Basic 6.0, ActiveX, and ADO 2.5

Data Warehousing - ETL Tools: Ab Initio 3.2, Ab Initio GDE 3.2, Ab Initio Co>Operating System 3.2, Elementum 3.1.3, Talend ETL, Informatica Power Center 7.2, Oracle Warehouse Builder, ODI, MS DTS.

OLAP Tools: MicroStrategy 10.0, Metreo Vision 3.3, Business Objects 5.1, MS OLAP, and Actuate Report

Database Modeling Tool: Erwin Data Modeler r7

Database(s): ORACLE 11g, Teradata 7.2, Sybase ASE 1.5, IBM DB2 UDBEEE, MS SQL Server 2000/2005, Netezza.

Web Technologies: Active Server Pages 3.0, VB Script, and JavaScript

Web/Application Server: Servlets, IIS 4.0, MTS, JRun Server

Operating System: MS DOS, MS Windows 9x/2000, Windows NT, SUN Solaris 5.8, HP-UX, IBM-AIX, and Red hat Enterprise Linux 3.0.

Job Scheduling Tools: Control-M, Autosys, and UNIX Crontab.

Other Tools: TOAD 11.5, InterScope 7.0, AquaData, SQuirreL SQL, ScriptIT and EXPRESS.

PROFESSIONAL EXPERIENCE

Confidential, New York

Tech Lead/ Architect/ Senior Developer

Responsibilities:

• Understanding the Compliance Monitoring Systems: MANTAS, Actimize, Citi’s Archer, Compliance Metrics Monitoring System, GLMS, NPA, Citi KYC, Mandatory Absence, Trade Surveillance and other AML monitoring systems.
• Analyze the requirement of various implementations: COMRAD CR8 Implementation, Prepaid Cards, MANTAS and Actimize Extractions, Prepaid Cards Metrics Calculation, Compliance Horizontals and Compliance Staffing.
• Worked closely with Business Analyst, Compliance Analytics, Compliance Officers, Compliance Regional Teams, DBA Teams and CATE Team along with Ab Initio Vendor Team.
• Re-engineering the COMRAD Applications for all the processes particularly Ab Initio graphs, Pre/Post processes and Wrapper Scripts.
• Worked with Citigroup Ab Initio CATE Team for re-engineering of COMRAD - Ab Initio Architect Design.
• Prepared the FRD (Functional Requirement Document), High Level Design, and Low-Level Design (LLD).
• Design the detailed data level mapping in an existing processes as per requirement and business rules.
• Designed the Data Mart and Star Schema Design using Erwin Data Modeler 9.0.
• Developed the BRE mapping for the Business users on the forecasting of predictive analysis reports in various Compliance Risk Assessments and other regulatory reports.
• Developed the Ab Initio/Generic Graphs with these features: PDL approach, MFS, Continuous Flow, Component folding, Dynamic (ICFF) lookup, XML Processing and UNIX Shell Scripting using AWK and SED.
• Developed the SQL, PL/SQL Procedures and functions on ORACLE for COMRAD Archer application data access.
• Unit testing the Ab Initio Graphs, UNIX Shell scripting and involved in User Acceptance testing for the deliverables.
• Performed the performance turning issues & problems which caused the batch and continuous runs for the runs of 24*7 for supporting various regions end users.
• Implemented the Parallelism approach and EME standards for the existing Ab Initio graphs which avoids the high utilization of resources and performance issues.
• Managed the Production Deployments and maintained the streamed strategy on the deployment process.
• Provide the End-user support for all the production issues, resolve the transactional data processing issues, configuration issues and work with vendor for the application patch installation/deployments.
• Support the Job Automation schedules (continuous and batch) on daily basis and provide the on-call support for all production issues/deliverables.
• Prepare the various documents for Process Design, Job Procedures and End-to-End Process document.
• Troubleshoot the performance issues with end users on data transactional process.

Environment: Ab Initio GDE 3.2.2, Ab Initio Co>Operating System 3.2 and 3.0, Ab Initio EME 3.2 and 3.0, Elementum 3.1, BRE 3.0, Conduct>It 3.2, PDL, Autosys JIL Programming/Scheduling, MicroStrategy 10.0, QlikView 12, Business Objects, SQL, PL/SQL, DBVisualizer 7.2, SQL Developer, TOAD, UNIX Shell Scripting, Erwin Data Modeler 9.0, Perl, AWK, SED, J2EE, JSP, JavaScript, JRun Server, Eclipse, XML, SVN, CVS, Sun OS 5.10, Linux, Crontab, SYBASE ASE 15.2, ORACLE 11g and Windows 2000/Windows 7.

Confidential, New York/Warren, New Jersey

Lead Developer/Application Architect

Responsibilities:

• Understanding the CAW System & Upstream source systems (ACE Server, Aggregator, GMR & CE (Credit Engine).
• Analyze the requirement of various implementations of CAW for ACE - PSE (Pre Exposure Settlement), EPE and ETE.
• Worked closely with Business Analyst, Risk Analytics, Credit Officers, CAW End Users, DBA Teams, CATE Team.
• Re-engineering the CAW Application for all the processes particularly Ab Initio graphs, Pre/Post processes and Wrapper Scripts.
• Worked with Citigroup Ab Initio CATE Team for re-engineering of CAW - Ab Initio Architect design.
• Prepared the FRD (Functional Requirement Document), High Level Design, and Low-Level Design (LLD).
• Design the detailed data level mapping in an existing PSE process as per requirement and business rules.
• Developed the Ab Initio/Generic Graphs with these features: PDL approach, MFS, Continuous Flow, Component folding, Dynamic (ICFF) lookup, XML Processing and UNIX Shell Scripting using AWK and SED.
• Developed the SQL, PL/SQL Procedures and functions on Sybase for CAW GUI application data access.
• Unit test the Ab Initio Graphs, UNIX Shell scripting and involved in User Acceptance testing for the deliverables.
• Performed the performance turning issues & problems which caused the batch and continuous runs for the runs of 24*7 for supporting various regions of trading market data (New York, London & Tokyo and LATAM regions).
• Managed the Production Deployments and maintained the streamed strategy on the deployment process.
• Implemented the Parallelism approach and EME standards for the existing Ab Initio graphs which avoids the high utilization of resources and performance issues.
• Provide the End-user support for all the production issues, resolve the transactional data processing issues, configuration issues and work with vendor for the application patch installation/deployments.
• Support the Job Automation schedules (continuous and batch) on daily basis and provide the on-call support for all production issues/deliverables.
• Prepare the various documents for Process Design, Job Procedures and End-to-End Process document.
• Troubleshoot the performance issues with end users on data transactional process.

Environment: Ab Initio GDE 3.0, Ab Initio Co>Operating System 3.0, Ab Initio EME 3.0, Elementum 3.1, Conduct>It 3.0, PDL, Autosys JIL Programming/Scheduling, SQL, PL/SQL, DBVisualizer 7.2, SQL Developer, TOAD, UNIX Shell Scripting, Perl, AWK, SED, J2EE, JSP, JavaScript, JRun Server, Eclipse, XML, SVN, CVS, Sun OS 5.10, Linux, Crontab, SYBASE ASE 15.2, ORACLE 11g and Windows 2000/Windows 8.

Confidential, Irving (Dallas), Texas

Senior ETL/Ab Initio Developer

Responsibilities:

• Understanding the Source Application Systems, Back ends and environment
• Analyze the redaction requirements of PII (Personal Identified Information) fields of all the applications (REL, CFNA, Cards Canada) and Business rules for Development/Enhancement.
• Worked closely with Application Development/Testing Team, Business Analyst, DBA Teams, CITI’s CATE, ITRMO, and GCG-NA ISO organization in order to get the requirement of OLTP systems and business needs and to certify the ISO approval of data redaction at Citigroup level.
• Design the Redaction (Obfuscation) algorithms to each PII fields (including Primary keys, foreign keys and unique constraints).
• Analyze and Design the High Level Design and Low-Level Design (LLD).
• Design the detailed data level mapping (Data Redaction Algorithm) between the source and target systems as per requirement and business rules.
• Develop the Ab Initio Graphs (customized), Redaction Algorithms (Random, Randomize, Constant, Secure Lookup, Data shuffling, Substitution mapping), and UNIX Shell Scripting using AWK and SED.
• Develop the SQL, PL/SQL Procedures and functions on ORACLE and MS SQL Server for disabling/enabling the constraints/triggers before (after) the redaction process in RDBMS.
• Work with IBM Mainframe Application Team for getting the dataset files and COBOL Copy books and Tuning the performance in SQL, PL/SQL on Oracle and MS SQL Server Databases.
• Unit test the Ab Initio Graphs, UNIX Shell scripting and improving the performance testing based on the user acceptance of OLTP application (REL, CFNA, CaseTrak, Web Client Tracker, CFOS and Cards Canada) for the redaction process.
• Provide the End-user support for all the production issues, resolve the transactional data processing issues, configuration issues and work with vendor for the application patch installation/deployments.
• Support the Job Automation schedules on daily basis and provide the on-call support for all production issues/deliverables.
• Prepare the various documents for Process Design, Job Procedures and End-to-End Process document.
• Troubleshoot the performance issues with end users on data transactional process.

Environment: Ab Initio GDE 1.14, Elementum 3.0, Conduct>It 3.0, Ab Initio Co>Operating System 2.15, Ab Initio EME 3.0, Ab Initio Metadata Hub, Autosys, SQL, PL/SQL, Toad 9.0, PDL, UNIX Shell Scripting, AWK programming, Sun OS 5.10. ORACLE 11g, MS SQL Server 2000/2005, IBM Mainframe, DB2, COBOL, JCL and Windows 2000 Professional.

Confidential, Danbury, CT

System Analyst

Responsibilities:

• Strong Understanding of the Source Application systems and Back ends.
• Analyzed the requirements and business rules for development/enhancement.
• Designed the Metreo Vision Application Vector Cubes for functional requirements and business rules.
• Analyzed and involved in the high-level design and prepared the Low-level Design (LLD).
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Developed the Ab Initio Graphs, Metreo Vision Vector cubes, UNIX Shell Scripting using AWK, SED and Batch Job Processing and Scheduling by CRONTAB.
• Developed the SQL, PL/SQL Trigger, Procedures and functions on ORACLE and Teradata.
• Implemented the Metreo Vision Application changes as per GE Standardization and requirements and business rules on JBOSS Application Server and Apache Web Server.
• Developed the Ab Initio Graphs for loading/unloading the data using Fast Load, MultiLoad, Tpump utilities and BTEQ used in UNIX shell scripting.
• Tuned the performance in SQL, PL/SQL on Oracle and Teradata Databases.
• Unit tested the Ab Initio Graphs, Metreo Vision Vector cubes, UNIX Shell scripting and improving the performance testing based on the user acceptance of Metreo Vision application.
• Provided the end-user support for all the production issues, resolved the transactional data processing issues, configuration issues and worked with the vendor for application patch installation/deployments.
• Prepared the various documents for Process Design, Job Procedures and End-to-End Process document.
• Involved in deployment and patch installation for Metreo application vision in all the environments and maintained the versioning control for all the developments and deployments.
• Troubleshooted the performance issues with end users on data transactional process.

Environment: Informatica Power Center 7.2, Ab Initio GDE 2.14, Ab Initio Co>Operating System 2.14, Metreo Vision 3.3, QlikView 9.0, Business Objects 6.0, JAVA, JBOSS 4.0, Apache Server, XML, SQL, PL/SQL, Oracle 10g, Teradata 7.2, Toad 9.0, UNIX Shell Scripting, AWK programming, UNIX Cron Job Scheduling, SunOS 5.10 and Windows 2000 Professional.

Confidential, St.Louis, MO

System Analyst (Ab Initio)

Responsibilities:

• Solid understanding of the source legacy systems and Backend (Oracle, IBM DB2 and Teradata).
• Analyzed the requirements and business rules for development/enhancement.
• Designed the architecture of system for functional requirements and business rules.
• Analyzed and involved in the High Level Design and Low level Design (LLD).
• Analyzed the Database and Data modeling (Star Schema, Snowflake) as per requirements and business rules.
• Developed/enhanced the Ab Initio graphs (reusable and continuous flow) and Shell Wrapper Scripts (graph execution and Job schedule) and developed the generic/custom graphs for reusable functionalities.
• Developed/enhanced the PL/SQL stored procedures, triggers in ORACLE, and teradata for data management operations.
• Tuned the performance on execution of graphs, Data Unload and High volume Data Load (Teradata) and reviewed the graph using Ab Initio’s Review Checklist and EME standards.
• Scheduled the Ab Initio jobs using UNIX Crontab, Autosys and Control-M.
• Unit tested the Ab Initio Graphs/Wrapper Scripts and prepared the test case.
• Prepared the various documents for Job Scheduling Process Design, Job Procedures and End-to-End Process document for the Graphs, Wrapper script and Production Deployment document.
• Involved in deployment architectures for each release and manage the Version Change Management.
• Provided the on-call support for all production issues/deliverables.
• Trouble-shooting Performance issues with end users on very huge volume of data processes.
• Supported the Job schedules and client’s production issue.
• Participated in the AT&T’s IT Problem Management Process using Standard Processes and Tools.
• Participated in Production Support Problem analysis - provide specific, relevant production information to assist in troubleshooting the problem as Production on call support.

Environment: Ab Initio GDE 1.13, Ab Initio Co>Operating system 2.13, Erwin Data Modeler7.x, COBOL, IMS, JCL, PL/SQL, Oracle 10g, IBM DB2 UDB, Teradata 5/2, Toad 7.6, UNIX Shell Scripting, Perl Scripting, Control-M/Autosys, ScriptIT, Express, HP-UX B.11.11, SunOS 5.9, IBM-AIX.2000.

Confidential

Senior Ab Initio Developer

Responsibilities:

• Analyzed the WLR requirements, Business Rules and Source systems.
• Involved in the High Level Design (HLD) and Low Level Design (LLD) as well as Data Level Mapping between source systems and target systems.
• Developed the Ab Initio graphs (The processes are categories such as Source data preparation, Good, Proven, Unproven, Churn and Discrepancy reports).
• Developed the Wrapper Script for the End-to-End process of picking all source system’s files, runs the graphs in required sequence order (20 graphs) and Housekeeping process. Finally scheduling the
• Prepared the various reports (Actuate Objects) to analyze the data flow across the system that would make a right decision for business needs.
• Developed the Wrapper script and schedule on weekly basis using Autosys and UNIX crontab.
• Unit tested the Ab Initio Graphs/Wrapper Scripts and prepared the test case.
• Involved in deployment architectures for each release and manage the change management.
• Tuned the performance on the graphs, Unload and High volume Data Load and Reviews the graph using Ab Initio’s review checklist and BT’s EME Standards.
• Prepared the Process Design, Job Procedures and End-to-End Process document for the Graphs and Wrapper script.
• Participated in Production Support Problem analysis - provide specific, relevant production information to assist in troubleshooting the problem as Production on call support

Environment: Ab Initio GDE 1.13, Ab Initio Co>Operating system 2.12, Actuate, PL/SQL, Oracle 10g, Oracle Warehouse Builder, ODI 9i, Toad 7.6, Unix Shell Scripting, Perl Scripting, Control-M, Autosys, HP-UX, SunOS 5.8, Windows 2000.

Confidential

Ab Initio Developer

Responsibilities:

• Understanding clients various source systems SIDB (Service Inventory Data Base), NCAS (Network Capability Assignment System), Fast Cap, Space (Symmetrical Digital Subscriber Line Order System), Geneva (Convergent Billing System), CSS (Customer Service System), eCo (Electronic Customer Ordering), Fast Provide BB, Glossi (Global support system for invoicing), SOS (Service Process Automation Control Engine) and target Systems.
• Analyzed the requirements, High Level Design, Business Rules and the designs of Data level design (DLD mapping) between sources and target fields
• Developed an Ab Initio graph for customization of user request process.
• Developed the Wrapper Script for BBDQM-Data down load and its covered the backup process for all legacy systems, runs the graphs as required sequences (15 graphs), exporting the output files into target system and Housekeeping process and scheduling the wrapper script on daily basis using Cron tab.
• Tuned the performance on the graphs and Reviews the graph using Ab Initio’s review checklist and BT’s EME Standards.
• Prepared the Unit Test Case Plan and End-to-End Process document for the Graphs and Wrapper script.

Environment: Ab Initio GDE 1.13, Ab Initio Co>Operating 2.13, COBOL, JCL, PL/SQL, Oracle 9i, Toad 7.6, UNIX Shell Scripting, Perl Scripting, Control-M, HP-UIX, SunOS 5.8, Windows 2000.

Confidential

Ab Initio Developer

Responsibilities:

• Understanding clients various source systems (PCIS, ISS, NRS, INS (Mainframe system), CALLSAMPLE, PACS, Call Sample (Incoming and outgoing), NDS, Geneva (Telecom Billing), SSD and COSMOSS Data) and target Systems.
• Analyzed the client’s new requirements, High Level Design, Business Rules and Low Level Mapping and understanding the existing graphs.
• Involved in the design of Data level design (DLD mapping) between sources and target fields as per new requirements (Call Sample, COSMOSS).
• Developed an Ab Initio graph as per client’s new requirements, Business Rules and populating the discrepancies tables (ORACLE) for each validation rules.
• Involved in the target system implementation for populating the Exception reports has uploaded process.
• Wrote the Wrapper Script for OTDB, RADS and its covered the backup process for all legacy systems, runs the graphs as required sequences (35 graphs), exporting the output files into target system and Housekeeping process and scheduling the wrapper script for weekly basis using Cron tab.
• Tuned the performance on the graphs and Reviews the graph using Ab Initio’s review checklist and BT’s EME Standards.
• Prepared the Unit Test Case Plan and End-to-End Process document for the Graphs and Wrapper script.

Environment: Ab Initio GDE 1.13, Ab Initio Co>Operating 2.13, COBOL, JCL, PL/SQL, Oracle 9i, Toad 7.6, UNIX Shell Scripting, Control-M, SunOS 5.8, Windows 2000.

Confidential

Programmer Analyst

Responsibilities:

• Analyzed SI PIP Source system, IP VPN Product’s Data model with Functionalities, and Client’s requirements, Business Rules.
• Designed a Physical data mapping of PIP SI (Service Inventory) VPN attributes onto the VPN entities.
• Developed the Ab Initio graphs with customized components.
• Wrote the Wrapper Script for SIODS PHASE B and its run the sequences of Ab Initio graph script files, generates the end-to-end execution status log, Housekeeping process, sends status log file to ASG team.
• Reviewed the graph using Review checklist, Implements the EME Standards on SIODS graphs and turning performance on graphs.
• Prepared the Unit testing case plan and End-to-End Process document for all Ab Initio graphs and Wrapper script.

Environment: Ab Initio GDE 1.12.9, Ab Initio Co>Operating 2.12, Oracle 9i, Toad 7.6, PL/SQL, UNIX Shell Scripting, SunOS 5.8.

Confidential

Programmer Analyst

Responsibilities:

• Understanding clients various Source systems and Target System (Oracle 8i, Text file, CSV files, XML Objects, SQL Statements file).
• Analyzed the client’s requirements, High Level Design, Business Rules and Low-level design.
• Designed the Data level design (mapping) between sources and target fields (DLD).
• Developed an Ab Initio graphs as per client requirements and Business Rules.
• Wrote the Wrapper Script for TnB (VINI, Preside, and Classic2Netcool), MPLS Ph2 Data Migration and Configure Management Process (Check-in, Checked out) with EME Standards. The wrapper script imports source data from Source system and exports onto OBJECTEL system through FTP.
• Scheduled the wrapper script for daily basis using Crontab (Synchronization).
• Reviewed the graph using Review checklist and EME Standards.
• Prepared the Unit Test Case Plan and End-to-End Process Document for every graphs and Wrapper script.

Environment: Ab Initio GDE 1.12.9, Ab Initio Co>Operating 2.10, Oracle 9i, TOAD 6.5, PL/SQL, XML, XSDL, UNIX Shell Scripting, SunOS 5.8, Windows 2000.

Confidential

ETL Designer and Developer

Responsibilities:

• Excellent understanding of the client’s database.
• Created various mapping and reusable transformation.
• Involved in the application systems maintenance for day-to-day operations
• Carried out scheduled Maintenance and performance tuning activities
• Cleaned up the Bad data from the database
• Validated the mapping, generating and loading the Data
• Involved in writing stored procedures for depends upon Business requirements
• Testing and Trouble Shooting

Environment: Informatica Power center 5.1.1, PL/SQL, Oracle 8i, Windows NT/2000

Confidential

ETL Designer

Responsibilities:

• Understanding OLTP System as well as analyzed the database system
• Created various Mapping, reusable transformations and validating the mapping, generating and loading data.
• Involved in enhancements in PL/SQL stored procedures for various business logic.
• Data validation and Documentation.
• Performance tuning based validating the mapping

Environment: Informatica Power Center 5.1.1, PL/SQL, Oracle 8i, VB, ADO, ActiveX, MTS, MS DTS, MS OLAP, MS EXCEL, Windows NT/2000.