PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr Integration Architect

Responsibilities:

• Educate the cyber security team on the myriad aspects of integration ideally required to create a seamless data Integration platform with disparate data sources.
• Provide technical leadership and direction to numerous stake holders .
• Data integration architecture, architecting the full lifecycle environment, the physical and the technical infrastructure architecture
• Coordinate Design, development of Python scripts to automate load processes into RSA Archer eGRC, a Governance, Risk and Compliance System meant to report on the state of information security at the company as far as Key Risk Indicators and Key Performance Indicators are concerned.
• Integrate data from disparate systems such as WhiteHat, FireEye, IronPort, Nessus/Tenable, Qualys, McAfee, Tenable Cloud, Fortify, BlueCat, StealthWatch, Lancope, RSA - DLP and Service Desk through exposed APIs.
• Architected a solution to process JSON files through Datastage to be fed into the Archer eGRC System as a proof of concept .

Technologies used: RedHat Linux, Windows 2008, SqlServer 2012, IBM Infosphere DataStage 9.1, Sqlite, Python, Pandas, MS SCCM, Tenable, SoapUI, XML, JSON, Bash Scripting, BitBucket, CA AMDB, Orion, GiT Hub, OpenDNS, AWS, etc.

Confidential, Atlanta, GA

Sr. Database/ Data Modeler Consultant

• Analysed existing logical data model and made enhancements to the core transactional retail application called TAMSII being used at Confidential country wide and Canada.
• Database administration & support for the TAMSII application currently in use at NAPA stores.
• Created Database Builds, Releases and Merges and resolve discrepancies in SubVersion.
• Analysed, developed and maintained stored procedures, triggers and packages in PL/SQL.
• Created Pricing Profile, related to auto parts, extracts together with Inventory updates for the BI group.
• Created XML data extracts pertaining to store orders and invoices for store to store communication.
• Tuned embedded sql queries using TKPROF, Explain Plan and SQL-Tune.
• Developed and maintained data dictionary within ERWIN to create metadata reports for the existing BI team and other teams involved in reporting.
• Performed quarterly SOX validation and verification of the store databases.
• Extensively used JIRA to track and resolve defects.
• Managed an offshore team of four developers and a few onshore QA analysts.

Technologies used: HP/UX, Oracle 10g, SubVersion, Squirrel, PL/SQL, Toad, ERWIN, J2EE, Beyond Compare, SPRING, SilverStream, SoapUI, Hibernate, EJB, Eclipse, XML, XSL, JIRA, etc.

Confidential, Atlanta, GA

Sr. BI Consultant

• Worked on dimensional model of a corporate data warehouse
• Lead DataStage architect responsible for the ETL processes to build enterprise level data marts.
• Analyzed business requirements specifications with business leaders.
• Designed Audit, Exception log and control tables to maintain job statistics for end users.
• Designed job sequences to address mail notification for individual jobs to maintain process integrity.
• Worked on data profiling using IBM Information Analyzer/Profile Stage, validating data values and column/table relationships, source to target field mappings, source system profiling and analysis
• Implemented Change Data Capture functionality to address Type-2 functionality.
• Assisted in backend development using the entire suite of Teradata tools such as Parallel Transporter, BTEQ, Multiload, and FastExport.
• Used XML Metadata Importer to create XML Schema and table definitions.
• Processed XML data feeds from DB2 databases using the XML Pack in Datastage.
• Extensively used XML transformation stage with XSLT transforms in Datastage to create XML files.
• Implemented load scripts in PL/SQL to process data in External Tables supported by files being created by external feeds from an Oracle data source.
• Designed and oversaw development of a datamart pertaining to railroad damage prevention and assisted the team in creating related detailed reports/dashboards using Tableau.
• Mentored a team of five developers on the use of DataStage and helped in the development of the ETL processes.

Technologies used: IBM AIX, Red Hat Linux, Teradata 14.0, Oracle 10g, IBM DB2, IBM Infosphere Datastage 8.7, IBM Quality stage 8.7, IBM Information Analyzer 8.7, PL/SQL, ERWIN, PVCS, HPSM, Tableau 7.

Confidential, Atlanta, GA

Sr. Lead Technical Specialist

• Designed and developed ETL processes together with PL/SQL processes to load healthcare application source data from disparate sources such as Millenium, IDX, Healthquest, META etc.
• Architected data collection methods and measurements (definition, design, and workflow).
• Carried out extensive data cleansing techniques such as Deduplication, Relationships, Address Validation, Identified, Standardized, Matched, and Reconciled using IBM Datastage Quality Stage.
• Provided strategic guidance and data analysis within a managed care organization, including health care costs, provider contracts, revenue & profitability, provider incentives & utilization.
• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to ensure it is in-line with business requirements. 
• Worked on data loads comprising of XML feeds from Millenium, the main hospital system using PL/SQL XML DOM parsers and database links.
• Assisted the team in developing external interfaces for healthcare data to be consumed by other agencies and research organizations.
• Implemented Pipelined Table Functions, Bitmap Indexes, Nested Tables/Varray Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Worked on a HL7 data parser using Altova MapForce as a proof of concept which was later developed in unix shell scripts and PL/SQL.
• Administered both Server & Parallel Extender/Orchestrate and Multi Client Manager in DataStage.
• Partitioned large tables using different composite partitioning techniques.
• Extensively created Packages to carryout heavy duty data crunching.
• Incorporated extensively the use of exchange partitions to facilitate faster loads and global and local partitioned indexes.
• Incorporated the use of Dynamic SQL using binds, Associated Tables/Nested TableCollections, Oracle Context and Regular Expressions extensively.
• Implemented PL/SQL object oriented code to address different hierarchical nature of the data.
• Used the SQL tuning advisor quite extensively to tune individual queries behind Microstrategy reports.
• Helped develop business intelligence reports in Microstrategy covering various healthcare aspects.
• Managed a team of two junior developers in the external interfaces team.

