PROFESSIONAL SUMMARY:

• Big4 consulting experience as well as 15+ years of experience in Solutions Architecture(Data Lake, EDW etc.), End to End Implementation, Audit, Data Integration, ETL (Ab Initio, IBM Data Stage, Informatica) SAP, People Soft and Mainframe systems.
• Experience in providing solutions architecture for enterprise Data Lake, DWH, ODS, Financial Reporting Environment (FiRE) systems which have SAP, People Soft ERP applications, Mainframe Legacy Applications, Interfaces between Legacy systems and advanced systems applications, Distributed Systems applications.
• Experience in designing data pipe line for data ingestion, data curation and developing insights (data consumption) through business analytics.
• Extensive experience in building data lineage canonical data models by defining envelopes and sub envelopes.
• Extensively involved in data modeling, data virtualization during Data Lake ingestion, curation phases of Data Lake.
• Associate with industry experts in establishing data analytics platform on AWS and Azure cloud environments.
• Identify critical data elements (CDE). Asses program data governance maturity level to define each component dimension of metadata, data quality and master data.
• Extensive involvement with Data Quality using ETL tools, Talend, AB Initio DQE, Informatica IDQ, IBM Big Quality and with source data loading into Data Lake using IBM Big Integrate, Ab Initio and Kafka tools.
• 5+ years of experience in Hadoop Big Data practices and technologies like HDFS, YARN, Map Reduce, Hive, PIG, HBASE,Mongo DB, Cassandra, SQOOP, OOZIE, ZOOKEEPER, Flume, Kafka, Impala, and Apache Spark, Scala and Spark SQL.
• Strong working Knowledge of using PIG and Hive for processing and analyzing large volumes of data.
• Possess leadership and enterprise data governance capabilities such as Data Architecture Management, Data Development, Data Security Management, Master Data Management, Data Warehousing and Business Intelligence Management, Metadata Management.
• Experience in designing data pipe line from data ingestion, data curation and developing insights (data consumption) through business analytics.
• Ability to engage with Data Architects, Directors and Business Users to understand data access paths and business use cases.
• Ability to integrate information security and operational risk requirements for infrastructure, processes and procedures during implementation of large Enterprise Data Lakes, EDW’s and ERP systems.
• Experience in implementing Data Warehouse presentation layer including design and definition of logical tables, physical sources, dimensions, columns, aggregation rules.
• Expert in Requirement documentation and articulating them with design, development and testing team.
• Ability to analyze data elements and develop technical specifications and data mapping documents.
• Proficient in applying Optimization techniques for better performance on the ETL side and also on the database side.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.
• Designed, built and launched extremely efficient & reliable data pipelines to move data (both large and small amounts) to Data Lake.
• Experience in providing guidance on cluster management incorporating security, disaster recovery, and replication across data centers.
• Work closely with Ab Initio ETL developers to leverage that technology as appropriate within Cloudera, Horton works (HDFS) distribution environments.
• Strong expertise in writing PL/SQL scripts, functions, stored procedures, complex SQL queries, PL/SQL analytical functions, hierarchical, parent - child queries.
• Vast knowledge of Bill Inman and Ralph Kimball Methodologies, Advanced Data Warehousing Architecture and Multidimensional Data Modeling Techniques.
• Write best practices of Solution Architecture, Data Lake, ETL tools Ab Initio, Data Stage, Informatica and methodology, IIS (Data Stage), Teradata with respect to each phase of ITIL/SDLC
• Serves as a pre-sales support specialist through the development of materials and by presenting solutions to prospective clients as a subject matter expert.

TECHNICAL SKILLS:

Operating System/Storage: HDFS, Cloudera, Horton works, Windows 10/NT, UNIX, AIX 5.3, Z/OS, MVS, Z13, OS/390

Database / Development: Hadoop Big Data, Spark, Hive, PIG, Scala, Scala SQL, Mongo DB, Cassandra, Teradata, Fast Load, Multi Load, BTEQ, Oracle 10g, SQL, SQL Server 2000, DB2 UDB, SQL*Loader and SQL Plus

Languages: Scala, Python, HQL, Cobol, JCL, CICS, BTEQ, Java

