Candidates About

 

Srujan

SUMMARY

• Over 10 years of professional IT experience and 8+ years in data modeling and data analysis as a Proficient in gathering business requirements and handling requirements management.
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin, Power Designer and ER Studio Data modeling tools.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• Good in Normalization / Demoralization techniques for effective and optimum performance in OLTP and OLAP environments.

·         Having good experience with Normalization (1NF, 2NF and 3NF) and Denormalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.

·         Having experience and created high level interacted models and developed with Data Virtualization Tools as per the requirement.

• Well-versed in designing Star and Snowflake Database schemas pertaining to relational and dimensional data modeling.

• Experienced in designing the data mart and creation of cubes.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.
• Hands on experience in Hadoop tools such as Hive, Hbase, Sqoop and Pig.
• Hands on experience writing Bteq scripts, MLOAD’s  in Teradata
• Experience in creating Info Cubes, ODS with SAP BW/BI and used different T-Codes.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Having experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.

·         Efficient in analyzing and documenting business and functional requirements along with Use Case Modeling and UML.

• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures.
• Well versed in conducting Gap analysis, Joint Application Design (JAD) session, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
• Experience by using finance model and Bloomberg application to capture selling or divesting assets in the banking domain.
• Experience in understanding of syndicated data (Oracle, Nielsen, etc) and business tools including Tableau.

·         A good familiarity and experience in the work environment consisting of Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.

• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently

 

 

 

      

        TECHNICAL SKILLS

 

        Modeling Tools:           ERStudio, ERwin, Power Designer, MS Visio and Oracle Data Modeler.

        Reporting Tools:          Cogno's 8 / 10, OBIEE, Tableau, Business Objects, Denedo

        Databases:                    Oracle7/8i/9i/10g/11g, MS SQL Server2000/2005/2008/2012, MS Access, Teradata, DB2.           

        Operating Systems/Platforms:  Windows NT, 2000 & XP, Vista, AIX, UNIX,     Linux and Sun Solaris.

Other Tools:                 SQL Navigator, TOAD, PVCS, JIRA, Aqua Data Studio and Informatica Power Center, SAP                           BI/BW.

        Languages:                    C, C++, VB, Java, .NET, PL/SQL and SQL.

 

       

 

 

 

        WORK EXPERIENCE:

 

        PROFESSIONAL EXPERIENCE:

        Bank of the West, San Ramon, CA

        Role: Sr. Data Modeler                                                                                                                                                10/2016 – Present

        Project Summary:  Bank of the west is a financial service company, it is a subsidiary of BNP Paribas and provides consumer and commercial banking, wealth management, mortgage and insurance products and services. The goal of this project was to build a central repository of historic data warehouse that could support the banks various reporting and information needs. Data was spread out in multiple and diverse sources in databases located in different regions. The requirement demanded an integrated, unified data pool that was truly subject-oriented, time-variant and nonvolatile. Dimensional modeling using the star schema architecture was implemented to achieve the task.

        Responsibilities:

• Interacting with Business Analysts to gather the user requirements and participated in data modeling sessions.
• Working with DevOps team, if any necessary changes like modeling issues and enhancements has done as part of the requirements.
• Performed data analysis and profiling of source data to better understand the sources.
• Created 3 NF business area data modeling with de-normalized physical implementation; data and information requirements analysis.
• Created E/R Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified PK/ FK for lookup tables.
• Using 3rd NF created metadata collection and validation; standards compliance verification; ODS schema maintenance; database-to-database data type.
• Involved in non-transactional data entities of an organization of MDM that has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assurance, persistence and distribution.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Developed the data warehouse model (Kimball’s) with multiple data marts with conformed dimensions for the proposed central model of the Project.

• Implemented Star Schema methodologies in modeling and designing the logical data model into Dimensional Models.

·         Conducted design sessions with Business Analysts and ETL developers to come up with a design that satisfies the organization’s requirements.

• Working with Database Administrators (DBAs) to finalize the physical properties of the tables such as Partition key, based on volumetric.

• Analyzed the data from the sources, designed the data models and then generated scripts to create necessary tables and corresponding records for DBAs using Informatica.
• Developed number of Data correction scripts using PL/SQL to handle any manual adjustments/corrections in System.
• Member of Data model and Design Review group that oversees data model changes and system design across Enterprise Data Warehouse.
• Interact with subject matter expert for IT personnel on Data Virtualization software (Denedo), including performance tuning, troubleshooting, gathering and decisions about configuration. Designs and develops high quality integration solutions consistent with given requirements, Involved in creating Base views, interface views and derived views.
• Collaborates with other application development teams to design, develop and deploy solutions leveraging the data virtualization tool. Supports the definition of, and adherence to, Data Virtualization standards, conventions, principles.
• Plans and coordinate with DBAs to installation of upgrades, enhancements, scheduling and changes to the Data Virtualization software. Defines the testing and quality assurance for all upgrades, enhancements, and changes to the Data Virtualization software.

   Environment: Oracle 12C, Teradata 12.0, Teradata Sql Assistant, Informatica 9.6.1, Denedo Platform 6.0, Toad for Oracle 11.5 Expert, Erwin Data Modeler 9.5, Hadoop, MS Visio, OBIEE, Python, Copybooks, Jira, Java.

       

 T-Mobile, Bellevue, WA                                                                                                                                          08/ 2015 – 09/2016

 Role: Sr. Data Modeler

