PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Enterprise Data Modeler/Product Owner/ Technical Team Lead

Responsibilities:

• I wear multiple hats over the years at Intertek mainly comprising of Enterprise Data Modeler, Product Owner and Technical Team Lead.
• Worked as product owner and took the responsibility of Cloud Applications, MDM, EDW, Data Lake and Informatica products on different projects.
• I worked on requirement gathering sessions with the business/user team to gather the product requirements, product strategy, technical requirements, prepare epics, features, user stories out of them as per the business priorities and expectations and assign to the team respectively
• As a product owner, I drove team meetings, assigned user stories and delegated work to the team members and making sure the user stories are delivered in the corresponding sprint on time.
• I was also involved in budget defining sessions with the leadership team, where I contributed in defining the budget for huge projects comprising a team of 30.
• Proposed MVP (Minimum Viable Product) approach in multiple projects in an agile environment and delivered the projects within deadlines with less cost and with immediate business value.
• As technical team lead, responsible for leading the support and development team on technical front, addressing their daily concerns, setting up priorities and providing the clear - cut directions to the team.
• As a technical team lead, I took initiative in owning the tasks, resolving conflicts and road blockers if the team is not able to address them.
• Below are all my responsibilities as Enterprise Data Modeler, Architect where I worked primarily on Enterprise Information Warehouse projects with the business sponsors, subject matter experts, developers, business analysts and report writers across disparate systems and informal sources to gather the requirements.
• Responsible to propose and implement data strategies, solutions for multiple projects across the enterprise.
• Worked in Edison Big Data project using Informatica Hadoop to load data into Hadoop clusters.
• Used Informatica Cloud connector for Hadoop, to move variety of large datasets from any data source into a newly provisioned Hadoop cluster.
• Performed source system analysis to create column level mapping documents and Functional Specification documents to determine the data that needs to be brought into the Data warehouse.
• Responsible to create refresh tables and historical tables in staging environment in SAP P owerDesigner.
• Worked to set up column level definitions and set other column level metadata in SAP PowerDesigner.
• Responsible to create conceptual models in Microsoft Visio and imported them into SAP PowerDesigner based on the business requirement.
• Responsible to create semantic/conceptual, logical and physical data models, of disparate information for report development.
• Responsible to create 2NF Dimensional Models in Data mart Environment and to co-ordinate with the SAP BODS ETL team to explain the models, mapping documents to successfully generate Mapping Documents.
• Created Integration Relational 3NF models that can functionally relate to other subject areas and responsible to determine transformation rules accordingly in the Functional Specification Document.
• Successfully published all the models to the SAP Power Designer Dev and Proxy Repositories.
• Reverse Engineered the models and created the data dictionaries to generate Enterprise Glossary for all subject areas in SAP Power Designer.
• Worked as the Administrator to grant permissions, created user profiles for SAP Power Designer users through SAP Power Designer Portal.
• Created database connections in Informatica Administrator, created projects and imported tables to perform data analysis and data profiling through Informatica Analyst and Informatica Developer.
• Worked with SQL Server Database Administrators to implement staging, integration and data mart DDLs with respect to the warehouse modeling standards in the database.
• Worked on multiple data modeling projects in parallel such as MDM, KPI 5x5, GAP Retail, Enterprise Landscape and Integrations and successfully implemented them.
• Developed new Enterprise Performance Management (EPM) and Data Modeling standards and best practices and enhanced the existing ones.
• Implemented MDM based solutions and responsible for creating and maintaining MDM data models for the enterprise.
• Worked and have hands on experience with Informatica MDM Hub, Provisioning tool, Informatica Analyst, Informatica Data Director MDM applications.
• Worked with SOAP and REST API to implement solutions for different API integrations.
• Extensively worked on XML technologies like XML, XSL, XSD, XSLT, XQuery, Xpath and DTD
• Expertise in applying JMS (Java Messaging Service) and Log4J for reliable information exchange across Java applications
• Proficient with Web Services Description Language (WSDL) for publishing and finding description for Web services
• Provided MS Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process
• Azure API Management, Security, Cloud-to-Cloud Integration (Public, Private)
• Created Mule ESB based tooling suite for handling message transitioning, validation, enrichment and routing to upstream and downstream entity data consumers
• Experience in Mule Administration, Configuration, & Tuning with MuleSoft MMC & Enterprise release capabilities
• Developed Power BI reports on top of semantic data models based on Azure, SQL Server databases.