DWH/BI Tools: Ab Initio-GDE 3.0.2, Co>Op 3.0.2, EME, Express>It, Tableau, Talend, Data Stage11.x,8.x/7.X/6.X, Informatica Data Quality (IDQ), COGNOS, SYNCSORT 4.2

Modeling and Data Governance: Architect or, Collibra 5.0 (Collibra Catalog), SAP Power Designer, ERWIN, TOAD Data Warehousing

Methodologies: Ralph Kimball, Bill Inman and IBM Data Warehousing Methodologies

Data Governance: Data Dictionary, Data Glossary, Business Glossary, Taxonomy, Ontology

Application Design and Development: ECC, BI, Data Warehousing and Modeling using Multi-Dimensional (Star/Snowflake) and ER approach in a large Enterprise Data Warehouse (EDW) applications, Operational Data Stores (ODS), Data Marts

Reporting & Administration: Tableau, OLAP, ROLAP, HOLAP and MOLAP using COGNOS 8.0, Micro Strategy.

Management/Leadership Skills and Roles: Worked as Big Data Architect, Data Analyst, Project Manager, Technical Lead, Consultant, Senior Data Warehouse Developer and Senior Applications Developer with activities such as resource allocation based on projections, coordinating tasks & status with onsite-offshore model, providing technical support to team members, induction training

Training & Development: Conducted corporate training for Data Stage, Data warehousing concepts in Kanbay (Cap Gemini), Ab Initio and COGNOS in Confidential . Also, Conducted various training programs both in KANBAY and Confidential . Taken Induction training programs for new members on technical, business and application knowledge

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Solutions Architect

Responsibilities:

• Played a technical role and responsible for analyzing, designing, and implementing solutions specific to IT data. I worked directly with Enterprise Data Analytics (EDA) Data Architecture, Enterprise Information Technology (EIT) Systems Architects, and IT business partners to understand the requirements and partner with the development team to implement high performance database solutions of IT data within the enterprise.
• Built and architected next-generation Enterprise Data Lake and analytics applications on a group of core Hadoop, NO SQL technologies, Scala, Python with Spark.
• Evaluate new technologies and products, and research to identify opportunities that impact business strategy, business requirements and performance that can accelerate access to data and automate key data flows.
• Helped to have highly scalable and extensible Big Data platform which enables collection, storage, modeling, and analysis of massive data sets from numerous channels.
• Analyzed latest Big Data analytic technologies and their innovative applications in both business intelligence analysis and new service offerings adopt and implement these insights and best practices.
• Involved in evolving/managing technologies/tools in a rapidly changing environment to support business needs and capabilities.
• Deep understanding of cloud computing infrastructure and platforms. History of working successfully with multinational, cross-functional engineering teams. Capability to architect highly scalable distributed systems, using different open source tools.
• Participated in scrum daily stand ups. Coordination with different teams, delivering all the release management work as per Confidential Standards.
• Contributed to Business Glossary, Data Glossary/Dictionary and Data Lineage.
• Worked with business owners to prioritize feature development, based on business value. Documented new features, requirements, and strategies.
• Involved in the process of collecting, aggregating, matching and integrating of data.
• Designed and developed ingest, transformation and egress capabilities leveraging latest tools such as Kafka, Storm, Pig, Hive, Scoop, Flume, Spark etc.
• Assigned schemas and created HIVE tables.
• Facilitate the selection of appropriate Hadoop and Hadoop ecosystem tools.
• Extensively worked with Data Scientists by meeting data demands for visualization reports and also worked with development team i.e. Tableau developers with respect to data requirements and delivery.

Confidential

Responsibilities:

• Contributed to the implementation of strategic Big Data platform, Data Lake, Analytic applications and other enterprise IT strategies like Cloud computing.
• Planned, architected and executed Data Lake, Analytics, and Machine Learning applications on Big Data platform. Performed extensively lineage analysis and meta data management.
• Built Big Data foundation that can be leveraged to build services on an ongoing basis, which support multiple business areas across the organization.
• Lead the creation of all design review artifacts during project design phase, facilitate design reviews and capture review feedback and schedule additional detailed design sessions as necessary.
• Acted as the liaison between the Customers, Business Analysts, Development teams and Support Teams.
• Managing Development, Production Support and Operations projects with onshore and offshore model.
• Knowledge project lifecycle and methodologies and implement as per the project requirement.
• Ensures that the teams are able to gather, analyze, store and share knowledge/information.
• Acted as technical lead on complex ETL development projects with multiple team members
• Developed functional and technical documentation for enterprise integration of data from heterogeneous source systems.
• Established the reference architecture, processes, standards and technical framework.
• Provided design and development expertise for large-scale, clustered data processing systems.
• Exhibited strong data engineering skills and ability to transform data from Hadoop Data Lake through curate, consume processes by building Business Insights.
• Worked with large data sets and distributed computing using Hadoop eco systems, such as Map Reduce, Hadoop, Hive, Pig, Flume, OOZIE and Spark.
• Worked on development of reports using Tableau and dash boards using Splunk.

