SUMMARY:

• People Development
• Scram Master
• Project management/Coordination
• Process Standardization
• Offshore Coordination
• Change Management

• Enterprise Data Architecture
• Data Analysis, Design and Development
• Enterprise Data Modeling
• Data Governance
• Data Quality, IDD, IDQ (Informatica)
• Master Data Management (Informatica)
• ETL, Data Warehouse and Business Intelligence
• Big Data (Hadoop), No SQL, Enterprise message system & TOGAF
• Performance and Tuning
• Oracle 11i
• Srinivas is a result - driven IT Leader who has spent 15 years in Information Technology working in Architecture of data, Integration and Solutions. Srinivas has formerly also worked Enterprise Data Architect and supported BI - OLTP and DATA OLAP systems . Srinivas also have hands on experience in Data Management, Big Data, MDM, Data Governance, Data visualization, Data Security and designing Enterprise Database models.
• He added value to the projects that he worked by collaborating with project teams, identifying risks, bottlenecks on time, meeting with end-users, assisting business analysts and stakeholders. He is easy to work with and always within reach to the teams.
• According to Strength Finder 2.0, Srinivas had these five best qualities as a Stabilizer: Responsible, Futuristic, Positive, Developer and Team player. Srinivas has domain knowledge in Health Care, Confidential, Medical equipments, Blood Bank, Auto Insurance

TECHNICAL SKILLS:

Managerial: Ms-Office Tools, Security, Model Metrics, Resource allocation tracking, version one, Auditing, Change Management

Big Data: Nosql, Hadoop, MangoDB, Data Lake

MDM Tools: Informatica MDM consol, Data Analyst, IDQ and IDD.

Data Modeling: SAP- Power Designer 16.5 SP5, Power Designer Viewer, Erwin tool.

ETL Tools: Informatica Power Center/PowerMart 4.7/5.1/6.2/7.1/8.6, SSIS package, Informatica Metadata manager & Crystal reporting.

RDBMS: Oracle 10g/11g, MS SQL Server 2008/12, IBM DB2 7.1/6.1,Sybase, Teradata, DB2, MS Access 97/2000

Programming Language: Visual Basic 6.0, JAVA, SQL, PL/SQL, UNIX Shell scripting, XML, ASP, Perl

Others: Putty, Tibco 5.4, MS-office Toad, SQL*Loader, Version One, Quality Center, MS Test Manager, Oracle Financials modules AP,AR,GL, FA and PO.

PROFESSIONAL EXPERIENCE:

Data / MDM Architect

Confidential - Minneapolis, MN

Responsibilities:

• Designed, developed and configured data model for supplier master and raw material master.
• Created conceptual, logical and physical model for supplier & raw material subjects.
• Created sql scripts for new and existing requirements and provided to DBA group.
• Worked with development group and created business rules for “Auto Match, Manual Match & Merge” the process.
• Designed MDM architectural daily feeds, monthly and overall work flows.
• Participated actively in gathering source requirements of Asia Oracle ERP 11i systems
• Created business rules and quality rules using Informatica IDD manager.
• Participated in requirements, code reviews and UAT testing.
• Trained data steward basic usage of Informatica tools such as IDD, IDQ and Data analyst tools
• Gathered Metadata information and provided to Data governance team.
• Providing assistance to team members in change request approval, system set-up, review code, resource management and performance review.

Enterprise Data Architect/Lead Architect

Confidential, Minneapolis, MN

Responsibilities:

• Managed Level 3 Support of Data Integration (DI), Enterprise Data Warehouse (EDW) and Data File Transfers - both internal and External facing.
• Partnered with Quality Assurance and Development/Ops team and DBA group to drive performance improvements and defect resolutions. Including prioritization of non-project.
• Respond to incidents that occur in Data Integration, EDW applications and partner with IT Operation teams.
• MDM architecture designed and first phase successfully implemented for Supplier Master, also designed data profiles, score cards and search quires.
• Played an integral role in defining the overall data strategy representing operational perspective of data strategy. Provide and influence development strategy within EDM development teams. Performing code reviews and approvals for newly developed processes.
• Managed staff and their assessment through performance planning, coaching through 1-1 meetings, annual appraisal and disciplinary efforts.
• Created, managed and approved number of migrate data scripts, models and other programming scripts into production through change advisory board (CAB).
• Performed standard repeatable process and procedures for - adding new data feeds to the existing data pipeline and adapting to changes in the format of outgoing data feeds.
• Ability to plan and organize work to meet pre-established deadlines.
• Developing and presenting a variety of materials in order to clarify data model meaning and usage effectively to a wide range of technical and non-technical consumers
• Consulting with users to plan, develop, improve, and maintain moderately complex components of the logical/physical corporate model
• Driving innovations by keeping current on emerging technology and data trends such as Big Data, Hadoop, NoSQL, Data Virtualization, and Data Services
• Establishing, maintaining, adhering to, and enforcing Enterprise Data Modeling and Data Integration standards
• Participating in the proliferation of our Corporate Meta-Data Repository

Lead Data & EDW Architect

Confidential, Minneapolis, MN

Responsibilities:

• Study & analyze existing systems, design conceptual, logical and physical data models. Support enterprise applications
• Engaged in User stories, Interviewing business users, requirements gathering.
• Developed and automated SQL scripts using Power Designer to support enterprise goals
• Actively engaged in Agile ceremonies - Sprint Planning, Daily Stand-up, Sprint Retrospective and Sprint Review meetings, provide inputs.
• Developed a variety of “Data Domain models” and “Enterprise models” for enterprise application.
• Participate in creating “Canonical model” of data design standards, enterprise application integration,datadefinitions associated with integrating frontend application.
• Led “Production User Access” initiative - review, analyze, clean up database users and establish guidelines.
• Introduced “Power Designer Web Portal” service to business users for understanding of model diagrams, Meta data and other definitions.
• Led OCBU (Oracle financial custom module) project and created SAD document, database models.
• Created new Software Architectural Document(SAD) and updated existing sequence diagram, state diagram and Integrations guidelines etc.,
• Established and worked on back log items of the Enterprise Architecture (EA) team to support enterprise strategies
• Has acted as Scrum Master for couple of projects (Certified Scrum Master).
• Established Data Governance - DMBOK wheel in the enterprise departmental wide.
• Worked with application development teams and DBA’s to improve SQL performance.
• Reviewed and presented data models with developers, testers and analysts and to share domain knowledge.
• Established enterprise, naming and integrations standards across enterprise.
• Conducted work architecture, design and development using Informatica tool and SQL server.

Sr. ETL Developer

Confidential, MA

Responsibilities:

• Participated in business requirements, study & analysis of the source systems
• Wrote technical specs, designed database tables and developed ETL mappings, workflows.
• Converted existing complex PL/SQL, SAS programs, VB, UNIX and SQL scripts to ETL stream line.
• Led the team for three projects (HCP Data mart, Value add and CDH mart) wherein designed and developed Dimension & Fact tables, shared ETL mappings design & scripts with team members, consolidated mappings into one workflow and performed system testing.
• Worked with complex database store procedures, packages and other programs enhancing existing COPIS and MBH projects
• Build new and enhanced SSIS ETL programs. Converted SSIS Packages to Informatica.
• Developed UNIX shell scripts to perform tasks such as file formatting/validation, reconciliation of source and target counts, executing SQL programs/ queries, ftp, archiving files, Mail Validation. Created .dat files as indirect source to read multiple files for further use for ETL source compatibility.
• Did HCP Data warehouse architecture and designed dimensions, fact tables as per Ralph Kimbol methodology.
• Created Error handling for input sources and report the defects/issues to appropriate Business/QA team for further investigation.
• Assisted offshore team with ETL code/design, requirement questions and following of standards..
• Did Code Review for Informatica Mappings, workflows including performance tuning, Unix Scripts, PL/SQL programs and suggest changes if any.
• Designed and developed Crystal reports including setting up ftp connection, Mail validation, Database/ODBC connections, scheduled Jobs and generated .xls, .pdf and .txt reports.
• Responsible to ensure documents such as deployment plan, smoke testing plan, risk assessment while moving code from QA environment to Production.