Environment: SAP Power Designer 16.5, SAP BODS, SQL Server 2014, Informatica Power Center, Informatica MDM Hub, Informatica Data Director, Informatica Data Quality, Informatica Analyst, Business Objects, Microsoft Azure, MuleSoft, AWS, SAP, SOAP, REST, XML, Java, JIRA, Test Link, Power BI, Microsoft Excel 2010, Microsoft Word 2010.

Confidential, Long Island, NY

Principal Information Modeler

Responsibilities:

• Worked primarily on Enterprise Information Warehouse (EIW) and EIW Enhancements project with the SME and Business System Analysts to gather the requirements.
• Performed source system analysis to create column level mapping documents and Functional Specification documents to determine the data that needs to be brought into the Data warehouse.
• Responsible to create refresh and historical tables in staging environment in CA Erwin Data Modeler 9.0.
• Worked to set up column level definitions and set other column level metadata in bulk editor in Erwin.
• Responsible to create conceptual models in Microsoft Visio based on the business requirement, create refresh and historical tables in staging environment to perform data analysis and data profiling.
• Created Integration Relational 3NF models that can functionally relate to other subject areas and responsible to determine transformation rules accordingly in the Functional Specification Document.
• Responsible to create 2NF Dimensional Models in Data mart Environment and to co-ordinate with the ETL team to explain the models, mapping documents to successfully generate Informatica ETL mappings.
• Worked with Teradata and SQL Server Database Administrators to implement staging, integration and data mart DDLs with respect to the warehouse modeling standards in the database.
• Worked on multiple data modeling projects in parallel such as Product, Leads, Campaigns, Account, User, Survey and Gain sight successfully implemented them in Agile Environment.
• Successfully published all the models to the CA Erwin Model Mart and lead the CA Erwin upgrade project to upgrade CA Erwin 9.0 to CA Erwin 9.5.
• Automated Teradata and SQL Server DDLs to reverse engineer them into data models in CA Erwin 9.0.
• Worked as the Administrator to grant permissions, created user profiles for CA Erwin 9.0 users through Erwin Administrator.
• Worked with different Source Systems Cloud9, C&I, Salesforce etc. and successfully involved in decommissioning Cloud9 and C&I systems to make Enterprise Information Warehouse as the single source of reference.
• Provide technical leadership and governance of the big data team and the implementation of the solution architecture in following Hadoop ecosystem (Hadoop (Horton Works), Map Reduce, Pig, Hive, Spark, Python.
• Experienced in testing data in Hadoop Distribution File System (HDFS) and Hive for each transaction of data.
• Involved in CAB Approval meetings and responsible for creation of Change Orders. Created User stories, tasks etc. in Version One to meet sprint deadlines and track deliverables.

Environment: CA Erwin 9.0, CA Erwin 9.5, Sales force, Work Bench, Teradata 14.0, C&I, Cloud9, SQL Server 2008, Informatica, QlikView, Business Objects, Hadoop, Hive, Spark, Python, SAP, Version One, Clarity, Microsoft Excel 2010, Microsoft Word 2010.

Confidential, Boston, MA

Data Modeler/Data Architect

Responsibilities:

• Worked on multiple projects and assisted different teams through the entire SDLC (Software Development Life Cycle) with respect to requirement gathering, gap analysis, data modeling, data quality and functional reporting.
• Participated in Joint Application Design (JAD) sessions and gave data base design inputs necessary for the designing the front-end application layer for the Share Point portal project.
• Worked on designing the conceptual model by converting the business requirements in CA Erwin 9.0.
• Worked closely with Project Champion to create Work-Breakdown Structure, Resource Breakdown Structure using MS Project and managed project and resources to accomplish company’s goal.
• Performed several SQL queries in SQL Server Management Studio (SSMS) to analyze Source System SQL Server database and implemented SQL scripts in Teradata SQL Assistant to analyze the DB2 source system respectively.
• Incorporated business requirements in quality conceptual, logical data models using Embarcadero ER Studio 9 and created physical data models using forward engineering techniques to generate DDL scripts in agile environment.
• Worked on star and snowflake schema data models and thus identified the Facts and Dimensions accordingly.
• Worked with ER studio macros and other QA checklists to extract several model reports for documentation and quality check purposes.
• Developed source to target mapping document, with all the transformation rules and also created table volume calculation document.
• Extracted DDL scripts from ER Studio physical models and implemented them in the relational database in Teradata 13.
• Responsible for writing different types of test requirements (Unit, System, Integration) and delivering it to the ETL team for the development of test cases.
• Worked on Team Foundation Server (TFS) for maintaining documentation of the whole EDW packages.
• Responsible in delivering modeling packages of different subject areas to the ETL team through ETL handoff sessions.
• Responsible for creating and maintaining EDW framework process documents on the SharePoint portal.
• Developed data migration strategies and impact analysis for both Teradata and Oracle database systems.
• Developed process models, data flow models in MS Visio for understanding the system architecture.
• Used Timesharing option (TSO) to work on the IBM mainframe operating system to analyze the tables and capture the source system information.
• Worked closely with Micro strategy reporting team while handling multiple projects to gather the reporting requirements and developed models accordingly.

Environment: CA Erwin 9.0, MS Visio 2013, SharePoint, Teradata SQL assistant 13.10, DB2, Oracle, SQL Server 2012, Embarcadero ER Studio Data Architect 9.5, MS Visio 2010, MS Access 2010, Microsoft Excel 2010, Micro Strategy, TSO, MSAT, All Word, IBM Information Analyzer, Data Stage,SQL Server 2012.

Confidential, Newark, DE

Data Modeler/Data Architect

Responsibilities:

• Facilitated JAD sessions with project stakeholders, project management team and team members to understand business needs; determine technical design solutions, project scope, goals and objectives of the projects.
• Worked with the Business community and Project Champion at Offshore in gathering their data transaction information.
• Responsible for building a new customer data mart (CDM) in Teradata in order to provide functionality for reporting needs.
• Analyzed BTEQ and Shell scripts on the source level, performed column to column mapping in excel mapping spreadsheets by doing the corresponding analysis on the Teradata environment at the target level.
• Coordinated with the Data Architect and discussed regarding the Erwin data models for the approval of the design artifacts.
• Designed the BI context and activity diagrams in MS Visio and then developed the conceptual model, by analyzing the requirements in order to explore the domain concepts and to further develop the logical model in Erwin.
• Involved in brain storming session along with the business analysts to identify the logical model and to further implement the physical model to generate the DDL scripts and implement it in the Teradata database.
• Involved in designing OLAP Teradata database using 3NF Normalization and De-normalization techniques.
• Analyzed the Legacy Pervasive database to migrate the data into new OLTP SQL Server database.
• Used SQL Server Management studio tool for data profiling needs such as to have control over the maintenance and management of the data.
• Created ETL mapping documents in MS Excel to load the formatted data into the target tables and thus implemented SQL Server Integration Services packages using Character Map, Merge, Merge Join transformations.
• Created ad-hoc customized queries through ad-hoc reporting systems for simple searches and for fast retrieval of data.
• Assisted SQL Server Reporting Services (SSRS) and SSAS team for generation of reports and data mining.
• Assisted the testing team and have good understanding of testing strategies like unit testing, system testing, regression testing and test cases which are created based on the business standards, product awareness and technical specifications to validate the functionality of the components.
• Accomplished agile methodology to work effectively on data aspects of the systems through different strategies according to the situations and thus for developing internal applications.

Environment: Teradata SQL assistant 12.0, Erwin 7.2, Microsoft Excel 2007, Microsoft SQL Server 2008, Pervasive, SSIS 2008, SSAS, Microsoft Visio 2010, Microsoft Visual Studio 2008, Red Gate, Microsoft SharePoint 2010.