Environment: Hadoop, Hive, PIG, Kafka, Flume, Zookeeper, Map Reduce, YARN, Apache Spark, NiFi, Mongo DB, Cassandra, Elasticsearch, Splunk, Collibra, Azure Data Factory V1, Python, Jenkins, Java-J2EE, Zeppelin, ERWIN, Visio, HP-ALM, Power Point, SAP Power Designer, Sparx, Ab Initio, GDE 3.0.2, Co>Op 3.0.2, Express> It (ACE, BRE), EME, Metadata Hub, Informatica Power Center, Informatica IDQ, Informatica MDM Hub, Control-M IIS, Autosys, Talend, Teradata, Oracle, MLOAD, Fast Load and BTEQ, UNIX, Shell Scripting, SQL, Tableau, BiQuery, XMLSpy, Experian, ESP, PEGA

Confidential

Data Analyst

Responsibilities:

• Gathered requirements from the development team and database developers to analyze the tables and entity relationships for understanding the database.
• Designed the integration document/xls. Derive input and output of each of the integration points.
• Documented the acceptance criteria for each of the test cases. Built the test cases based on test scenarios.
• Executed test cases & log results, performed data validation testing as appropriate, tracked defects and participated in defect resolution.

Environment: Data Stage, Ab Initio, GDE, Co>OP, EME, IBM MQ and/or Kafka Message Brokers, Control-M, HP-ALM, SharePoint, MS-Visio, MS-Excel, Teradata SQL Assistant, QlikView, SAP-BO, Oracle 11g, Microsoft SQL Server.

Confidential

Delivery Manager

Responsibilities:

• Assist and support project team members in completing the tasks.
• Mitigated the issues among team members.
• Motivated the team members.
• Review, asses and evaluate execution of the projects on a regular basis.

Confidential

Data Analyst (Data Migration Specialist), Brooklyn, NY

Responsibilities:

• Conducted interviews with technical analysts and business analysts regarding interfaces.
• Prepared current interface documents i.e. specifications, flow diagrams and mapping spread sheets
• Designed new interfaces and helped developers with respect to Data Stage jobs.
• Involved in Operations Data Store (ODS) design and deployment activities.

Environment: IIS (Data Stage 8.01- Enterprise Edition), ERWIN, SAP ECC, SAP BI, SAP MDM, Z/OS, COBOL, JCL, Z-Linux, PVCS, DB2, Web Services, ABAP, Java, XML, Autosys, Excel, Visio, E-Cub, MS Project 2003

Confidential, NY

Enterprise Integration Lead/Analyst

Responsibilities:

• Wrote and reviewed technical requirements for reusable components of translation, preprocessing, derivation, validation, aggregation, technical reconciliation key, code combo key, load ready file for ECC & BI.
• Lead the team of 12 people and helped senior management with respect to status tracking and updates using detailed project plan.
• Designed and helped in development of data quality audit tracker i.e. automatic error handling

Confidential, Atlanta, GA

Project Manager

Responsibilities:

• Involved in Preparation of Functional Specifications, Data Dictionary, Project Plan, source to target Mapping Document.
• Responsible for design, development, implementation and tuning of Logical and Physical data models and ETL process for Policy Delivery data mart.
• Worked on COGNOS frame work model to design reports.

Confidential

Project Manager

Responsibilities:

• Captured the metrics with respect to defects, service requests as per CMMI Level 5 standards
• Organizing the training programs as per requirement.

Confidential, Dearborn, MI

Consultant Data Stage

Responsibilities:

• Worked with business customers for requirements gathering, Logical Design, Physical Design modeling.
• Worked with architects and subject matter experts to design comprehensive solutions.