Project Summary: T-Mobile US, Inc. is a major wireless network operator in the United States. The German                      telecommunications        company Deutsche Telekom (DT) is its majority shareholder, through DT's holding company T-Mobile   International AG. Its headquarters are located in Bellevue, Washington, in the Seattle metropolitan area. T-Mobile is the 3rd largest wireless carrier in the United States with 65.5 million customers as of Q1 2016.

Responsibilities:

·         Worked as a Data Architect as part of IDW (Integrated Data Warehouse) project under Agile DevOps methodology

·         Worked with SME, Data stewards

·         Working on different subject areas like Party, Account, Line of Service, Finance and Product

·         Working with Business Analyst to gather business attributes as part of the report and creating LDM based on the business attributes using Power Designer 16.

·         Review LDM with Lead Data Architects and then review with entire team.

·         Creating PDM and Source to Target Mapping documents and review with Lead Data Architects

·         Generating DDLs using Power Designer and executing them on Teradata and Hadoop

·         Data Profiling of source using Oracle and Hue (Hadoop / Hive UI) and supporting developers by testing the target on Teradata and Hadoop.

·         Validating scripts transformations and joins in PIG. 

·         Actively participate in backlog grooming session with scrum master, product owner and solution owner

·         Created a standard document for the client to list out steps on “How to create DDL for Teradata and Hadoop using Power Designer”

·         Using Agile Central (Rally) to enter tasks and associated hours for each task

·         Using GitHub and Accurev to actively manage and promote DDLs

·         Working with different source systems like RPX, Samson, Chub, Ericsson, SAP ECC etc.

·         Designs and develops high quality integration solutions consistent with given requirements using Denedo.

Environment: Power Designer 16, Hadoop, HIVE, HDFS,  Oracle SQL Developer, Microsoft SQL Server 2008, Teradata SQL Assistant 14.0, AccuRev, Cntrl M, SAP BW, SAP ECC, Denedo, Business Objects.

 

        Apollo Education Group, Phoenix, AZ.                                                                                                                          09/2014 – 07/2015                                               

        Role: Data Modeler

Project Summary: The project involves building a dynamic reporting for business intelligence/analytics. The objective is to    have the near real time visibility to human recourse department, inquiry volume, and service and performance metrics and provide the actionable information to decision makers.

        Responsibilities:

·        Conducted one-on-one sessions with business users to gather data warehouse requirements

·        Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions

·        Created Logical and Physical models by using ERwin based on requirements analysis.

·        Developed normalized Logical and Physical database models  De Normalize design for HR applications

·        Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

·        Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.

·        Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.

·        Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.

·        Responsible for defining the naming standards for data warehouse.

·        Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems

·        Translated business concepts into XML vocabularies by designing XML Schemas with UML

·        Exhaustively collected business and technical metadata and maintained naming standards

·        Used IDA for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information

·        Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.

·        Participated in data anomaly resolution, data cleansing and development of cleansing rules for ongoing data synchronization.

·        Used Rational Team Concert (RTC) 3.0.1 for effective model management of sharing, dividing and reusing model information and design for productivity improvement

·        Conducted impact analysis for changing business requirements as per user needs

·        Studied in-house requirements for the Data warehouse to be developed.

·        Participated in performance management and tuning for stored procedures, tables and database servers.

·        Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)

·        Developed database design in HADOOP and Hands on experience in writing queries in HIVE, validating transformation logics in PIG.

·        Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase.

·        Developed necessary support documentation for end users, operations and testing teams.

·         Worked with UltiPro assist with testing, troubleshooting, support and involved in pulling HRIS payroll information from PeopleSoft to UltiPro.

·         Day-to-day responsibilities was configuration (HR/Benefits/Payroll tables), data conversion testing/validation, issue resolution, integration testing,

·         Understand on workflow/process, reporting, testing, and training/change management.

Environment: Erwin Data Modeler 9.x, Informatica Power Center 9.1/8.6.1, Windows XP/NT/2000, SQL Server 2008/2012, SQL, Oracle, Hadoop, Cogno’s 10, Framework Manager, Report Studio, Query Studio, Tableau, UltiPro, MS Excel, MS Visio, Rational Rose, Requisite Pro, SSIS, SSRS

 

      

 

        Allstate, Livermore, CA                                                                                                                                                    07/2011 –07/2014

        Role: Data Modeler

Project Summary: Business is interested in replacing existing legacy billing system with new Guidewire billing center and is         expected to provide lot of new features and up to date with the present market. As a part of which I am working on customizing   the Guidewire data base as per client needs, creating new efficient, scalable ODS (operational data store) and create xsd’s for web services for almost 25+ integration points and master send data from ODS.

