Resume of ETL / Data Analyst

Title
ETL / Data Analyst

Primary Skills
Data analysis, transforming and loading data from vendors like Reuters, Compustat and Thomson Financials

Location
United Kingdom-North Wales

Posted
Jul-05-07

EXECUTIVE SUMMARY
I am a professional who has handled various assignments in designing, developing and testing systems for telecommunications, financial, health care and insurance organizations. I have been responsible for developing, testing and maintaining applications using a variety of tools. I have worked on various phases of system development and implementation. I have been formally trained in and worked with an organization certified in of Software Engineering Institute's (SEI) Capability Maturity Model (CMM) and an IS0 9000 certified product realization center.
WORK EXPERIENCE SUMMARY
* Developed modular systems that provide ease of development, maintenance, and operations. These systems are configurable using meta-data (parameters or tables).* Conceptual, logical and physical data design (3NF) including the use of ERWIN.* Developed systems for handling and reporting data quality related issues to data stewards by detecting errors using business rules or balancing algorithms.* Generating code from meta-data (database data-dictionary, mapping tools etc.)* Extracted data from relational data sources (DB2/AS400, Oracle, Sybase, SQL Server, Tandem) and data files. Designed historical and incremental pulls using streaming, custom extracts and files provided by the source systems.* Transformed and integrated data from disparate systems using Informatica, SQL, C++ and Perl. Implemented re-usable external transformations for data cleansing. * Knowledge of various databases. In-depth experience with Oracle(SQL, PL/SQL, SQL*Loader, external tables, export, import etc.)* Developed programs to compare data sets for implementing slowly changing dimensions.* Create test plans, executed test suites and documented the results.

