PROFILE:

• Over 20 years of experience in various capacities ranging from junior programmer to Project lead and Manager in midrange, mainframe and PCs environments.
• 15 years of experience developing large scale Business Intelligence Data warehouse applications using Ab Initio, Informatica, Teradata Parallel Transporter, Teradata/Oracle, Paraccel DB, Elasticsearch, Business Objects, Micro strategy in Unix and Mainframe environments.
• Extensive experience in Teradata V2R13, V2R6, V2R5 Data Load/Unload utilities like Fast - Load, Multi-Load, Fast Export, BTEQ, Tpump.
• A strong working knowledge on Teradata V2R13, V2R6/5 Database design (conceptual and physical), ETL Development, Query optimization and Performance Tuning.
• Experienced on Logical - Physical data models conversions, Fine tuning (Performance tuning) the complex queries and views. Extensive experience in Data modeling, Data warehousing, ETL, Data Administration, and excellent skills in SQL coding and UNIX shell scripting.
• Experience in Analysis, Design and Development of Data marts for project specific needs.
• Worked across all phases of Data Warehouse project life cycle and well versed with concepts of Dimensional modeling, ETL and Business Intelligence.
• Experience in leading/managing technical teams. Handled multiple roles - Database Administrator, Technical Lead, SME, Designer and Developer
• Mentored team members to understand the system flows, also was part of providing feedback on their performance during yearly assessments.
• Experience in Business Objects universe design and developing reports using WebI.
• 6 years of experience in developing Object oriented applications using Smalltalk Visual works 2.5, Rational Rose, UML.

TECHNICAL BACKGROUND:

Languages: Unix Shell scripting, Python, Smalltalk, C, C++, Java, C# .NET, Cobol, SQL, PL/SQL, Perl, HTML, Java Script, FORTRAN, Python

ETL Tools: Ab Initio Co>Op V 2.14/3.0.3.1 , SSIS 2008, Informatica7.1

BI Tools:  MicroStrategy 9.5, Business Objects XIR2

Tools: Erwin, Sql Assistant, TOAD, SAP, Visio, Rational Rose, Envy 3.0

Databases: TeradataV2R13/V2R6/V2R5,ORACLE-11g, Paraccel, ElasticSearch, Postgres

Teradata Utilities: Teradata Parallel Transporter, Multiload, Fastload, Fastexport, BTEQ, TPUMP

Big Data:   Hadoop, MapReduce

PROFESSIONAL EXPERIENCE

Confidential, McLean VA

Environment: Django, Python, Linux, C++, Teradata V2R14, Paraccel 5.2, ElasticSearch

• Working on Novetta Cyber Analytics product which is used to analyze the network traffic for threats. NCA provides an advanced processing capability that provides computer network intrusion analysts an in-depth understanding of hostile intruder behavior. NCA rapidly ingests, processes, sessionize, augments, and fuses network traffic into a high performance, massively scalable analytical system to enable the rapid discovery and complete analysis of network attacks and activity.
• Responsible for the performance of queries on Paraccel/Teradata Databases as the queries deal with huge amounts of data in the order of Billions of rows.
• Tuning SQL queries for performance and developing new queries.
• Porting the entire application to use ElasticSearch as the backend database instead of Actian Matrix(Paraccel). This effort involves converting all the queries (more than 30) from SQL queries to use ElasticSearch DSL query format.

Confidential, Baltimore, MD

Environment: Teradata V2R13, ETL, Multiload, Fastload, Fastexport, BTEQ, SQL Assistant, TSO, Mainframe, Informatica, Micro Strategy

