SIVASHANKARI SHANMUGAM
Email :
acptrv@r.postjobfree.com
Objective
To secure BI Technical Big Data Analyst position that best utilizes my
extensive skills and experience which can be used to create the optimum
technical business solution in the context of the customer's environment,
requirements, and financial resources.
Skills Summary
. Over 12 years of IT experience.
. Actively involved in Implementation Project lifecycle -Requirements
Gathering, Blueprinting, Customization, Configuration, Data
mapping, and Functional Data Validation.
. Strong knowledge in Hadoop Ecosystem, MapReduce, HDFS, Hive, Scoop,
Datameer, EMC Greenplum, Spotfire and Jasper Reports.
. Strong Big Data Solution Architecture & Development experience.
. Proven Experience in handling structured and unstructured data
using Datameer / Hive.
. Excellent working knowledge and understanding of Hadoop
Architecture, Master / Slave Nodes and MapReduce Framework
including Hadoop HDFS, Jobtracker, Tasktracker, Namenode, Datanode
and MapReduce Programming.
. Experienced in defining job flows, importing and exporting Data
into HDFS using Datameer, Hive and Apache Sqoop.
. Analyze and develop Transformation logic for handling large sets of
structured, semi structured and unstructured data using Hive and
Datameer
. Developed transformation workbooks using Datameer from various data
sources
. Exported the transformed code from Datameer to Greenplum.
. Developed HQLs to extract data from source to stage and ODS base
tables in Hadoop HDFS.
. Developed extract HQLs to export the data from hive to Greenplum.
. Developed HQLs to extract PSOL - EID Authentication data from first
party data source.
. Developed HQLs to create data currency of EID Authentication,
Alerts and Order ODS tables.
. Developed Greenplum stage DDLs to read gzip data files exported
from HIVE/Datameer.
. Developed Greenplum DW DDLs and DMLs to load data from stage to
base and curr tables.
. Developed Greenplum SQLs to create aggregate tables from various DW
curr tables for Accounting and Financial Requirements.
. Worked as a SME for reconciling the payment amount difference
between CHASE and PSOL advanced analytics Spotfire payment reports.
. Developed code for bi-weekly Transunion and monthly Experian Roster
Reconciliation logic.
. Proven working knowledge in generating and modifying queries for
Spotfire reports.
. Developed Greenplum extract SQLs to export data in canonical file
formats to ODW.
. Performed weekly & monthly Transunion and Experian Roster
reconciliations to generate ADDs and DELETEs file.
. Expertise in capturing Business Requirements in PDD and prepare
Functional specs and map it to SAP ECC and SAP BOBJ Standard system
functionality.
. Performed GAP Analysis to identify scope of custom Development &
Enhancement.
. Performed Requirements Risk Analysis to forecast Business
criticality and Failure probability.
. SME in SAP ECC Sales and Distribution Module.
. Performed Functional Validation of the SAP ECC Standard & Custom
Reports and Business System Validation Compliance of Client facing
BOBJ Crystal and Web Intelligence Reports.
. Validated Financial and Accounting Reports to be in alignment with
Current Good Manufacturing Process (cGMP) Standards and Practices
per Healthcare Validation Protocol audited by clients.
. Expertise in design and Validation of Regulatory Compliance Reports
for License Verification (State and DEA License Verification) and
Suspicious Order Monitoring.
. Conducted Validation Compliance trainings to IT and Business users
conforming to UPS ALM Methodology and actively involved in creating
SAP ECC, SAP BOBJ End User Procedures.
. Expertise in preparing Business Process Master List (BPML) for SAP
ECC, SAP PI, SAP BOBJ, SAP BW Support Pack Implementation and Pre
and Post Support implementation Validation.
. Proven proficiency coordinating with Development, Functional and
Business teams to generate real-time reports.
. Expertize in generating Standard & Custom Reports to validate Data
integrity between SAP ECC, SAP BOBJ and other interfaces.
. Performed Unit, Functional, Integration, Regression, Performance
Validation of SAP ECC, SAP BOBJ, and Web Order Entry (WOE)
Applications by querying the Databases.
. Expertize in Operational Qualification (OQ) and Performance
Qualification (PQ) Healthcare Validation Protocols.
. Data Validation of various Inbound and Outbound EDI IDoc XMLs (850,
945, 856, 940, 101) to ensure the Data integrity between
interfaces.
. Performed Report Revalidation based on the Defect fixes; execute
queries to check data flow between SAP ECC and BOBJ Universe.
. Proficient in design and development of data warehouse/data marts
using Informatica Power Center/Power Mart. Expert skills in
Repository Manager, Server Manager, Workflow Manager, Workflow
Monitor.
. Strong Knowledge of Data warehousing concepts, Relational Database
Management Systems and Dimensional modeling primarily Star schema
and Snowflake schema.
. Expertise in HQL, SQL, PL/SQL, stored procedures, triggers.
. Proven efficiency working in Agile, Waterfall software
methodologies.
Education
. Bachelor of Engineering, India. Graduated in 2001.
. Completed Training Certifications from Stanford University in Database
Management.
Technical Skills
ERP : Siebel 8.0, SAP ECC 6.0, SAP Solution Manager, SAP TAO,
Manhattan WMS
BI Reporting Tools : TIBCO Spotfire 6.5.0, Jasper Reports, Tableau 8.2,
SAP BOBJ 4.0, Crystal Reports, SSRS Reports, OBIEE
ETL Tools : CDH (Cloudera Distribution including Apache Hadoop) 5.1.2,
Hadoop 2.3.0, Hive-0.12.0, Hue3.6.0, Datameer 4.5.8,
Sqoop, Informatica Power Center 8.x,7.1.2/6.2/5.1/1.7, SAP
BO Data Integrator
RDBMS : Oracle 11g/10g/9.x/8.x, EMC Greenplum DB 4.2.7.2 build,
PostgreSQL 8.2.15
DB Tools : pgAdmin, Aginity Workbench 4.4, Toad, SQL Developer
Languages : PL/SQL, SQL, C, C++, Java, MapReduce, UNIX shell
scripting
Methodologies : Ralph Kimball's Star Schema and Snowflake Schema
Operating System : Linux, UNIX, AIX, Windows NT/95/98/2000/XP
Office Applications : MS-Office 97/2000/2003/2010/2013
Management Tracking
Tools : Rally, Confluence, Serena Business Manager, Jira, Bugzilla,
UPerform, iRise, HP Suite of Tools
Industry Experience
As a BI Technical Big Data Analyst, my responsibilities include Data
migration from existing source systems to Big Data Advanced Analytics
Platform which involves Collection, manipulation and Data Analysis. Have a
thorough understanding of relationships between organization's various
databases which involves extracting information from source databases using
complex query statements and advanced database tools and loading into HDFS,
Greenplum and create Reports.
- ODW PSOL Advanced Analytics Data Warehouse SME
- Worked as a SAP-SD SME for Global HealthCare Office Services.
- Responsible for reviewing and ensuring project deliverables with
respect to Data quality and timelines.
Project Details
1. Project Name: PSOL Advanced Analytics & Operational Data Warehouse
(ODW)
Client: Equifax INC
Description of the project:
The main scope of this project is to maintain the CFPB compliance for all
Equifax active and inactive US consumers, by developing an internal audit
system built on latest Big data technologies and real time Reports on large
and sensitive Financial Data sets (including PII information) to monitor
and perform Daily Reconciliations for 1st Party Equifax Data and 3rd Party
Data from other Credit monitoring Bureau's like Transunion and Experian.
This includes building Data warehouse on a Big Data platform (Cloudera
Hadoop distribution and EMC Greenplum) and develop daily automated Feed for
PSOL EID Authentication events, PSOL consumer Alerts, Transunion, Experian
Roster and Partner Customers monitored by Equifax on their behalf. This
involves consolidation of consumer Data from multiple sources to HDFS. Main
objective of the project is to enhance business ability to quickly assess
and make decision on current and futuristic data and maintain CFPB
compliance. This project is highly focused to leverage PSOL Advanced
Analytics capabilities and migration of existing data from Siebel OBIEE
platform - Financial, Accounting, Call Center, CFPB Security reports to new
Big Data platform and generate Daily automated Canonical Feeds from
Greenplum to integrated ODW audit system.
Role: BI Technical Data Analyst
Responsibility: Requirement Analysis, Functional & Technical
Specifications, Estimation & Implementation, Customization & Configuration,
Business Demos, End User Training, Project delivery, Production
Deployments,, Validation of Financial and Accounting reports.
Duration: June 2014 - Till Date
Environment: CDH (Cloudera Distribution including Apache Hadoop) 5.1.2,
Hadoop 2.3.0, Hive-0.12.0, Hue3.6.0, Datameer 4.5.8, Sqoop, EMC Greenplum,
Java, Linux, TIBCO Spotfire 6.5.0, Tableau 8.2, Jasper Reports, Confluence,
Rally, Jira, Informatica Power Center 8.6, Informatica Data Quality, OBIEE,
Oracle 11g, Toad, Linux, Tivoli Job Scheduler, Shell scripting, Aginity,
pgAdmin III, sqldeveloper
2. Project Name: Controlled Substance Ordering System (CSOS)
Implementation
Client: UPS Supply Chain Solutions
Description of the project:
This is a Controlled Substance Ordering System Project to support UPS
3PL Business capability to handle Drug Enforcement Administration (DEA)
approved Controlled substances via EDI in addition to Manual entry process.
DEA Form 222 to purchase or transfer Class 2, Class 3, Class 4, Class5
Controlled substances legally is implemented per the standards for
documents received electronically. Form 222 Number and Issue date are
captured in EDI Sales Order for Controlled Substances to maintain the
validity period. Develop Custom Order Status Report (Not released) to
include Form 222 information for Operations & Business.
Role: SAP SD Business System Validation (BSV) Analyst
Responsibility: Requirement Analysis, Functional & Technical
Specifications, Estimation & Implementation, Customization & Configuration,
Business Demos, End User Training, Project delivery, Production
Deployments, Reports Verification and Validation.
Duration: Dec 2013 - Jun 2014
Environment: SAP ECC 6.0, SAP BOBJ 4.0, Crystal Reports UPerform, SAP
Solution Manager, SAP TAO, iRise, HP Suite of Tools, Java, Serena Business
Manager, SSRS
3. Project Name: European Global Template implementation
Client: UPS Supply Chain Solutions
Description of the project:
This is an Implementation Project to extend the SAP ECC Order to Cash for
UPS Healthcare European Clients. The Business objective of this project is
to provide integrated global order management capabilities, License
Verification, Suspicious Order Monitoring (SOM), Global Inventory
Management of Healthcare Products, Integrated Global Contract and Pricing
management, Account Receivables, Billing, Invoicing, Tax calculation,
Collections and Warehouse Movements, Inventory Transactions and Shipment
for European Healthcare Clients.
Role: SAP SD Business System Validation (BSV) Analyst
Responsibility: Requirement Analysis, Functional & Technical
Specifications, Estimation & Implementation, Customization & Configuration,
Business Demos, End User Training, Project delivery, Production
Deployments, Reports Verification and Validation.
Duration: Jun 2013 - Dec 2013
Environment: SAP ECC 6.0, SAP BOBJ 4.0, Crystal Reports UPerform, SAP
Solution Manager, SAP TAO, iRise HP ALM 11, Java, Serena Business Manager
4. Project Name: Canadian Global Template for Order to Cash
Client: UPS Supply Chain Solutions
Description of the project:
This is an Implementation Project to extend the SAP ECC Order to Cash for
UPS Healthcare Canadian Clients. The Business objective of this project is
to provide integrated global order management capabilities, License
Verification, Suspicious Order Monitoring, Global Inventory Management of
Healthcare Products, Integrated Global Contract and Pricing management,
Account Receivables, Billing, Invoicing, Tax calculation, Collections and
Warehouse Movements, Inventory Transactions and Shipment for Canadian
Healthcare Clients.
Role: SAP SD Business System Validation (BSV) Analyst
Responsibility: Requirement Analysis, Functional & Technical
Specifications, Estimation & Implementation, Customization & Configuration,
Business Demos, End User Training, Project delivery, Production
Deployments, Reports Verification and Validation.
Duration: Feb 2013 - Jun 2013
Environment: SAP ECC 6.0, SAP BOBJ 4.0, Crystal Reports UPerform, SAP
Solution Manager, SAP TAO, iRise, HP Suite of Tools, Java, Serena Business
Manager, Vistex, Vertex
5. Project Name: Order Processing for Controlled Substances & Warehouse
Report for Returns
Client: UPS Supply Chain Solutions
Description of the project:
This is a Controlled Substances Order Processing Implementation Project to
support the UPS 3PL Business capability to handle Drug Enforcement
Administration (DEA) Logistics. Process of utilizing DEA Form 222 to
purchase or transfer Class 2, Class 3, Class 4, Class5 Controlled
substances legally is implemented as per the standards. Form 222 Number and
Issue date is captured in the Sales Order for the Controlled Substances to
maintain the validity period. Custom Order Status Report - Not released is
developed to include the Form 222 information.
Role: SAP SD Business System Validation (BSV) Analyst
Responsibility: Requirement Analysis, Functional & Technical
Specifications, Estimation & Implementation, Customization & Configuration,
Business Demos, End User Training, Project delivery, Production
Deployments, Reports Verification and Validation.
Duration: Nov 2012 - Feb 2013
Environment: SAP ECC 6.0, SAP BOBJ 4.0, Java, Crystal Reports UPerform, SAP
Solution Manager, SAP TAO, iRise, HP Suite of Tools, Serena Business
Manager, SSRS
6. Project Name: Client Support Model 3
Client: UPS Supply Chain Solutions
Description of the project: This is a Client Support Model 3 Implementation
Project to support Sales Order Processing through Manual and via EDI.
Inbound EDI 940 (Sales Order creation in GHOS SAP), EDI 855 Outbound (Order
Acknowledgement to Client), EDI 856 Outbound Advance Shipping Notification
to Customer and Warehouse Shipping Advice (WSH) to the client has been
implemented to support the existing and New clients Business Requirements.
Develop Crystal and Web Intelligence BOBJ Reports.
Role: SAP SD Business System Validation (BSV) Analyst
Responsibility: Requirement Analysis, Functional & Technical
Specifications, Estimation & Implementation, Customization & Configuration,
Business Demos, End User Training, Project delivery, Production
Deployments, Reports Verification and Validation.
Duration: Mar 2012 - Nov 2012
Environment: SAP ECC 6.0, SAP BOBJ 4.0, Crystal Reports UPerform, Manhattan
WMS, SAP Solution Manager, SAP TAO, iRise, Java, HP Suite of Tools and
Serena Business Manager.
7. Project Name: UPS SCS SAP ECC GHOS Model 4 Implementation
Client: UPS Supply Chain Solutions
Description of the project: This project is a Green field Implementation of
SAP ECC - Order-To-Cash (OTC) for UPS Healthcare clients. This project is
developed to enhance the global capabilities of the current Logistics
Management System (LMS) to support the Order to Cash (OTC) for Global Multi
National Logistics Partners. The Business objective of this project is to
provide integrated global order management capabilities, Web-based order
entry of healthcare orders for new and existing global healthcare clients
and their customers, Licensure Verification (LV) and Suspicious Order
Monitoring (SOM), Integrated global inventory management of healthcare
product, Integrated global contract/pricing management, Integrated global
back office functionalities which include Accounts Receivable, Billing,
Invoicing, Tax calculation, Collections and Chargebacks. Integrated end to
end web order visibility and Reporting allowing Operations, global
healthcare clients and their customers to view warehouse movements,
inventory transactions, shipments and proof of delivery. Support industry
standard supply chain business messaging via appropriate technologies &
formats between UPS (3PL) & Global Healthcare clients and their customers
to enable global commerce in a FDA Regulated Validated Environment adhering
to the Validation standards.
Role: SAP SD Business System Validation (BSV) Analyst
Responsibility: Requirement Analysis, Functional & Technical
Specifications, Estimation & Implementation, Customization & Configuration,
Business Demos, End User Training, Project delivery, Production
Deployments, Reports Verification and Validation.
Duration: May 2011 - Feb 2012
Environment: SAP ECC 6.0, SAP BOBJ 4.0, Crystal Reports UPerform, SAP
Solution Manager and TAO, iRise, HP Suite of Tools, Java, Serena Business
Manager, Vertex
8. Project: Knowledgebase Marketing Bellsouth
Client: KBM Group
Project Description:
Knowledge Base Marketing helps direct marketers find, know, keep and grow
profitable customers. KBM provides the data, tools and direct marketing
expertise to help find right prospects and turn them into loyal customers.
Some of the most successful companies in the healthcare, insurance,
financial, telecommunication, and consumer product industries are
partnering with KBM to market more effectively. This Project involves
development of Data Mart for Bellsouth using complex Informatica Maps and
OBIEE Reports.
Role: ETL Developer
Responsibility:
. Extensively worked on ETL using Repository Manager, Designer, Workflow
Manager, Workflow Monitor Tools developing various Transformations -
Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored
Procedure transformations, Configured and ran the Debugger in Mapping
Designer for troubleshooting mapping before the workflow execution.
. Worked with Web Log Expert to do analysis of data produced from the
Internet for management to review and schedule Informatica and Teradata
jobs using TNG Scheduling software.
Duration: May 2009 - Jun 2010
Environment: Informatica PowerCenter 7.1, Oracle 9i, Toad, DB2, WebLog
Expert, Teradata V2R5, T-Pump, Lotus notes, MS Office, Windows XP, Oracle
10g (RAC), VSS, Sub Version
Project: Auto Loan Data Mart
Client: Triad Financials
Project Description:
Triad Financial is a major national Auto Financing Company with two
regional centers in Texas and California. With relationships with over
5,000 automobile dealerships, approximately 300,000 borrower-customers, and
the financial strength of nearly $4 billion in managed receivables. The
project involved creating a Data-Warehouse for Application Process for an
auto loan. The business logic was pulled from business users as well as the
logic defined in SQL Server stored procedures. It has all the information
about the Borrower and the Vehicle.
Role: ETL Developer
Responsibility: Requirement gathering, Analysis, Develop transformation
logic, complex mappings for various Facts and Dimensions, create and
schedule Workflows based on demand, run on time, run only once using
Informatica Workflow Manager, create Database connection sessions to run
the mappings, Document DataMart ETL process, Wrapped the sessions with pre-
session and post-session shell scripts, Scheduled batches for daily data
load.
Duration: Sep 2007 - Apr 2009
Environment: AIX, Windows 2000, Informatica PowerCenter 7.1, Oracle 9i,
Toad, DB2, Teradata, Sql Assistant, Windows 2000, Business Objects 6.1
9. Project: cCorporate Financials
Client: Franklin Templeton Investments
Project Description: Franklin Templeton Investments is a global investment
management organization with offices around the world and offers investment
solutions under the Franklin, Templeton, Mutual Series, Bissett, Fiduciary
Trust and Darby Overseas names in more than 100 countries. The project team
cCorporate Financials is involved in building Data Warehouse for measuring
Fund Profitability. Flat file Data from Mainframes is pulled and dumped
into ODS using Informatica 5.1.From Oracle ODS, data is loaded to ODE and
to Data-Mart using DataStage Acential. COGNOS Reports are developed for
Business users.
Role: ETL Developer
Responsibility: Requirement capturing, Develop Source and target Mapping,
Mapplets, reusable Transformations, Design extract transformation & loading
strategy based on source Data, Performance tuning of complex maps having
multiple Lookups and Target tables, extensively worked on various
transformations.
Duration: Jan 2006 - Aug 2007
Environment: Informatica PowerCenter 5.1, Oracle 9i, PeopleSoft, UNIX,
COGNOS 7.0
10. Project: WellPoint life Insurance Data Warehouse
Client: WellPoint Health Networks
Project Description:
As part of Nation's leading Healthcare Benefits Company, WellPoint provides
life insurance, healthcare benefit, pharmacy benefits, dental and vision
benefits plan. This Project involved developing a Data Warehouse for life
insurance customers having different health insurance policies. Data was
first extracted to flat files from the claims processing system and loaded
to staging area after applying necessary transformations. The mapping logic
was based on application logic previously developed in Visual Basic.
Staging area was maintained in DB2 and data populated into Facts and
Dimensions of the EDW using Informatica-Power Center 5.1.
Role: Informatica Developer
Responsibility: Requirement analysis, Design and develop Informatica Source
and Target mappings, Analyze Source and Target Schema, Perform in depth
Data Analysis, identify nuances in claims submitted by various providers,
Mapping and Workflow Documentation.
Duration: Mar 2003 - Dec 2005
Environment: UNIX, Windows 2000, Informatica Power Center 5.1, DB2 UDB 7.2,
Visual Basic, Oracle 9i, Teradata, Toad 6.3, Cogno