SUMMARY:

• I am a Sr. Consultant with over 20 years of experience working for major corporate clients in several successful and challenging Data related projects, in areas ranging from Data Acquisition to Presentation. My experience has been garnered from exposure to a number of verticals including Financial Services, Insurance, Retail, Manufacturing, Consumer Goods, Hospitality and Telecommunications.
• Solid expertise in a variety of ETL tools as an Architect/Developer.
• Highly skilled in complex SQL development using most variants of SQL from Microsoft, IBM, Oracle and Sybase.
• Exposure to a wide variety of BI Tools and experienced in OLAP development
• Worked in full life cycle implementations of Datawarehouses as Architect/Developer.
• Solid knowledge and experience in Dimensional/Data Modeling, Database Design and SDLC.
• Ability to work independently, as part of a team or lead teams and also mentor team members.
• Possess the commitment to deliver successful business solutions within the constraints of time and budget.

TECHNICAL SKILLS

ETL: Infosphere Datastage 8.x, 7.x, 6.x, MS DTS, SSIS, SAP BW

RDBMS: Oracle, SQL Server, DB2, MySQL, Sybase

Reporting/OLAP: MS SSAS, MDX, BEx, Business Objects, Crystal, Cognos Powerplay, SSRS

Scripting /Other: JavaScript, VBScript, XML, HTML, WSH, Unix shell

Modelling: Erwin, Visio, Data Architect, Bizagi

ERP/Packaged Apps: HANSEN, SAP R/3 4.6c (SD, MM, FI/CO), Macola, Accpac, Ramco

Languages: Visual Basic, C, C++, C#, COBOL

PM Tool/Methodology: MS Project, MSF, ASAP, Macroscope

OS: Windows, UNIX/AIX/SOLARIS, VMS, OS/2, Netware, MS - DOS

Change/Defect: SVN, Sourcesafe, JIRA, Test Director

Other Skills: Octave, MATLAB, DBA, ETL Architect, Modeling (Data/Dimensional), Documentation

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Datastage Consultant

Responsibilities:

• Extraction and transformation of Transactional costs and income related information for holdings from Simcorp Treasury back office software.
• Supported a MUREX DM historization project that extracts daily and monthly transactions from the DM tables into a repository that acts as one of the sources for an enterprise data warehouse
• Extraction and transformation of data from MUREX DM tables for underlying Equity Swaps transactions with augmentation of Index constituent level information for detailed exposure and daily statutory compliance reporting.
• Worked on a Cash Forecast Automation involving various data sources for detailed planning.
• Worked on enterprise level classification of securities for geographical and sector information which is crucial for geographical exposure reporting
• Worked on a Dashboard for Real Estate investments
• Worked on Foreign Exchange holdings
• Prepared Mapping, Design documents for the solutions
• Also involved in the maintenance of various existing datawarehouse solutions and closely working with the QA and business reporting evangelists in the analytics department.
• WSDL datastage publishing for on demand execution of ETL adjustment jobs.
• Development tools used - Infosphere Datastage 8.5/Linux/Oracle 11G. Reporting is on WebFocus.

Confidential

Sr. ETL Solutions Designer

• Liaising with various teams for requirements and architectural compliance
• Designing ETL framework and solutions involving various TD internal and external sources and targets
• Conducting Low Level Design walkthroughs of solutions designed.
• Overseeing offshore designers entrusted with similar tasks
• Managing offshore ETL development for delivery within the constraints of budget and time.
• Coordinate with the testing team and developers in the timely resolution of defects.
• Worked on various POCs for data standardization, webservice consumption etc
• Development tools used - Infosphere Datastage 8.7/AIX/Oracle 11G/DB2/SQL Server/XML

Confidential, O’Fallon, St. Louis Area

Sr. ETL Consultant

• Reviewed the ETL framework and provided recommendations
• Designed, Developed, Unit Tested ETL components for an Enterprise Data Repository target housed in an Oracle database with data sourced from 3 systems (BillPay, Confidential Debit Switch and Member Parameter System) in Oracle, DB2 databases and COBOL layouts. Used IBM InfoSphere DataStage 8.5 as the ETL tool.
• Supported user testing, created design and support documentation for the development and support team.

Confidential

Sr. ETL Consultant