Responsibilities:

• Working with business users to know the business requirements.
• Reverse Engineer Guidewire data model.
• Enhance/customize Guidewire database and maintain Guidewire database xml based changes in change log.
• Designed the ODS with core tables and now working on enhancing this model for additional master data. 
• Worked with ACORD XSD structure and Property and Casualty Insurance data model. 
• Used schema slicer to slice schemas (XSD) needed from ACORD and will be the first step in building the canonical XSD / ACORD Compliance.
• Created End to End database and service data mapping.
• Created reference data architecture.
• Created Logical Data Models and Physical Data Models using ERStudio Data Modeler.
• Created process flow diagrams by using MS Visio and maintained design document.
• Extensively using the Erwin design tool & Erwin model manager to create and maintain the versions of the Inland Marine data model. Created integrity rules and defaults.
• Created documentation and test cases, working with users for new module enhancements and testing.
• Used Toad for Data Analyst extensively for data analysis and writing stored procedures, sql prototypes as needed.

Environment: Sq1 Server 2005/2008, DB2, OBIEE, Oracle 10g/11i, Toad for Oracle 9.1 Expert, ER/Studio Data Architect 8.5.3,     MS Visio, JAVA, XML, XML SPY, Windows XP,  QC Explorer.

        JetBlue Airlines

Long Island City, New York City                                                                                                                                        05/2010 – 05/2011

Role: Data Modeler / Data Analyst

Project Summary: As a global airline carrying more than 100 million passengers and more than 500,000 tons of cargo a year, AMR promotes commerce, trade, and economic prosperity, as well as a sense of global community and citizenship. The project involves in the migration of the existing EJB Services to the Web Services. Migration involves validating the correctness of the existing data and designing the domain models required for understanding the existing structure and integrating new functionality.

Responsibilities:

·         Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.

·         Developed the UML class diagrams for the proposed system using Erwin Software Architect.

·         Performed data modeling using data modeling tool Embarcadero Data Architect.

·         Created the data models for OLTP and Analytical systems.

·         Performed in depth data analysis on Oracle and Teradata systems.

·         Extensively worked with the Teradata SQL Assistant and Toad.

·         Involved in data profiling to integrate the data from different sources.

·         Extensively performed the gap analysis and impact analysis.

·         Interacted with SME, developer to gather database requirements, actively participated in functional requirement gathering, system requirement gathering, application design

·         Created the data mapping document from source to target and the data quality assessments for the source data.

·         Worked with DBAs on support needs and provide guidance on architectural issues.

·         Assisted development teams with loading data, extracting data (ETL) etc.,

·         Assisted QA for developing test plans and test cases for Unit Testing, System Testing and Enterprise testing.

Environment: Oracle Database 10g, Teradata 12.0, Windows XP, TOAD 9.6, Power Designer , Erwin 8.x, Portal 1.5.2, Teradata SQL Assistant 13.0, JIRA.

 

        J. Knipper Health Care Marketing Solutions                                                                                                03/ 2007 – 04/2010

Lakewood, NJ                                                                                                                               

Role: Data Analyst

Project Summary: J. Knipper and company, Inc. has been dedicated to provide a broad array of healthcare marketing solutions, including comprehensive direct mail, fulfillment, sampling, database, and sales force management. The task was to develop a relational database system for improving marketing strategies and report generation. The data models developed were analyzed and value added.

Responsibilities:

·         Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.

·         Developed project plan with project manager’s assistance for the first two phases of the project.

·         Developed system flow and data flow diagrams for the proposed system.

·         Designed conceptual and logical data models.

·         Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using ERwin tool.

·         Normalized the tables up to 3NF.

·         Involved in the critical design review of the finalized database model.

·         Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.

·         Involved in designing and implementing the security for the databases.

·         Helped in migration and conversion of data from the Sybase database into Oracle 10g database, preparing mapping documents and developing partial SQL scripts as required.

·         Created stored procedures, functions, database triggers and packages as per the business needs for developing adhoc and robust reports. Incorporated Dynamic SQL, for generation of the where clauses dynamically based on the lexical parameters passed.

·         Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL*Loader.

·         Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Oracle Database 10g, SYBASE, Linux, Windows XP, Erwin, TOAD, SQL*PLUS, SQL*LOADER

 

SoftTech Inc

Pune, India                                                                                                                                                                          12/2005 – 01/2007

        Role: BI Developer

        Project Summary: The task of this project was to build a central repository of historic data warehouse that could support the       various reporting and information needs. Data was spread out in multiple and diverse sources in databases located in different regions. The requirement demanded a unified data pool.   

        Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solutions.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features and enhancements to existing technical business functionality.
• Created Logical and Physical Data Models using Erwin.
• Prepared business case for the data mart and then developed and deployed it.
• Experienced in creating Info Area’s. Info Cube’s, ODS from different source systems
• Used Star schema methodology in building and designing the logical data model in the dimensional Models.
• Mapped the data between Source and Targets.
• Used MS Visio for creating of process flow diagrams.<