SUMMARY:

• Analytical, highly - skilled IT specialist with 17 years ‘plus experience in ERP, Data warehousing, ETL Design and development, Data Engineering, Data Analysis, Data Architecture, Dimensional (Ralph Kimball) and Relational Data Modelling and 2 years’ experience in Big Data and Hadoop Stack (HDFS, Spark, Map Reduce, HBase, Hive(HQL), Pig, Sqoop etc) on Cloudera CDH and Hortonworks HDP platforms.
• Broad knowledge in Informatica Development, design, architecture, and guiding professional teams to continued high performance.
• Strong technical acumen in the BI and Data Warehouse project life cycle. Certified in advanced Teradata and Oracle applications and proficient in Data Science.
• Proven track record in Business Objects and Enterprise Resource Planning in the car manufacturing and oil industries. Sophisticated business traveller servicing international clients.
• Developed Machine learning models using Spark Mllib(Databricks) libraries (Linear and Logistic Regression), Python (NumPy, Pandas, Matplotlib and SciPy) (Linear regression,Classification,Clustering etc)
• Implemented and migrated data sets applying Erwin data modeling tool from SQL Server 2008 to Teradata for Confidential
• Built Product report card Data Mart for Confidential, USA, allowing business users to generate product life cycle reports.
• Masterminded a safety information star schema DataMart for the group safety division of Confidential, Dubai.
• Received Bravo Award from IBM for outstanding performance towards BI and DWH technical support to clientele.
• Developed Teradata FSLDM data prototype for AML subject area in the EDW for the Royal Bank of Scotland.

SKILLS:

Data Architect/Data Modeler/Data Integration Architect/Data Engineer(Big Data)/Data Scientist

OLAP/ERP/Hadoop/SQL/PL - SQL/HiveQL

Data Modelling(Erwin) /Claims/Data Integration/Data Warehouse/Data Governance

Business Intelligence (BI)/Informatica PowerCenter & Big Data Management(BDM 10.2.1)/Big Data Edition 9.x

Teradata Certified Professional

Machine Learning/ETL/Data Mart

Informatica Certified Developer

Front End/Optimization

Star Schema/Big Data/Python

Life Cycle (SDLC)/Data Analysis

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect/Data Modeler/Data Engineer

Technical Scope: Erwin Data Modeler, Talend Open Studio for Big Data, DB Visualizer, Salesforce, IBM DB2, Jira, Confluence, MS Office, Agile (Scrum),Hive QL,sqoop,Cloudera Hadoop (HDFS & Map Reduce)

Responsibilities:

• Requirements gathering and analysis, designing logical and physical data models, Data Ingestion into Hadoop Data lake, Creation/Maintenance of data dictionary, IDC Sheet for Data Lake, Interfacing with different project stakeholders for design review and approval as per process.

Confidential

Application Development Associate Manager

Technical Scope: Oracle Data Integrator 12c, Oracle 12c, SQL, PL/SQL, MS Visio, MS Excel, MS Word, MS Power BI, Hadoop (HDFS & Map Reduce), Hive QL, Sqoop, Informatica BDM 10.1, SQL Server V17.4(T-SQL),SSIS(ETL), Salesforce Data Loader

Responsibilities:

• Performed in Application Development Management for various clients at a worldwide professional services corporation, providing a broad range of services and solutions in strategy, consulting, digital, technology, and operations.
• Serving as a Data Lead/Architect in driving Data Migration requirements, defining scope for objects in migration, assist in data mapping exercise, writing sql queries using T-SQL to extract data from source to be loaded into Sales force CRM on cloud.
• Serve as an ODI ETL Architect in the development of Source to Target Mapping documents in Excel, Technical Design files in Word, and data flow diagrams in Visio. Execute reverse engineering of current Oracle Packages and Stored Procedures in existing middleware schemas in oracle 12C database.
• Engage and plan with the company’s global ODI Development unit.
• Spearhead DBA tasks such as establishing users for the development division and allowing authorization in the Oracle application.
• Orchestrate as a Business Analyst and BI Architect in the Finance department.
• Assemble and construct dashboards displaying multiple Key Performance Indicators (KPI), trends, and patterns for various industries, employing Microsoft Power BI.
• Corresponded with the vendor unit regarding logistics for upstream and downstream applications.
• Guided the data ingestion process into data lake on Hadoop platform and examined data utilizing SQL queries and Hive QL.

Confidential

ETL Designer/Developer

Technical Scope: Oracle 12c, Informatica Big data Edition(BDE) 9.x SQL Developer,Hadoop,HDFS,Hive,SQOOP

Responsibilities:

• Anchored in Data Analysis and Extract, Transform, and Load Designing on a contract basis for an international provider of innovative staffing solutions and services.
• Reported Enterprise Data Warehouse (EDW) prerequisites prepared by business analysts and administered intricate study of the established requirements.
• Engineered ETL design and oversaw the design review process including final approval from the Solution Architect.
• Architected the ETL specifications manual and performed data analysis of the source system.

Confidential

Senior Data Architect/ Data Modeler/ETL Designer

Technical Scope: Teradata FSLDM, MS Office (Word, Excel, PowerPoint, Outlook), Informatica Power centre

Responsibilities:

• Managed Data Architecture and ETL Designing services for various institutions on behalf of an international IT, Digital Services, and Business Solutions firm.
• Expedited data analysis and modified ETL specification records for prerequisites and design.
• Developed Teradata FSLDM data prototype using Erwin for AML subject area in the EDW empowering the bank to track and document AML related metrics and KPI’s to control and prevent money laundering.
• Liaised with the ETL Development supervisor globally to launch ETL specification (Source to target mapping) documentation.
• Excelled as a Senior Data Architect in sourcing data analysis in ODS Schema.
• Composed stored procedures to extract data for ITO (Inventory to Order) Portal.
• Mapped data from operational sources to ODS schema in oracle for development of Business Intelligence reports applying Oracle OBIEE.
• Created 40 PL/SQL stored procedures to extract and display data from ODS in front end.
• Developed operational and analytical reports (OLAP) using OBIEE tool utilized by the locations overseas.

Confidential

Senior Data Architect

Technical Scope: Erwin Data Modeler 7.3, Teradata, Oracle 11g, Informatica PowerCenter, Business Objects

Responsibilities:

• Designed and developed relational data models(3NF) for various datasets involved in migration
• Conducted data analysis and prepared data profiling reports
• Created data-models for additions/modifications made to the database ensuring that no principles of modeling were violated and incorporated best practices
• Interacted with business users to resolve any UAT issues
• Engaged with business to gather requirements
• Provided guidance and leadership to less experienced team members in designing, testing, debugging, documenting, and implementing changes to new/existing applications and reviewed their work prior to client delivery
• Provided post-implementation support to resolve client’s issues

Confidential

Project Lead/DW Architect

Technical Scope: Informatica Power Centre 8.1.1, Oracle 11g, MySQL 5.1

Responsibilities:

• Effort estimation
• Requirement gathering and analysis
• Dimensional DataMart (Star Schema) and ETL Design and development
• Preparation of Technical Design Documents
• Managed team of 4 ETL Developers
• Coordinated with onsite for requirement clarifications and issues

Confidential

Senior ETL/Teradata Developer (Contractual)

Technical Scope: Informatica Power Centre 8.6, Teradata V2R6, PVCS, Kintana, Oracle 10g

Responsibilities:

• Designed and developed mappings, sessions and workflows in Informatica power Centre
• Used pushdown Optimization, fast load in Informatica
• Worked with different data sources including flat files and rdbms.
• Performance tuning in Informatica, Teradata, Oracle
• Reviewed the mappings and tuned as necessary (Mapping level and Session level)
• Wrote Bteq scripts in Teradata for history data loading
• Created Dollar Universe jobs to automate the entire process

Confidential

Data Warehouse Architect/Sr. ETL/BO Developer (Contractor)

Technical Scope: Informatica powercentre 8.6, Business Objects X1, Oracle 9i, SQL Developer, MS Office

Responsibilities:

• Gathered requirements from the client and created User Requirements Document
• Defined a solution based on requirements gathered.
• Designed and developed a dimensional (Star Schema) data model for reporting/dashboard requirements of Group safety department of Confidential .
• Created a technical design as per solution definition - LDM/PDM, ETL Mappings, BO Dashboard & Reports
• Created ETL mappings, sessions and workflows in Informatica PowerCenter for staging, dimension and facts using different transformations
• Created BO dashboard and custom reports
• Unit testing and system testing.
• Deployed ETL mappings and BO Dashboard reports into production
• Provided Post Go-Live production support

Confidential

ETL Developer

Technical Scope: Informatica ver 8.6,Teradata sql assistant,Multiload,fastload,bteq,sql loader,Unix, Teradata

Responsibilities:

• ETL Mappings development in Informatica for loading source data in Teradata & Oracle
• Wrote SQL queries in Teradata & Oracle to generate reports
• Interfaced with Marketing and finance departments
• Ensured on time delivery of Ad-hoc/Daily/Weekly/Monthly reports
• Partition management
• Coordinated with Mediation and SA teams