• As a Teradata Data Architect, leading the team in the implementation of BI applications for the Centre for Medicare services (CMS) to support the Affordable Healthcare Act also known as Obama Care.
• Responsibilities include representing the Northrop team in customer requirement gathering sessions along with Requirements team and presenting the design solutions to the customer.
• I specifically overlook the development for the Integrated Data Repository (IDR) hosted on Teradata database which implements various complex rules to align the beneficiaries to Accountable care organizations (ACO). IDR serves as the system for generating financial reconciliation reports by the CMS and is highly visible to various stakeholder organizations like CMS, CMMI, OIS, CM/P1, ACO’s, CCO’s.
• Designed and implemented the monthly reports generation of Medicare Claim and Claim Line feed of 19 reports that contain claims information at various levels and goes out to the ACO’s monthly thru a secure Electronic File transfer (EFT) process.

Confidential, Vienna, VA

Environment: Teradata V2R13, ETL, Multiload, Fastload, Fastexport, BTEQ, SQL Assistant, TSO, Mainframe

• Handled development enhancements to the Teradata data warehouse and improved the performance of certain non-performing queries.
• Implemented the interface to provide the details of the TAX evaders to confirm with Financial Institutions Record Match (FIRM) program to California State. Every quarter the state will send a list of SSN’s and the institutions needs to send the information regarding the accounts held by the persons with those SSN’s. The interface is designed in a flexible manner that it can be extended to support any other state that implements FIRM program with minimal or no changes needed.

Confidential, Reston, VA

Environment: Teradata V2R5/R12/V2R13, TPT, ETL, Ab Initio, Oracle, SQL Server, UNIX Shell Scripting, Multiload, Fastload, Fastexport, BTEQ, TPUMP, PL/SQL, SQL Assistant, Business Objects XIR2, Control-M, Connect Direct (NDM), FTP

• As part of the data warehouse team developed various data warehouse systems like MAP(Multi dimensional Analysis of Performance), SAIL(Integrated Service Level Sales and Churn Activity) and BMW(Base Marketing Warehouse) that help the Confidential Management, Sales and Marketing teams to do various statistical and modelling calculations regarding the Subscribers and help in creating various Campaigns targeting specific subscribers.
• Involved in all the aspects of ETL design and development right from the initiation of the project to implementation of data warehouse. Duties include working with Business to gather requirements, analyze the data, involve in modeling, design, code and test through the ETL process to create data warehouses. Ab Initio, Teradata Bteq, Fastload, multi load and Fast export utilities, Oracle and SQL Server databases have been used to perform the ETL activities. Also involved in the BO Universe Design and development of reports using Business Objects XI R2.
• Analyzed and restructured the job stream to improve the performance and meet the SLA’s.
• Extensively coded using Unix Shell scripts, Teradata utilities MultiLoad, Bteq, Fast Export, Fast Load, TPump
• Developed COBOL programs, JCL
• Developed Ab Initio graphs for the ETL process to move the data from sources (Oracle, SqlServer, Flat files) into Teradata.
• Ab initio, tuning Teradata SQL query’s for performance.
• Developed JCL’s to load data to Terradata using FLOAD, MLOAD, Bteq.
• Developed JCL’s to archive staging tables using ARCMAIN
• Developed COBOL programs to match files and clean data.

Confidential, Portland,OR

Environment:TeradataV2R5, BTeq, MLoad, FastExport, TPump, FastLoad, ETL, MicroStrategy 8.0, Stored Procedures, Macros, SQL Assistant, Autosys, SAP

• As part of KTBR(Keep the Business Running) team provided production support to Next Generation Capital reporting application and coding enhancements/performance improvements.
• Responsibilities include trouble shooting, problem analysis and resolution coding, testing and implementation of ETL processes in a Teradata SQL & MicroStrategy production support environment. Working with customers and stakeholders to understand requirements, working with data modelers, BA's and developers to ensure project support is successful and root cause analysis is complete to ensure problems are properly resolved.
• Reduced query execution times to meet SLA’s by analyzing the data, changing PI’s, adding JI’s and PPI’s
• Reduced CPU usage per query by implementing optimal Index choices and tuning in efficient queries.
• Shared production support OnCall responsibilities.

Confidential, Kansas City/ Chicago

