SUMMARY

• Over 20 years of IT experience with Enterprise Information Management Engineering as the key solution area
• Extensive Experience in Data Management portfolio processes - Data Governance, Data Architecture, Data Warehousing, Data Quality, Data Virtualization, Data Security, Reporting & Analytics, Master Data Management (MDM) implementations
• Extensive experience in the design, build and maintenance of Elastic Data Management infrastructure: on-premises/on-cloud or hybrid ecosystems
• Trained in Big Data Hadoop technology and its components - HDFS, MapReduce, YARN, Pig, Hive, Sqoop, Flume etc.
• Worked with various small, medium & large data management clients and architecting & developing solutions with utmost customer satisfaction & accolades from every client associated with
• Translated business users’ needs into Technical Design Documents, Process Documents and Requirement Specification documents
• Vast Expertise in technical architecture design/redesign for data management ecosystems on cloud & on-premise or hybrid platforms
• Expert, In-depth, hands-on knowledge on implementing end-to-end data flow processes & data services from conceptualization to production roll out
• Expertise in integrating, stand-alone data service applications like Collibra, Denodo, Profisee Maestro, Data Flux, in a multi-tenant environment
• Proficiency in design & development of relational, non-Relational, NoSQL databases, PL/SQLs, ETL/ELT processes, Data Quality artifacts, multi-domain MDM repositories & Data Service APIs & traditional database environments involving Oracle, Microsoft SQL Server, Teradata & IBM DB2
• Designed and developed business intelligence (BI) solutions using highly used ETL/ELT tools like Informatica PowerCenter, IBM DataStage, Talend, Oracle Data Integrator, Matillion, etc. Proficient in using Analytics/Reporting tools like Tableau, QlikView, IBM Cognos Analytics, Microsoft PowerBI, etc.
• Continuous involvement in Release management, build & code migration, and version control techniques as applicable to Enterprise Information Management Engineering
• Extensive experience in dissemination of work and coordinating with business & technical teams to produce quality work within aggressive deadlines & tight costing structures
• Excellent analytical, problem-solving, communication/interpersonal skills with a sense of ownership & “Do-not-stop-until-fixed” attitude
• Ability to adapt and act as an architect, support analyst, business analyst, data analyst, data modeler, core developer, tester, project manager along with administrator & applications-gatekeeper, as per need
• Strong leadership, planning, execution, people management and mentoring skills
• Extensive experience as a scrum master, project manager, SME in an Agile project environment

TECHNICAL SKILLS

DB/DWH: Oracle, IBM, MS SQL Server, Teradata, Amazon Redshift, HP Vertica, Amazon Aurora, Amazon RDS, Azure Data Factory & Azure Data Warehouse, MongoDB

BI Reporting/Analytics: QlikView, Tableau, MS Power BI, Power Pivot, IBM Cognos Analytics, Microsoft SSAS & SSRS

ETL/ELT: Informatica PowerCenter, IBM DataStage, Microsoft SSIS, Oracle ODI, Informatica cloud integration, Talend ETL, Matillion ETL

DQ: Ataccama, DataFlux, Informatica IDQ, Oracle DQ, IBM Data Quality, Microsoft DQS, Talend DQ

MDM: Informatica MDM, Oracle MDM, Semarchy MDM, Talend MDM, Profisee Maestro MDM, Microsoft MDS, IBM MDM

Miscellaneous/Basics: Star & Snow Flake Schema, Dimensional Modeling, Erwin Data modeler, Embarcadero ER Studio DA & SA, Ralph Kimball, Bill Inmon, Waterfall, Agile, Methodology, Python, C, C++, SQL, PL/SQL, Unix/AIX/MKS Shell scripting and Perl Scripts, HTML, XML, SQL * Plus, SQL * Loader, AIX, Sun Solaris, Jira, LANDesk, Assembla, HP Quality Center, TFS, ServiceNow, Control M, Autosys, AWS EC2 provision & configuration, Data transports, AWS/Azure cloud infrastructure architecture design for DWH/BI & other applications to migrate to. Denodo Data Virtualization

Big Data: Trained in Hadoop platform - HDFS, YARN, Pig, Hive, Sqoop, Flume, etc.

PROFESSIONAL EXPERIENCE

Confidential

MDM Architect & BI Architect

Responsibilities:

• Introduced & Implemented Tableau reports/dashboards for Advisor & Investor data logging/auditing process replacing existing reports generated by ETL and in-built application called MOCA (Management of client & administration)
• Worked exclusively to integrate Investor Data with existing Advisor and Plan Sponsors data
• Re-designed Advisor ORS data model to keep in sync with Investor ORS in conjunction with subscribing systems like Datawarehouse/DataMarts, LASR & SFDC
• Managed Dev-Ops and lead BAU operations in an onsite-offshore model
• Set up and configured Business Entities, Hierarchies, Relationships, and E360 UI layouts via MDM Provisioning tool
• Configured and enabled Smart Search for E360 UI and downstream consumers leveraging Rest API payloads
• Performed data analysis and code simplification of CDM components including ETL processes
• Installed ActiveVOS and configured 2-step approval process within Entity360
• Provisioned & Migrated MDM eco-system (PowerCenter, Data Quality, Database and MDM) from Phoenix servers to San Jose datacenter which saved the company hundreds of thousands of dollars annually, upgraded the software versions in the process, ex - Linux 6.10 to 7.8, SQL Server 2012 to SQL Server 2016 etc.

Environment: Informatica 10.3, IDQ and MDM, PL/SQL, Oracle 12C, Unix Shell scripts, Linux 7.8, Tableau Desktop 2019.3.1

Confidential

Senior MDM Developer & Data Architect

Responsibilities:

• Installed & configured MDS and DQS within Arconic Infrastructure
• Identified and defined the right strategies to integrate master data with other operational systems to leverage the master data more efficiently and effectively
• Profiled & discovered data stores, data sources and generate profiling reports. Document data quality risks & design data quality solutions
• Created Master Data Management data models for Item Master & Item Primary Site - domains, entities, attributes, hierarchies, members, relationships & constraints
• Designed data flow processes for master data - staging, consolidating by applying defined Survivorship rules, Matching & Merging rulesets for Golden record management
• Designed and developed processes for maintaining single source of truth through Master Data Management solutions to support the Enterprise-wide Items & Primary Site master data needs for Arconic
• Drove requirements sessions with Arconic' SMEs and stakeholders determining Point of View for Business Problems and Requirements
• Whiteboard sessions with business analysts, data analysts, development & QA teams designing solutions to business problems

Environnent: Microsoft SSIS, MDS, Profisee, PL/SQL, PowerBI, Microsoft SQL Server, Windows