SUMMARY:

• An accomplished data warehouse expert and team lead with 15 yrs of strong experience in ETL, data modeling, data base scripting, UNIX scripting and 1.5 yr in big data technologies. 10 Yrs of extensive experience in Insurance industry, I have demonstrated ability to bring teams together to design and deliver successful data warehouses. I have very strong experience in requirements gathering, engineering, design, development, testing, and system maintenance. Provide 24/7 Production support, worked thru countless nights and weekends for the past 10 yrs on critical production issues and Project Implementations
• I am a self - starter and have led several product analysis and prototyping initiatives. 1.5 year of Hadoop Big Data experience Led Confidential ’s very first big data project (prototyping). Handpicked by the department head to participate in this effort. I have demonstrated experience in supporting complex and very large ETL environment. I have work experience in delivering multiple projects simultaneously and natural ability in managing conflicting priorities. I have strong team management and project planning skills. I have consistent track record of delivering high quality products within planned time frame for many business areas in Confidential . Currently working on Implementing Big Data Solutions for Confidential and Confidential transforming the redesigning ETL Informatica platform into Hadoop
• Hands-on experience in planning, designing and building enterprise wide Corporate Data Warehouses from scratch. Played the role of chief ETL architect in designing ETL architecture for a 14TB data warehouse
• 15 years of DataWarehousing experience with 10 yrs working with IBM Information Server Datastage 9.1/8.7/8.0/7.5 and 5 yrs in Informatica Power Center and Mart.
• Strong experience in Information Analyzer, Business Glossary (Data Dictionary) and Metadata Workbench
• Expertise in analyzing business requirements and translating requirements into functional and technical ETL design specifications
• Led several product capability analysis including IBM Information Analyzer, Business Glossary
• Experience in fine tuning ETL batch performance to meet customer SLAs
• Provide 24/7 Production support, worked thru countless nights and weekends for the past 10 yrs on critical production issues and Project Implementations.
• Established standard procedures and practices in my team
• Excellent technical and analytical skills with clear understanding of ETL design and architecture based on reporting requirements
• Good experience in creating interface mappings from DM to Siebel and OLTP environments.
• 15 years of Oracle database programming, and UNIX scripting experience
• Have experience in relational databases - Oracle 11 g/10g/9.i/8 with a sound knowledge of SQL and Oracle PL/SQL
• Extensive experience in Unix Shell scripting.
• Have strong experience in data modeling
• 1.5 year of Hadoop Big Data experience. Currently leading Confidential ’s very first big data project (prototyping). Handpicked by the department head to participate in this effort.
• Strong knowledge and hands on experience in Hadoop ecosystems(Cloudera and Hortonworks), HDFS, PIG, Hive,Impala,Flume, Sqoop, HBase.
• Integrated Hadoop with Various data visualization tools such as Tableau, Spotfire, Map R and SAS.
• Conducted several POCs on Big Data and demonstrated to management and various business groups
• Created Data Lake in Hadoop for various reporting and analytical purpose.
• Implemented Cloudera solutions for Cognos Audit reporting at Confidential and Confidential (using Flume,Sqoop, Impala and Oozie).
• Experience in data cleansing and data mining.
• Capturing data from existing databases that provide SQL interfaces using Sqoop.
• Strong team leadership, and interpersonal skills
• Creative thinker and strong problem solving skills
• Very reliable and have high work ethic
• Experience in mentoring junior team members for many years
• Self-starter and takes initiative that benefits the company
• Constantly learning and leveraging emerging technologies
• Experience in working with offshore teams
• Strong experience in management presentation and ability to interact with users at ease
• Won many client s at Confidential

TECHNICAL SKILLS:

Databases: Oracle 11g / 10 g / 9.2 / 8i, SQL Server 7.0, Dbase, MS

Access: Data modeling Tool

ERwin 3.5, 4.1: Data Warehouse Tools IBM Information Server Datastage 9.1/8.7/8.5/8.0/7.5 : Business Glossary

Information Analyzer: Metadata Workbench Informatica Power Center 5.1/6.2/7.1/9.1 : Informatica Power Mart 4.7/5.1/6.2/7.1

Big Data Tools: Apache Hadoop HDFS, Pig Latin, Hive, Sqoop, HBase, Hortonworks HDP2, Cloudera CDH5, Impala, Flume, Oozie

Reporting Tools: Business Objects, Cognos

Languages: SQL, PL/SQL, C, HTML, COBOL, UNIX /Linux Scripting

Application Development: Visual Basic

Operating Systems: UNIX, Windows NT,Linux RHEL

PROFESSIONAL EXPERIENCE:

Confidential

Senior solution architect

Responsibilities:

• Cognos Audit report: Confidential and Confidential being huge infrastructure hosting over 200 servers just for Cognos providing service for over 45,000 report users, The data on report usage is being captured on 5 different servers and 32 different databases. This data is currently being brought together transformed for reporting using Informatica, loading into 385 sql server tables, feeding the Cognos report. This caused delay on several layers, Informatica outage, performance issues due to volume and data issues due to complexity. These issues were resolved using Cloudera Big data solutions. Using sqoop, the data was pumped and using Impala data from 385 tables were consolidated into 12 which tremendously eased the performance and complexity issues.
• Informatica jobs that used to run for hours loading the 385 tables is now being loaded in minutes using Cloudera Hadoop. The changes at the data layer are seamless to the existing reports, so no changes were required at the reporting level.