• Was involved in the design and development of ETL components for a Global Trade Surveillance and Compliance monitoring initiative that uses Actimize, DataStage 7.5/8.5 and SQL Server 2008 as tools.
• Project involved ETL development for sourcing data from 50+ trading applications (equities, fixed income, derivatives, commodities, FX, AML etc.), market data (Reuters, Bloomberg), client, securities and reference data. The source data was in a number of different file formats and databases.
• Developed Stored Procedures for processes in SQL Server 2008 that ranged from medium to high level of complexity
• Collaborated with Business Analysts, Architects and QA teams in successful delivery of phased releases
• Led the ETL team (7-10 experienced developers including offshore resources) and also mentored the developers
• Trading application data used from Broadridge, Gloss, Rolfe & Nolan, AOM, GS, Fidessa, Murex, Openlink etc

Confidential

Sr. ETL Consultant

• Was involved in the architecture and development of ETL processes for a large data warehousing initiative that used DataStage 8.1 and DB2 8/9 as tools.
• Was involved in complex DB2 Transact SQL query development for post processing and report development
• Designed procedures/test cases for System Integration/Unit Tests, created processes for audit control, developed the standards for ETL documentation and supported User Acceptance Testing.
• Performed Design and Process walk thru presentations for the in-house teams of ETL developers and Operations staff.

Confidential

ETL/SQL Consultant

• Was involved in the design and development of ETL processes for integrating spend transactions from systems like SAP, Peoplesoft, GreatPlains,Nexacor for ultimate delivery to an Ariba Analysis system.
• The workflow included handling bad data, archival, email relevant support personnel.
• Developed ETL and SQL components using SSIS and SQL Server 2005.
• This solution won Bronze Award for Best Enterprise Solution at Canadian Channel Elite Awards.

Confidential 

Data/QA Consultant

• Was involved in the design and development of etl processes for a Data Standardization/Datawarehousing initiative that replaced a legacy system originally developed in Tandem.
• Daily POS data from over 1400 restaurants was continuously extracted from the back office systems and were parsed, validated and ultimately loaded into a datawarehouse. The source data was in multiple complex layouts and had to be validated and standardized against a huge set of business rules.
• The entire solution was staged through processes developed in Datastage 7.5, AIX, DB2, Cognos.
• Developed ETL components in Datastage and queries of medium to high complexity in DB2 Transact SQL.

Confidential

ETL/SQL Server Consultant

• Was involved in designing and developing ETL processes for an Electronic Funds Transfer project for the Subscriber and Billing Services, using Datastage 6/ORACLE/Unix.
• Was involved in designing and developing ETL processes for the IPTV project, for import of TV Guides and PPV data for subsequent export to MSTV. Used XML, Datstage 7.5, ORACLE and Unix.
• Also, was involved in SRED (a Research and Development Project), with the following responsibilities:
• Preparing a recommendation report for Optimizing Databases and SQL Server
• Creating a Datawarehouse Prototype using MS Analysis Services on SQL Server

Confidential

BI Consultant

• Architected the Enterprise Data Warehouse. The data warehouse was designed to use a Star Schema. Cubes were built using MS Analysis Services/MDX/MOLAP and the user reporting tool was Cognos Powerplay.
• Designed and Developed ETL components for Forecasting, Sales, Orders, Promotions and Trade Planning modules sourced from various systems and loaded into a centralized datawarehouse in SQL Server 2000, using MS DTS, Stored Procedures.
• Was also responsible for designing transactional replication, performance tuning and SQL database administration tasks.
• Was involved in numerous data integration projects including creating exports for various SAP 4.7 modules.
• Developed administration utilities in VB and C#.

Confidential

Data Architect/ETL Developer

• Developed stored procedures, analytic reports, scripts, components for an Online Golf Reservations System
• Administered production databases, handled change management, tuned performance, analyzed and integrated 3rd party software and data viz., AGC, PGATour, Linkstime, Teemaster.
• Used SQL Server 2000, Commerce Server 2000 (ads, membership, reports), VB, VBScript, ASP, ORACLE 8.1, DTS, XML, Pivotal in an n-tier implementation.

Confidential

SQL Consultant

• Involved in planning the upgrade of SQL Server Versions from 6.5 to 7.
• Modified all affected database related components of Reinsurance applications
• Set up various database processes - Backup, Maintenance procedures and Transactional Replication