SUMMARY:

• An accomplished and results - oriented agile professional with progressive technological leadership and Big Data Architect experience focused on strategy, process management and integration.
• I am be responsible for leading advancements in business analytics by executing our data and analytics strategy, investigating and implementing innovative technologies, and leading data governance.
• Besides effective public speaking and presentation skills, strong communication skills have been a cornerstone of my 14 years long professional career.
• Provided thought leadership for architecture and the design of Big Data Analytics solutions for customers, actively drive Proof of Concept (POC) and Proof of Technology (POT) evaluations and to implement a Big Data solution.
• Collaborate with internal and external stakeholders to manage data logistics - including data transfers, understanding data structures, business rules, etc. - to enable project execution
• Expert in Designing, Modeling, Development and Implementation of Enterprise Data Warehouse, Data Integration and Business Intelligence solutions including transactional Data(OLTP)and Analytical Data(OLAP). strong hands on Architect responsible for strategic plan of enterprise-wide data governance which includes Confidential & Confidential data retention policies, procedures, roles, and responsibilities for standardizing its data, reengineering its business rules, controlling data redundancy, managing its master data, integrating structured with unstructured data, storing and using its data, as well as protecting its data.
• Proficient in creating a step by step Implementation Roadmap to enable the client to move from current to the aspirational level of data management maturity.
• Experience with a strong understanding of Big Data technologies in the Hadoop ecosystem - Hive, HDFS, MapReduce, Yarn, Kafka, Pig, HBase, Sqoop, Spark, etc.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x, Power Connect 9.x/8.x, Informatica Developer Tool 9.x, Informatica Analyst Tool 9.x, Ab Initio 2.13.1, SSIS

Scripting Languages: SQL, PL/SQL, Bteq, Mload, Fexp, UNIX Shell Scripting, Scala

Database: Confidential, SQL Server, DB2, Teradata, Vertica

Design Tools: Erwin, Visio.

Scheduling Tool: Maestro, Autosys

Big Data Tools: Hadoop, MapReduce, Pig, Hive, HBase, Sqoop, R, MongoDB, Scala, Spark

Cloud Technology: AWS S3, Amazon EC2, DynamoDB

Others: TOAD (SQL Tool), PL-SQL Developer, Citrix, SQL*Loader, Composite, Tableau

WORK EXPERIENCE:

Confidential

Big Data Architect

Responsibilities:

• Lead Architect in Designing Comprehensive Data warehouse Solution, from data to presentation layer, to build and expose Activity/Productivity of Sales Representatives involved in different stores distributed throughout the nation.
• Design and implement scalable Big Data architecture solutions for various application needs.
• Analyze multiple sources of structured and unstructured data to propose and design Big Data architecture solutions for scalability, high availability, fault tolerance, and elasticity.
• Proficient in Data warehousing concepts, Kimball/Inmon methodology, Star schema and Snow Flake schema. Designed and developed Erwin conceptual, logical and physical data models of the Datamarts on Teradata and Vertica.
• Designed and constructed current and future state Data Models (Logical and Physical data modeling using Erwin) and identified potential gaps to track data redundancy, and improved management of data flow.
• Designed and implemented ETL load solutions using Informatica for Process and data quality improvement of different data marts and helped in reducing the load time and failure recovery.
• Managed and participated in project prioritization, business processes, configuration management, audit resolutions and designed cross-functional and cross-domain solutions.
• Recognized for building and maintaining client and partner relationships focused on quality service delivery, business challenges resolution, and support services excellence.

Environment: Informatica PowerCenter 9.1, Informatica Data Quality (IDQ), PL/SQL, Confidential 10g, Teradata 12.0, AIX Unix, Erwin 7.3, Composite 5.2, Business Object, Vertica, Hadoop, MapReduce, Hive, HBase, Sqoop, R

Confidential

Senior Informatica Consultant

Responsibilities:

• Responsible for designing and developing Logical and Physical data modeling using Erwin. Designing the ETL Architecture to satisfy application (business and technical) requirements.
• Involved in Understanding client Requirements, Analysis of Functional specification, Technical specification preparation, Review of Technical Specification.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Responsible to the designing and development of data integration into SalesForce from various source applications using Informatica Power Exchange.
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments using Informatica Power Center.

Environment: Informatica PowerCenter 9.1, Informatica PowerExchange 9.1, Informatiaca Data Quality (IDQ), MS Visual Source Safe, PL/SQL, Confidential 10g, MS-Office, Unix, Windows XP, SalesForce

Confidential

Lead Informatica Developer

Responsibilities:

• Responsible to the integration of SAP with datawarehoue through Informatica Powerconnect.
• Closely worked with the SAP Consultant to understand the requirements Confidential the SAP end.
• Jointly worked with Data Architect to influence standardization in new and existing legacy systems.
• Work directly with non-IT business analysts throughout the development cycle, and provide production support for ETL.
• Based upon the findings of analysis, created Mapping Document, Translation Document and then developed the mappings from simple to extreme complex, depending upon the source data, but efficient and flexible, to extract, transform and load data into target tables.
• Involved in the production support and workflow migrations from lower environment to higher environment.

Environment: Informatica PowerCenter 8.1, DB2, Erwin, MS Visual Source Safe, SQL, PL/SQL, Confidential 10g, MS-Office, CoreFTP, Squirrel, AIX-UNIX, Shell scripting

Confidential

Informatica developer

Responsibilities:

• Based upon the findings of analysis, created Mapping Document, Translation Document and then developed the mappings from simple to extreme complex, depending upon the source data, but efficient and flexible, to extract, transform and load data into target tables.
• Worked with application developers to test extraction, transformation and load applications on multiple platforms.Involved Physical database design based on DB2 Logical data Model.
• Applied business and application knowledge to design the data loads for consistency and integrity

Environment: Informatica PowerCenter 7.1, MS SQL Server 2007, Confidential 10g, SQL, PL/SQL, MS-Office, Toad, Team Foundation Server (TFS), Visio, Windows 2000,Citrix, DB2

Confidential

Datawarehouse developer

Responsibilities:

• Understood the existing manual system and provided a probable total web based solution for the same. Conducted requirement analysis with the Government Officials across the District.
• Design and Development of data validation, test cases, and error control routines using PL/SQL, SQL. Involved extensively in designing & coding.
• Extensively used Informatica for loading the historical data from various tables for different Regions. Used Informatica Power Center Server manager to create sessions, batches to run with the logic embedded in the mappings.

Environment: Confidential 10g, SQL, SQL*Loader, PL/SQL, UNIX, HTMLDB, Windows XP, Informatica Power Center 6.2.

Confidential

PL SQL Developer

Responsibilities:

• Involved in design and implementation of mappings to transform data from flat files into database, Scheduling tasks to load stock files into database.
• Design and Development of data validation, load processes, test cases, and error control routines using PL/SQL, SQL.

Environment: Confidential 8i, SQL, PL/SQL, Visual Basic 5.0