WORK EXPERIENCE
10/2006 - Present: Starmine Inc.* Responsible for data analysis, transforming and loading data from vendors like Reuters, Compustat and Thomson Financials.* Write and maintain code using C++; STL, Boost, OTL libraries; PL/SQL, SQL, sql*loader, external tables, Oracle 9i; Delphi and Shell scripts.* Use export and import utilities.* Technical environment includes Linux, Windows, Oracle 9i, SQL, SQL*Loader, Imp, Exp, bash and ksh.10/2004 - 07/2006: Knightsbridge Solutions LLCClient: Blue Shield of California. Dec 2005 - Jul 2006* Translated template based code generators to PERL from MS-ACCESS* Created SQL templates for generating SQL for use in a data-warehouse using Oracle data dictionary. These SQL's would populate primary and foreign keys, de-normalize data to EDW/data mart format, highlight data integrity error reports. * Implemented Audit, Balancing & Control (ABC) system for providing a highly parameterized environment for configuration, execution and restart-ability of ETL jobs. Created data-model for supporting this table driven design in ERWIN. Created Perl & K shell scripts.* Reused Informatica design patterns (from previous projects) that supported the ETL architecture, including external transformation in C for cleansing data.* Was accountable for deploying code to various environments.* Was accountable for configuration & administration of Informatica repository.* Provided production support and helped troubleshoot issues that arose in various data runs.* Technical Environment included Oracle, Informatica 7.1.3, SQL, KSH, Solaris, PERL 5.8, ERWIN 4, CDMA for development needs.Client: Health Now Inc. Apr 2005 - Nov 2005* Was responsible for architecting & implementing Audit, Balancing & Control system for providing a highly parameterized environment for configuration, execution and restart-ability of ETL jobs. Created data-model for supporting this table driven design in ERWIN. Created Perl & K shell scripts for providing interface from the mainframe scheduler for job-execution.* Helped junior developers with Informatica mappings.* Created highly reusable Informatica design patterns that supported the ETL architecture, including external transformation in C for cleansing data.* Created a table-driven parameterized Perl script for comparing two data sets for finding incremental data sets and for creating slowly changing dimensions for balancing.* Helped with the configuration & administration of Informatica repository.* Technical Environment included Informatica 7.1.2, Sybase, UDB 8.2, SQL, KSH, AIX 5.3, PERL 5.8, ERWIN 4, CDMA for development needs.Client: BP Nov 2005 - Mar 2005* Was responsible for data analysis, implementing ETL data flows using Informatica 7.1; creating mappings/workflows to extract data from SQL Server, Sybase and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting Proof Of Concept for Information Management Architecture Framework project. About 100 mappings were created for sourcing data from Crude Supply Exposure and MOFT systems for use in DIW. * Was responsible for creating mapping documents and contributed to creation of lessons learned documents* The technology environment of the project included: Informatica 7.1, SQL Server, Sybase and Kalido 8.4/1998 - 9/2004: Cap Gemini Telecom Media & Networks, Inc.Client: Swiss Re Apr 2004 - Sep 2004* Implementing ETL data flows using Informatica 6.2; creating mappings/mapplets/workflows/shell scripts etc., for processing various data files coming from the SwissRe clients as per the business rules. Designed the data-hub to include meta-data for auditing and error/exception processing needs. Data sources are Oracle tables, Flat files. I was responsible for integrating the mappings into a workflow engine from eXcellon. It uses XML documents and template files to generate parameter files used in the workflows.* Used Informatica 6.2.1, Oracle 9.2, SQL, TOAD, KSH, Sun Solaris for development needs.Client: Disney Feb 2004 - Mar 2004* Designed a data model for the reporting needs of marketing team at Disney using ERWIN.Client: Time Warner Cable Jan 2004 - Jan 2004* Acted as a technical resource for the evaluation of various CRM tool's technical capabilities. PeopleSoft, Siebel, Chordiant, E.Piphany, Convergys and DST systems were in the play. Created questions/answer/score matrix for evaluation of various features and their relevance to TWC. Created materials for vendor sessions. Client: Time Warner Cable Apr 2002 - Dec 2004* Developed modules that were part of the solution to meet the reporting requirements of finance team for the usage of various Pay Per View and Video On Demand events. Implemented meta-data for auditing and tracking purposes.* Implemented ETL mappings & workflows for Initial and Incremental loads using Informatica versions 5.1 & 6.2 and GoldenGate replication tool.* Helped install Informatica, GoldenGate, DB2 Connect and configuring the network connectivity to various division systems.* Created DDL, PL/SQL, SQL scripts for Oracle database. Oracle DB size was about 1.5TB. Used partitioning and parallel queries.* Created shell scripts for scheduling workflows, checking process sanity. Created reports using SQL Plus and KSH shell scripts.* Was involved in effort estimations, creating work plans, tool selection etc.Client: Sprint Local Feb 2002 - Mar 2002* Conducted a call center assessment to look for potential opportunities to save on operational costs as well as to enhance customer satisfaction, by looking for process and technological change. Responsible for call monitoring, call data analysis and making recommendations based on these for process / technical improvements.Client: Qwest Jun 2001 - Jan 2002* Maintained Interactive agent, a Business-to-Business communications product for exchanging EDI (encoded using ASN.1), XML and plain text data. The product is developed using HP-UX 11.0, C++, RSA Secure Socket Layer library, Standard Template Library. Qwest uses this product for receiving orders from CLECs. Modified the error handling library, compiled and build the application, executed the regression testing suite and verified the result logs and helped package the application for delivery to the client.Client: Lucent Technologies Feb 2000 - Apr 2001* Technical lead of a large team of developers for developing the Operations, Administration and Maintenance module for the base station. Developed work breakdown structure and work schedules for the team. Coordinated with software integration and other development teams.* Provided a high level object oriented design for the system. Used design patterns in the design of the module. Used UML for modeling, documenting and communicating the design of the OAM module.* The base station is being built using PowerPC cards, VxWorks as the RTOS, C++ as programming language; VMEbus, ArcNet and serial buses, SUN workstations/servers as host machines.Client: Lincoln Benefit Life Sep 1999 - Dec 1999* Developed self-help applications to provide various reports and forms through email or fax or snail mail for their customers and agents. This application was developed using InterVoice-Brite interactive voice response unit (VRU), Visual Basic, MAPI, Oracle RDBMS, PL/SQL, SQL, Adobe Acrobat API, Microsoft Exchange Server, RightFax Server and Outlook.Client: Great West Life & Annuity Insurance May 1999 - Jul 1999* Developed a data model for the using Sybase Power Designer for Providers data model. Developed data engineering standards for the client. Provided training and guidance on using the data modeling standards.Client: Qwest (US West) Jun 1998 - Apr 1999* Developed a system integration test plan, data planning for testing the call center application developed around Lucent 5E switches, Nortel DMS switches, Lucent Intuity Conversant Voice Response Units, Sequent NUMAQ servers, HP UNIX and SUN servers for Y2K related issues. The application was developed using Oracle RDBMS, PL/SQL, Pro*C, C++, Unix IPC, JavaScript. * I helped coordinate between various application support teams, worked the issues during testing and automated various repeatable tasks using shell and SQL scripts.1997 - 1998 CITICORP OVERSEAS SOFTWARE LTD, New York.Project: TRIMS System Integration Testing & Support Jun1997 - Apr 1998* Worked with users and testers to develop functions, features and test cases for testing and regression testing the Global Trade System. Managed the development of automated test scripts using SQA Robot and Visual Basic.* As a member of the System Integration testing team, was responsible for putting together front end, middleware and back end servers for the Global Trade System by coordinating the deployment of software and patches from the infrastructure and development teams. Provided various Unix/Oracle scripts for monitoring the system and creating the reports for management. Helped debug various servers.1995 - 1997 CITICORP OVERSEAS SOFTWARE LTD, MumbaiProject: TRIMS Development, Software Feb 1996 - May 1997* Developed back-end servers using C/C++, Pro*C, PL/SQL, Oracle database, Encina Transaction Processing Monitor and DCE. Developed reusable c code, store procedures, and packages for these servers. Designed, developed and documented a module for extracting data from TRIMS systems for sending to the financials data to general ledger system. Shell scripts, SQL scripts, SQL*Loader and various utilities were used to speed up the development process. Used Purify for finding memory leaks and testing boundary conditions.Project: SESAM Development, Software Developer Jun 1995 - Jan 1996* This system is used for security trade recording, settlement matching, custody reporting requirements, and transaction tracking. Prepared program specifications, developed code, unit test plans and tested the units and module.
EDUCATION
MBA, Indian Institute Of Management, Lucknow, India, 1995
Bachelor of Engineering, Punjab Engineering College, Chandigarh, India, 1993
RECENT TRAINING
Informatica Advanced Developer and Administratorn Oracle DBA 10gn Oracle PL/SQL 10g

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in United Kingdom-North Wales »
View all resumes in United Kingdom »

View other ETL / Data Analyst resumes, Programmer / Developer resumes