SUMMARY:

• Senior Manager Data & Information Architect with 20+ years of IT experience in enterprise applications and information architecture. Expertise in managing and developing complex data solutions using ETL tools,
• Databases (Relational and NoSQL), Data warehousing, Data Modeling tools, OLTP design, Business Intelligence, Data Analysis, Data Migration tools, Data profiling tools and programming languages. Experience in building and managing Data pipeline solutions for maintaining reference and master data management. Domain experience in Insurance, utility, Retail, Media, Technology, and Transportation industry projects. Worked in various projects using
• SDLC and agile methodologies. As a senior manager, handled multiple Project management activities, liaison between customers and practice, an active member of the product council committee participating and contributing to roadmap, POC, estimations and release planning meetings to build feature backlogs, have experience as hiring manager to fulfill various positions in data team, handling associates appraisals, timesheets, forecasting, project billing and managing teams.

TECHNICAL SKILLS:

No SQL Database: MongoDB Mongo DB charts for operational dashboard Hive Ambari Teiid Data Virtualization

RDBMS: Oracle SQL, PL/SQL, XML and JSON query SQL Server SQL DB2 SQL

Languages: Microservice API using Node JS (Java Scripting) Data load pipelines using Gitlab CI/CD tools Python IDE tools - Intellij, MS visual studio

Data Modeling: Erwin 9.7 tool OLTP / ODS modeling DW / BI / OLAP modeling

Data profiling: Python data profiling BODI Global ID s Data Governance

ETL: Python based ETL jobs using Autosys and Gitlab pipelinesInformaticaBODS - Business Object Data Services (SAP product)

ERP systems: SAP Inventory and Fleet Management data migration PeopleSoft SCM data migration Oracle Retail SCM data migration

BI Reporting tools systems: Hyperion BrioCognos

PROFESSIONAL EXPERIENCE:

Senior Manager Data and Information Architect

Confidential

Responsibilities:

• Collaborate with business partners/customers to define/refine requirements and translate technical specifications.
• Identifying and prioritizing data architecture significant requirements to translate these requirements into data solutions and ensures alignment with the enterprise best practices.
• 9+ years of domain experience in insurance industry on various projects of Business Insurance portfolio with workers compensation, business owner policy products and submission and work management processes.
• Collaborate with the application architects, development teams and infrastructure groups in the development of data architecture and data modeling solutions.
• Design, development and maintenance of data development/access specification, source to target data mappings, ETL specifications and complex transformation rules based on the business requirement.
• Manage the design and development of logical and physical data models using Eriwn data modelling tool to meet the requirement of both OLTP and Business Intelligence projects.
• Design, development and maintenance of configuration/application and business critical reference data in RDBMS and NoSQL databases using data pipelines using Git lab CI/CD pipelines.
• Perform data analysis and business/technical data profiling activities to resolve business critical problem and production data issues using different methods like SQL queries, and profiling tool such as Python, Studio 3T.
• Design and build AutoSys daily schedule ETL jobs using python to load data from SQL server database to mongo database.
• Build business operation dashboard using Mongo chart with NO SQL mongo Database
• Collaborate with other members of the data management group to drive process improvement initiatives for the data management group. Enforcement of data governance standards and processes.
• Participate in the Erwin Data Modeling, ETL, data automation, design, and code review.
• Design and Develop Node Js Micro - services with Mongo DB.
• Data migration experience from Oracle to mongo database
• GIT Lab Continuous integration and Continuous development.
• Working experience with visual studio IDE tool for code development testing and integration Working in Agile Methodologies in DBT, Scrum, Kanban teams, road map planning, release planning, demos, Rally updates.
• Supervising the team, setting goals and performance evaluation of team members.
• Work on look ahead architecture items, POC, tool evaluations.
• Experience with XML and JSON query.
• Handling Project management, Resource fulfillment, Forecasting.
• Worked as hiring manager to fulfill these positions Data Architect, DBA, Full Stack developer, PL/SQL developers in various data teams for customers

Senior Consultant and Data Architect

Confidential

Responsibilities:

• Analyze, review, and interprets business rules functional requirements to captured into Data Migration Functional Specifications for SAP Inventory management, Warehouse management (IMWM) and fleet management modules.
• 3+ years of domain experience in utility industry on IMWM and fleet management modules full life cycle implementation of SAP data migration project.
• Interaction with offshore technical team to explain the functional requirements and converts them into technical specification. Define the process for review and delivery of data migration documents.
• Analyzing Legacy system (PeopleSoft, Oracle, Fleet Anywhere, Manhattan) to SAP mapping and identifying the custom requirement for the data elements missing in SAP system and designing the solution.
• Design, build and review the BODS ETL code for SAP data migration.
• Handling mock run and dress rehearsals and then create technical and business reconciliation reports to support the Migration status. Performing SAP Post Load Data Validations. Building and executing LSMW jobs to load data in SAP after post implementation to fix data clean up and data gaps.
• Training Data Owners and Business users. Identifying the business rule from Data Owners and Implementing in BODI data profiling tool, prepare Data Profiling reports.
• Understanding BODS standard content and assisting the usage of the standard content
• Assists the project manager in identifying the skills and resources needed to implement the Data Migration solution.
• 1+ years of domain experience in retail industry on Oracle Retail Merchandising System (ORMS) data migration implementation project.
• Analyzing ORMS target systems and PeopleSoft SCM and IM source system data models, performing data analysis, data profiling and data cleansing. Based on the research create high-Level functional design document and ETL technical design document.
• Design and development ETL data migration jobs using Informatica 8.6, UNIX scripting and Unit testing. Integration, volume testing, performance tuning in Informatica Mappings/Sessions and Oracle SQL.
• 4+ years of domain experience in media and technology industry on master data management, ETL, data warehousing, data modelling, business intellience and Data profiling and Data Cleaning implementation project.
• Global IDs data profiling tool implementation for scanning and profiling activities uncovering unanticipated data anomalies, opportunities in data structure and business rules in projects, allowing teams to take proactive measures for ensuring the data quality before loading data into the production system or before exposing new data to the customer. This process will improve data architecture services provided to projects in development phase for various Dun and Bradstreet projects.
• Dun and Bradstreet D&B is building a custom hygiene and match system for IBM. The hygiene process applies various hygiene rules to incoming data so that it is cleansed and standardized according to IBM’s data standards. ETL Informatica processes is setup to handling the data cleaning batch process for millions of records data files.
• End to end implementation experience on Hyperion (brio) business intelligence dashboards for aviation intelligence and analysis.
• Design, build and maintain 3NF data modelling using Erwin for building personal learning site for a media customer. Design and build custom program to load and maintain master data using PL/SQL and SQL loader tools.
• Full life cycle implementation experience on building data warehouse for a media company. Design and build informatica ETL process to load daily and monthly data warehouse dimension and fact tables.

Computer Programmer and Analyst

Confidential

Responsibilities:

• Worked as an ETL Developer to design Informatica mappings to Populate data from transaction database to Data marts policy sales mart and Policy Premium transactions mart using informatica transformations and involved in Data loading.
• Worked as a Developer to create impromptu reports, templates, power Prompt Reports by accessing Catalog and to Developing models for the solution to solve queries from business teams and the customers using Cognos transformer interfaces.
• Worked as production support analyst for maintenance of Dimensions, Proper measures to generating Power cubes to solve queries and involved Refining models and Customizing the Power cube and storing the cubes in relational database and scheduling refreshing the impromptu reports and cubes.