PROFILE:

Overall 12 years of extensive IT experience in DWBI application segment while implementing ETL solution for multiple data warehouse initiatives over Relational Databases and Big Data platforms. Looking forward to perform a challenging position under Data Engineering arena by utilizing my data analysis skill and diversified domain knowledge in Retail, HR, Healthcare, Energy, Finance and Insurance industries.

SUMMARY:

• 10+ years of proficiency in implementing Data Warehouse and Data Migration projects as an ETL Architect while integrating heterogeneous data sources like RDBMS, Hadoop, Cloud, Mainframe etc., extracting/loading huge volume data, handling real time scenario.
• 12 years of ETL expertise having specialization in Confidential InfoSphere DataStage for more than 10 years and 1 year of experience in SAP BODI.
• Broad understanding on both Entity - Relationship model and Dimensional model using Data modelling tools like Erwin and SQL data modeler.
• Excellent experience in writing SQL queries and PL/SQL procedures in Oracle and worked on few other RDBMS like DB2, Netezza, Teradata and SQL Server under MPP environment.
• Working knowledge in Big Data technologies through Hadoop eco system, Map-Reduce, Hive and Sqoop.
• Expertise in writing Unix Shell, Python scripts, XSLT and familiar with Perl script.
• Conversant with SDLC following both Waterfall and Agile method using tools like Jira and RTC.
• Familiar with NoSQL database like MongoDB
• Basic knowledge about BI reporting tools like SAP Business Objects.
• Experience in Job Scheduling mechanism using Control-M, Autosys and Crontab.
• Expertise in using Workday Web Services, EIB and Core Connector.
• Conducted data profiling and standardization using Information Analyzer and QualityStage.
• Experience in HPQC, ClearQuest and BMC Remedy for testing activity and defect management.
• Knowledgeable about production release process, incident management and code version control.
• Insight about different SAP modules and familiar with data load mechanisms like LSMW, IDoc etc.
• Contributed in Project Estimation process through BI Widget Model and Solutioning for new proposal through BI Architecture.
• Familiar with Project Management activities like preparing Project Plan, Capacity Plan, Audit report, Delivery Metrics, Release Plan and Project kick-off/closure related activities.
• Excellent Client interaction background and aptitude in leading geographically dispersed offshore team from India, Philippines and Mexico.

TECHNICAL SKILLS:

ETL Tools: DataStage v 11.5/9.1/8.5/8.1/7.5 , BODI v11.7, FastTrack

Big Data: Hadoop, Map-Reduce, HDFS, Hive, Sqoop, NoSQL like MongoDB

Databases: Oracle 11g/12c, Confidential DB2, Netezza, Teradata, SQL Server

Data Modeling Tools: Erwin, SQL Data Modeler

Cloud: Workday, Microsoft Azure

Agile Tools: Jira, Rational Team Concert

Reporting Tools: Business Objects

Version Control: ChangeMan, GIT, Rational ClearCase, Confidential Urban Code

Scheduling Tools: Control-M, Autosys

Profiling Tools: QualityStage, Information Analyzer

Platforms: Windows 7/XP, Linux, AIX

Languages: SQL, Unix Shell scripting, Python, XSLT

Other tools: Toad, SQL Developer, Squirrel, MS Visio, Splunk, Soap UI, HPQCRational ClearQuest, SQL Assistant, SAP

PROFESSIONSAL EXPERIENCE:

Confidential

Advisory System Analyst

Responsibilities:

• Contributed in requirement gathering, providing estimates and designing overall architecture.
• Documented technical design and source-to-target mapping to translate the business logic.
• Designed and developed Reusable jobs to extract data from different geographies, to extract from Cloud using Web Service, XML parsing, change-data-capture, load to Oracle/Netezza/DB2.
• Implemented real time and near real time DataStage jobs in Ecommerce area.
• Tuned queries and apply job partition technique to optimize the execution window for daily cycle.
• Developed normal/materialized views and written Shell/Python scripts and understanding of Perl.
• Advised on the sizing/partition/index of target DB after estimating the volume growth of data.
• Prepared Python script to load data into Hadoop, used Sqoop to connect RDBMS data to Hadoop, built Hive tables.
• Built Control-m jobs to automate the schedule daily/monthly/bi-weekly including mail notification.
• Analyzed Workday Object-Oriented structure to build the logical data model.
• Designed audit mechanism for Workday API and exception handling framework for ETL.
• Created integration to extract data from Workday Cloud via Soap/Rest Web service call and written XSLT for parsing XML file.
• Researched legacy system to spot data anomaly for same attributes using Information Analyzer.
• Built/Modified Metadata using Confidential Fast Track as per the Technical Specification requirements.
• Generated Data Lineage Report using InfoSphere Metadata Workbench tool.
• Taken leadership in release activity like code synch up, migration and versioning.
• Managed and mentored big team (16 members) including both offshore and onshore developers.
• Migrated existing jobs from DS v9.1 to v11.5 and performed dry runs to verify the ETL processes.
• Involved in creation of logical nodes in configuration file and user defined environment variables.
• Have used Quality Stage to investigate, pattern matching and standardize the customer data.
• Contributed in data loading into SAP through LSMW framework using IDoc and batch method.
• Performed the Datastage admin work for killing the Process, removing locks and installing the patch work on the Datastage server, assigned the roles to Users for different environments.

Confidential

ETL Consultant

Responsibilities:

• Designed Snowflake schema, aggregated fact, Type1/Type2 dimension etc. to support drill-down functionality in reports and created PDM using Erwin to set up the data marts.
• Developed jobs in BODI to convert PL/SQL procedure and automate the scheduling.
• Assisted reporting team to write queries and remove cardinality in Business Object Universe.
• Involved in modifying report variables, prompts etc. of BO report and Xcelsius dashboard.
• Built Parallel Routine and shared container to implement generic functionality across project.
• Designed job for transforming and loading the multiple occurrences from COBOL Copybook.
• Developed job using Java Stage to call Jar files while converting Mainframes code to ETL without changing Java object and Java Transformer Stage to Load the blob-data into DB.
• Designed Jobs involving Complex Flat File (CFF) Stage to extract Data from Mainframes containing complex data structures such as arrays, groups, and redefines etc.
• Familiar with handling Huge data in various kinds of formats like EBCDIC/BINARY, Variable length of records, Unusual characters, Unstructured file handling with external source.
• Prepared Jil scripts in Autosys for scheduling job, execution of the same from AUTOSYS