Confidential

Development and Support Lead

Responsibilities:

• I am working in Corporate Confidential at Confidential as ETL Tech Lead, Team Lead, and Data Engineer over the last ten years. I have a track record of consistently outperforming management expectations. I have worked on various critical project initiatives and supported the data warehouse environment. As a lead ETL architect/team lead of the 14 TB corporate data warehouse, I provide technical leadership to my team in project planning, establishing standards, ETL design, development, testing, and deployment. In addition, I also have administered various DW tools and systems. I support over 600 batches. Co-ordinate different teams during server migrations or
• Oracle Upgrades, which includes scheduling, Database Engineers,ETL developers to ease the migration and have the cycles run with minimum impact to customers.I have had the opportunity to mentor and train junior members of my team. I provide technical mentorship to developers in the areas of Contract, SalesMart, Rightbridge, NB21, Calc, ALO. I assist other developers with their code, data or performance issues. In addition, I am responsible for Information Analyzer administration, installation and testing of software and patches, communication of systems issues and follow-up with IBM, if necessary. I have strong experience in DR planning and execution. I was handpicked by my department head to lead the new game changing Big Data initiative, first in Confidential .
• I have been responsible for Contract DW, a huge and complicated subject area, for the last 10 years. It holds several tables with hundreds of millions of records. The high volume, data complexity and visibility of the reporting added additional challenges. The DW holds Contract, Product, Underwriting and Policy information. My role involves in managing the ETL loads, assigning appropriate resource for new requirements, co-ordinate with the analyst, DBA groups for on time project delivery, maintenance, performance of the cycles, production issues, and problem logs. I am the go to person when it comes to all of the above.
• This requirement was for Stephanie Schiller to flatten the client information for Confidential . The data was sourced from 20 different high volume tables and flattened into 1 structure to ease the reporting needs of the customer. This has been really challenging due to volume and complexity. More than 40 million data from main source and several other millions were flattened at the contract level. Designed and coded effectively that this process runs in minutes. The customer was very happy and satisfied with the end result which was initially considered impossible.

Confidential, NY

Senior Consultant

Responsibilities:

• A data warehouse was developed to perform advanced customer data analysis to help offer better service and recommend new offerings based on customer needs. Customer data was collected from different systems and aggregated within the data warehouse. As the ETL lead I was responsible for source system analysis, development and testing. I was also responsible for Informatica server administration. I managed a group of consultants and client developers. The data warehouse was 4 TB in size.

Technology: Oracle 9.2, Informatica Power Center 6.2 / 7.0, UNIX, Microstrategy

Confidential

Lead - Data Warehouse Implementation

Responsibilities:

• The objective was to create a data warehouse to support corporate reporting needs. The data warehouse was populated with data from customer management, campaign management and marketing systems. As the technical lead I was responsible for interface development and moving data out of Siebel. I have about 4 months of intense development experience of interface mappings from Data Mart to Siebel and OLTP databases.

Technology: Oracle 8i, Informatica Power Center 5.1 / 6.2, UNIX, Business Objects

Confidential

ETL Architect - ETL Re-architecture

Responsibilities:

• The objective of the project is to change all the existing PL/SQL coding to Informatica Mappings and Sessions. The existing system has become unusable because of the complexity of the coding and maintenance issues. I worked on the design of the new system.

Confidential

Senior Developer

Responsibilities:

• Client is one of the biggest retail stores in Singapore. They have multiple custom developed applications to manage Customer, Product, and Sales information. The objective of the project is to bring the information to the data warehouse database. Used Erwin to create Logical and Physical data modeling. Created fact and dimension tables. Designed and created Mappings using Informatica Powermart to load fact and dimension tables.

Technology: Oracle 8i, SQL Server 7.0, Informatica Power mart 4.7/5.1, Erwin, UNIX, Business Objects

Confidential

ETL Programmer

Responsibilities:

• The objective of the project is to create reporting database to bring data from different customer, accounts databases and build a data mart. The client is one of the biggest banks in India. The challenge was to bring the customer information from several proprietary databases and build the data mart. Data Cleaning and Data normalizing was done across databases. Informatica Powermart was used to integrate these data and bring to a reporting database. Customer and account information was extracted from different databases. We brought the customer details, customer category and geographic location and other customer related information.

Technology: Oracle 8i, 7.3, Informatica Powermart, ERWin,UNIX, Discoverer

Confidential

Developer

Responsibilities:

• The major business of the client is to sell circuits that are pre-packaged. The challenge was to integrate two different systems and create the data warehouse with main focus on the sales information. Used Informatica to bring these 2 data into a single system and reports were generated from there. I created Informatica sessions and batches. Used repository manager to create users and create repository and folder structures. I helped other junior developers to create ETL mappings.

Technology: Oracle 8i, SQL Server 2000, Sybase, Informatica Powermart, UNIX, ERWin

Confidential

Application Programmer

Responsibilities:

• The project is to develop an Confidential that includes general ledger, accounts receivable and accounts payable modules. Visual Basic was used as front end with Oracle database back end in Windows environment. This was a three-tier application with all the business logic stored in the backend procedures. Created Front end screens using Visual Basic and wrote Oracle stored procedures, functions, Packages and Database Triggers.

Technology: Oracle 7.3, Visual Basic, UNIX, Windows, crystal reports