Resume

Sign in

Data Sql

Location:
Roswell, Georgia, United States
Posted:
October 01, 2016

Contact this candidate

Resume:

PROFESSIONAL EXPERIENCE

Elavon [US Bank] **/** – Present

Sr Data Integration Architect

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 cyber security at the company.

Integrate data from disparate systems such as WhiteHat,FireEye,IronPort,Nessus/Tenable,Qualys, McAfee, RSA-DLP, Service Desk etc

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, Python

2.7/3.4, XML, JSON, Shell Scripting, etc.

Genuine Parts Company, Atlanta, GA 12/12 – 11/14

Sr. Database/Data Modeler Consultant

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 Compare,

SPRING, SilverStream, Hibernate, EJB, Eclipse, XML, XSL, JIRA, etc.

Norfolk Southern, Atlanta, GA 05/11 – 11/12

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 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 developer for detailed reports and 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, HPSM,

Tableau 7.

Emory Healthcare, Atlanta, GA 03/08 – 05/11

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 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-Write and Transportable 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 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 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, Altova

MapForce, Microstrategy, Oracle 10g, ERWIN, PL/SQL, XML, XQUERY/XPATH, Java, SQL

Tuning Advisor, HL7.

Solvay, Marietta, GA 05/06 – 03/08

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

Time Warner Inc., Atlanta, GA 08/04 – 04/06

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.

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.

Technologies used: Linux, Oracle 10G, Erwin, DataStage 7.5, Star Team, RapidSql, TOAD,

Business Objects Enterprise XI, PeopleSoft Financials, PL/SQL

TDC SI, Inc., Atlanta, GA 02/02 - 08/04

Sr. Database Integration Consultant

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.

Cingular Wireless, Atlanta, GA 02/01 – 02/02

Sr. Siebel Consultant

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.

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

MQ-Series, C.

McKesson, Inc., Alpharetta, GA 10/00 – 02/01

Sr. Siebel Consultant

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

Anywhere, Sybase 11.3, SQL Server 7.0, PL/SQL

EDUCATION

B.S. Structural Engineering, National Institute of Engineering, India.

M.S. Computer Science, Texas A & M University, Texas

M.B.A Finance, Robinson School of Business, Georgia State University, Georgia

US Citizen



Contact this candidate