Technologies used: Linux Blade Server, IBM Infosphere Datastage 8.1, IBM Quality stage 8.1, Altova MapForce, Microstrategy, Oracle 10g, ERWIN, PL/SQL, XML, XQUERY/XPATH, Java, SQL Tuning Advisor, HL7.

Confidential, Marietta, GA

Application Integration/ BI Consultant

• Designed and developed application Interfaces to enable cross-application communication between a CRM System from Dendrite Corp and a corporate Datawarehouse.
• Implemented Oracle Streams (unidirectional, bi-directional and downstream capture) to manage operational data stores to be used a source for a corporate data warehouse.
• Developed extensive ETL processes in PL/SQL using Java Stored Procedures to affect ETL of external data feeds from external vendors.
• Developed PL/SQL stored procedures & functions to transform and load data from internal application sources through external tables.
• Created materialized views together with logs to address incremental changes to create aggregate information repositories between Development, QA and Production environments.
• Worked on load modules to process CRM customer sales XML files using the PL/SQL DOM Parser.
• Developed Java code to enhance functionality of the tool DT Studio.
• Carried out extensive database performance tuning using Oracle Statspack.
• Managed a small team of backend developers.

Technologies used: HP-UX Servers, HP-UX 11.0, Oracle 9i, TOAD, Pl/Sql, CVS, Embarcadero DT Studio 3.0.

Confidential, Atlanta, GA

Sr. Data Warehouse Consultant

• Principal ETL Architect primarily involved in the design of process workflow, the data structure, and the ETL functionality for GameTap, an online gaming offering by Time Warner.
• Assisted in the creation of the multi-dimensional data model and detail design specifications.
• Initiated and implemented a metadata project and repository that provided a single point of reference for information about data resources of the project resulting in better understanding of the data available, encouraged data consistency and data reuse.
• Assisted in creating custom PL/SQL packages and extensively used external tables.
• Tuned the loading of data though PL/SQL procedures using bulk loading techniques.
• Served as the Lead ETL architect to feed PeopleSoft financial data to a Financial Data warehouse to be used by Hyperion for downstream analysis.
• Filled the role of a mentor to two senior developers on the use of DataStage.

Technologies used: Linux, Oracle 10G, Erwin, DataStage 7.5, Star Team, RapidSql, TOAD, Business Objects Enterprise XI, PeopleSoft Financials, PL/SQL

Confidential, Atlanta, GA

Sr. Database Integration Consultant

• Worked as a team lead and assisted in the customization and implementation of a Unix/Oracle based Traffic Court System to supplant a legacy IBM OS/JCL system.
• Helped design and develop new forms and reports to accommodate custom functionality.
• Created customized PL/SQL library files to be used by the GUI front-end system.
• Participated in requirements gathering sessions with stakeholders to understand and document the business requirements as well as the goals of the project.
• Spearheaded data migration effort to move data the legacy system to the Unix based Application addressing data integrity in the Courts Application.
• Added Imaging Controls to the Courts system to enable indexing and viewing of scanned images.
• Carried out extensive performance tuning of the application as well as the database.
• Developed extensive PL/SQL packages, stored procedures & functions in addition to the existing suite of objects in the data model to facilitate functionality of the enhanced application and conformity to the business rules in the legacy system.
• Assisted in database administration, backup and recovery procedure and created fine grained access security policies.
• Custom coded Java processes in the middleware JACADA to affect real time integration between the Unix based System and the OS based legacy system.
• Mentored a team of developers in the use of Informatica.

Technologies used: SUN 6000E, IBM OS/JCL, Solaris, ERWIN, Oracle 9i, Developer 6i Forms & Reports, PL/SQL, Java, Informatica 5.1, TOAD, JACADA, JDBC, JSP, DOCUPACT.

Confidential, Atlanta, GA

Sr. Siebel Consultant

• Served as a lead consultant Implementing a Siebel Sales Automation system.
• Migrated data from external sources into the system using Siebel’s own Enterprise Integration Management tool and Unix Shell scripts.
• Automated interfaces, provided application support, and assisted quality assurance personnel.
• Developed a Market Analyzer utility to serve as a tool for assigning accounts based on different market criteria using object PL/SQL with the associated features such as private/public functions and procedures.
• Provided Siebel System administration support and optimized the application for performance enhancements in conjunction with Siebel SMEs.
• Developed an interface between the Siebel Call Center and the legacy billing system as a proof of concept for real time data transfer incorporating XML using MQ-Series as the middleware.
• Worked with a team of quality assurance analysts.

Technologies used: SUN 6000E, Siebel eComm6.3/Tools, Oracle 9i, EIM, EAI, SQLStation, TOAD, PL/SQL, XML, MQ-Series, C.

Confidential, Alpharetta, GA

Sr. Lead Siebel Consultant

• Principal Data Integration Architect entrusted with the responsibility of data migration from an older version of Siebel Sales Automation running on Sybase to a newer version running on Oracle.
• Helped the team develop EIM scripts and the associated wrapper Unix shell scripts ensuring data integrity as data were being loaded.
• Customized EIM load execution cycles, extended base as well as the interface tables to enable further customization to accommodate all the legacy application data,
• Assisted the team in configuring the sales force application to conform to the client specifications using Siebel tools and eScript.
• Managed a team of two senior developers in the data migration effort.

Technologies used: HP-K420, HP-UX 11.0, Siebel 6.0.1, Siebel Tools, EIM, EAI, Oracle 9i, Data Junction, Siebel eScript, PC Anywhere, Sybase 11.3, SQL Server 7.0, PL/SQL