Environment: Ab Initio, TeradataV2R5, Oracle, BTEQ, FLOAD, FEXP, MLOAD, Queryman,PL/SQL, Unix Shell scripting, Erwin, Business Objects 6.x, Smalltalk, Envy, Java, ARCMAIN, File Aid, Sync Sort, MVS, TSO, ISPF

• Performed a dual role as a manager maintaining the group of Confidential developers on the project overseeing their performance/resource management and as a Business Intelligence developer.
• Designed and developed One Confidential Finance Information System that integrates multiple (divisional) financial information warehouses and provides a One Confidential Finance Data Store to consolidate core Customer & Revenue Information from Confidential ’s legacy customer and billing systems. Total size of the Teradata database is 24 Terabytes.
• Coded jobs to load Revenue data to Approved Invoice Charge table which is about 4 Terabytes in size. The table is Partitioned Per Index and wrote the queries to make effective use of the PPI for faster execution times.
• Developed Ab Initio graphs Jobs to cleanse and load data to tables.
• Fine tuned SQL Queries for performance by changing the indexes and determining the columns to collect statistics on.
• Restructured several jobs to make the revenue job stream to run in parallel so that the Daily revenue process fit into a 24 hour window.
• Involved in various ETL releases for the enhancements to the existing PAR/Pinnacle data warehouse. Coded Unix Shell scripts, Teradata utilities like MultiLoad, Bteq, Fast Export, Fast Load, TPump, COBOL programs, JCL, ETL tools like Ab initio, tuning Teradata SQL query’s for performance.
• Developed JCL’s to load data to Terradata using FLOAD, MLOAD, Bteq.
• Developed JCL’s to archive staging tables using ARCMAIN
• Developed COBOL programs to match files and clean data.
• Developed Business Objects reports using Webi.
• SME for Genesis application used by Receivables group. Involved in analysis, design and coding for various enhancements of the application.
• Involved in development for Connection Manger project to convert all ION voice customers from the IP network to the Confidential ATM network.

Confidential, Arlington, VA

Environment: Smalltalk Visualworks2.5.2, Envy 3.0, Oracle7.3, Windows NT 4.0

• Involved in design and coding the enhancements for Product Manager application which is used for defining, storing, applying, translating, maintaining and distributing the comprehensive product definitions and business rules for Confidential residential products.
• Designed and coded the security framework for the system to be data driven rather than being hard coded into the system.

Confidential, Phoenix, AZ

Environment: Smalltalk Visual works 2.5.1, Windows NT4.0, Sybase 11, Envy3.0

• Maintenance & Enhancements of Centralized Performance Database system which will provide the Corporate Service Center (CSC) management staff with the ability to track the performance of their employees at both the Team and individual levels.
• Did enhancements to the system to provide the ability for the daily keying of data rather than once a week.
• Changed the Security model to accommodate the new security features of the system. With the changed security model the system supports 8000 users as opposed to the previous 200 users.

Confidential, NY 

Environment: Smalltalk Visualworks 2.0, SunOS Windows NT4.0, Sybase 10.0.2, Envy3.0, Perl, HTML, JavaScript

Responsibilities:

• Provided maintenance & enhancements for CIS EMStar application.
• Ported the existing application from Envy1.43/VisualWorks 2.0 with Sybase10-DBLibrary to Envy3.01/VisualWorks2.5.2 and Sybase11-CT Library on Windows NT.
• Involved in developing GUI and writing stored procedures to do the backend processing in Sales Web application. The system captures all the trades nightly, monthly and weekly from all the systems like ALM, PAMPA etc by using Crontab’s and process the trades and stores them in a data warehouse.

Confidential

Environment: Smalltalk Visualworks2.0, Oracle7.x, Windows NT 4.0, Developer/2000, C

Responsibilities:

• Involved in the analysis, design and development of Object Oriented applications using Smalltalk.
• Involved in developing the GUI classes and report generation.
• Used Rumbaugh’s methodology for development of requirements model and identifying objects.
• Used Wrif’s-Brock CRC cards for the development of the system.