PROFESSIONAL EXPERIENCE

Confidential

Sr Integration Architect

Responsibilities:

• Initiate & 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.
• Integrate data from disparate systems such as WhiteHat, FireEye, IronPort, Nessus/Tenable, Qualys, McAfee, Tenable Cloud, Fortify, BlueCat, Lancope, RSA - DLP and Service Desk through exposed APIs.
• Architect a solution to process JSON files through Datastage to be fed into the Archer System.
• Automate the loads through CA Autosys scheduling tool.

Technologies used: RedHat Linux, Windows 2008, SqlServer 2012, IBM Infosphere DataStage 8.5, Python2.7/3.4, Pandas, SCCM, Tenable Security Center, Sqlalchemy SoapUI, XML, JSON, Shell

Confidential, Atlanta, GA

Sr. Database/Data Modeler Consultant

Responsibilities:

• Analyze existing logical data model and make enhancements to the core transactional retail application called TAMSII.
• Database administration & support for the TAMSII application currently in use at NAPA Auto Stores across the US and Canada.
• Create Database Builds, Releases and Merges and resolve discrepancies.
• Analyze, develop and maintain stored procedures, triggers and packages in PL/SQL.
• Create Pricing Profile extracts together with Inventory updates using PL/SQL for the BI group.
• Store to Store communication through XML documents pertaining to store orders and invoices.
• Tuning of application queries using TKPROF, Explain Plan and SQL-Tune.
• Develop and maintain data dictionary within ERWIN to create metadata reports for the existing BI team and other teams involved in reporting.
• Perform quarterly SOX verification of the store databases
• Extensive use of JIRA to track defects.

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

Confidential, Atlanta, GA

Sr. BI Consultant

Responsibilities:

• 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.
• Sole design/developer for Datamart, detailed reports/dashboards using Tableau for a Damage Prevention application.

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, HPSMTableau 7.

Confidential, Atlanta, GA

Sr. Lead Technical Specialist

Responsibilities:

• 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 indatamodel reviews with internaldataarchitect, business analysts, and business users with explanation of thedatamodel to make sure 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.
• Created external interfaces for healthcare data to be consumed by other agencies and research organizations using Oracle XML functions.
• Implemented Pipelined Table Functions, Bitmap Indexes, Nested Tables/Varray Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Worked on a HL7 data parser using Altova MapForce which was later developed in PL/SQL.
• Administered both Server & Parallel Extender/Orchestrate and Multi Client Manager in DataStage.
• Partitioned large tables usingdifferent composite partitioning techniques.
• Extensively createdPackagesto 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 Oracle AWR for troubleshooting performance bottlenecks and reporting on key parameters.
• Used the SQL tuning advisor quite extensively to tune individual queries behind Microstrategy reports.
• Developed business intelligence reports in Microstrategy covering various healthcare aspects.

Technologies used: Linux Blade Server, IBM Infosphere Datastage 8.1, IBM Quality stage 8.1, AltovaMapForce, Microstrategy, Oracle 10g, ERWIN, PL/SQL, XML, XQUERY/XPATH, Java, SQL

Confidential, GA

Application Integration/BI Consultant

Responsibilities:

• 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 in order to create summarized 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.
• Created Java stored procedures on imported classes in order to facilitate agile coding process.
• Carried out extensive database performance tuning using Oracle Statspack.

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

Responsibilities:

• 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.
• Created custom PL/SQL packages, stored procedures and functions.
• Extensively used external tables, an enhanced form of SQL loader.
• Tuned the loading of data though PL/SQL procedures using bulk loading techniques.
• Served as the Lead ETL developer on a project to feed PeopleSoft financial data to
• Financial Data warehouse to be used by Hyperion for downstream analysis.
• Customized and implemented a Unix/Oracle based Traffic Court System
• Designed, analyzed, and developed new forms and reports to accommodate custom functionality in Forms/Reports 6i.
• Created customized PL/SQL library files to be used by the front-end system written in Forms 6i.
• Participated in requirements gathering sessions with stakeholders to understand and document the business requirements as well as the goals of the project.
• Performed data migration from legacy IBM system to the Unix based Application addressing data integrity in the Courts Application.
• Added Imaging Controls using Forms to the Courts system to enable indexing and viewing of scanned images.
• Carried out 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 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 as a part of the middleware JACADA implementation in order to affect real time integration between the Unix based System and the MVS based legacy system.

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

Responsibilities:

• Implemented 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 and 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.
• Principal Data Architect with the responsibility of data migration from an older version of Siebel Sales Automation running on Sybase to a newer version running on Oracle.
• Developed EIM scripts and the associated wrapper Unix shell scripts.
• Ensured data integrity as data were being loaded.
• Customized EIM load execution cycles.
• Extended base as well as the interface tables to enable further customization as well as accommodating legacy application data,
• Configured the frontend application to conform to the client specifications using Siebel tools.
• Developed Shell scripts and SQL control files to load data through SQL Loader and addressing reprocessing of BADFILE records.

Technologies used: HP-K420, HP-UX 11.0, Siebel 6.0.1, Siebel Tools, EIM, EAI, Oracle 9i, Data Junction, Siebel VB, PC