Data Analyst
Resume:
MADHULIKA C
*********.*****@*****.***
Professional Summary
Having around 10 plus years of extensive experience as a Data Modeler/ETL Developer/Business and Data Analyst/Business Objects developer.
Exposure in overall SDLC including requirements gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management and Business Objects Suite.
Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development.
Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation.
Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources and creating interface documents and proficient in Relational Database Management Systems (RDBMS).
Build and Developed ETL processes to retrieve data from multiple source applications into the Enterprise Data warehouse.
Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
Developed mapping documents like source to target data mapping.
Worked on physical naming standards, datatypes, domain definitions and corporate meta-data definitions.
Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
Excellent experience in SQL, PL/SQL, Procedures/Functions, Triggers, Cursors and Packages in Oracle 11i/9i/8i and SQL server.
Worked is Agile Methodology and involve in the sprint planning and grooming.
Worked as a team player with proven problem solving skills as well as independently with excellent communication and interpersonal skills and established track record of client interactions.
Technical Skills:
Data Modeling: ER Studio 11.0.1, Erwin r7.3 and DeZign for Databases V6.3.4
RDBMS: Oracle 8i/9i/10g/11g, DB2, MS Access and MS SQL Server 2005/2008/2012
Languages: C, C++, PL/SQL and SQL
Packages / Tools: SSAS, SSIS,Visual Studio 2012, Team Foundation server (TFS),MS Office, Toad
Reporting tools: Tableau, SSRS, Crystal reports 9.0/10/XI/2008, Crystal Enterprise 9.0/10/XI/2008, Business Objects 6.x/XIR1/XIR2/XIR2 SP2/XI 3.0, BO Universe Designer 6.X and SP2(X1), Web intelligence XIR2, Desktop intelligence XIR2 and People soft.
Professional Experience
Comcast, Philadelphia, PA
Lead Database Engineer Sept 2018 – Present
Description:
Working as Lead Database Engineer/Developer to develop Analyze Data for Call rate Ratio and Truck Roll ratio. Load data from multiple applications for reporting and Analysis purposes.
Analyze and track call Ratio’s and Truck Ratio’s for the organization.
Organize, extrapolate and disseminate data across departments to be used for drawing conclusions about the success of current methods.
Present detailed reports about the meaning of gathered data to members of management and help them identify scenarios utilizing modifications in the data.
Reported weekly data analysis findings to higher management to use in making organizational decisions
Participated in collecting, organizing and interpreting data along with other team members.
Worked with advanced calculations to draw conclusions about data findings
Collected requirements for Tableau reports and created requirement documents.
Assist in training 4 Co-ops for the data analysis.
Perform Extract Transform and Load (ETL) logic and write several stored procedures, SQL queries in the process of loading data into the warehouse.
Extensive use of SQL Server Management Studio (SSMS) during the process of Data Analysis, Data validation and Data Cleansing.
Validate the data and involve in the process of UAT with the users
Write several database objects like packages, stored procedures in the Microsoft SQL Server database environment.
United BioSource (UBC), Blue Bell, PA
Sr. Data Modeler / ETL Developer Feb 2016 – Aug 2018
Description:
Worked as Senior ETL Engineer/Developer to develop an Enterprise Data warehouse and load multiple applications related to health care into the warehouse for reporting and Analysis purposes. Some of the Source application were V3, CRM, Argus Data, Impact Data and Arcs.
Gather requirements for Design and Data Model the applications.
Thorough understanding of the applications and normalize and de-normalize entity relationship model.
Create Physical model from the Logical model using ER Studio.
Forward and Reverse Engineering, Publishing ER Studio diagrams, analyzing data sources and creating interface documents RDBMS.
Perform Extract Transform and Load (ETL) logic and write several stored procedures, SQL queries in the process of loading data into the warehouse.
Extensive use of SQL Server Management Studio (SSMS) during the process of Data Analysis, Data validation and Data Cleansing.
Developed SSIS Packages and extensively use SSAS to load data from multiple sources to an Enterprise Data warehouse
Validate the data and involve in the process of UAT with the users
Working with all types of schema including Star schema, Snowflake schema, Multi star schemas and Aggregate tables.
Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions
Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ER Studio diagrams, analyzing data sources and creating interface documents and proficient in Relational Database Management Systems (RDBMS).
Manages the design, modeling, documenting, and guiding of the logical and conceptual relationship of data and database changes for complex applications.
Write several database objects like packages, stored procedures in the Microsoft SQL Server database environment.
Comcast, West Chester, PA
BI Developer / Data Analyst October 2015 – Jan 2016
Description:
NDW warehouse has been created with the data related to the Growth Indicators for each application, which signifies the performance of each application in the company for budgeting purposes. The data from NDW is used to generate executive reports and dashboards.
Responsibilities:
Worked on multiple application with bringing in the data from multiple source systems in warehouse
Conducted sessions with business users to gather requirements for each application
Developed python scripts where needed
Thoroughly worked on SSIS packages to load data.
Created Detailed Design Document for each application
Worked with Facts and Dimension
Worked on creating tables, stored procedures and views.
Implementation is in Agile Methodology and involved in the sprint planning and grooming.
Responsible for data mapping and writing transformation rules.
Writing Complex SQL and PL/SQL procedures, Functions and Packages to load the data in the warehouse.
Worked on developing and retrieving data from OBIEE Dashboards
Extensively used SQL Server Management Studio (SSMS), MYSQL and ORACLE SQL Developer to run queries
Created Custom functions to evaluate the business hours and converting to time zone.
Legion Insurance (In Liquidation), Philadelphia, PA
Data Modeler / Data Analyst July 2011 – September 2015
Description:
Enterprise Data warehouse was developed for the company so that all the information for Policies, Claims, Accounting system (EAS), POC’s NOD’s and Reinsurance billing system (RBS) were designed and built into the warehouse.
Responsibilities:
Worked on multiple projects with different business units including Insurance actuaries.
Studied in-house requirements for the Data warehouse to be developed.
Conducted one-on-one sessions with business users to gather data warehouse requirements.
Developed a Conceptual model using DeZign based on requirements.
Developed normalized Logical and Physical database models to design for insurance applications.
Created dimensional model for the reporting (SSRS)/Cube system by identifying required dimensions and facts.
Designed a STAR schema for the detailed data marts.
Implemented Slowly Changing Dimensions - Type I, Type II and III in Dimension tables as per the requirements
Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified database design document with detailed description of logical entities and physical tables.
Design physical model and created the DDL scripts and source to target mappings (S2T- for ETL) to bring the data from Source system to the warehouse.
Forward Engineering to enhance the Data Structures of the Existing Database and Creating New Schemas.
Actively involved in Database designs discussions, identifying the Facts and Dimensions tables for building the Metadata Manager Data warehouse.
Generate Logical model in PDF format.
Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
Identified, formulated and documented Detail Design Document (DDD) and detailed business rules based on requirements analysis.
Build and Developed ETL processes to retrieve data from Company data sources.
Worked on creating tables, stored procedures and SSIS packages.
Worked with TFS (Team foundation server).
Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
Responsible for defining the naming standards for data warehouse.
Implementation is in Agile Methodology and involved in the sprint planning and grooming.
Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
Advance Auto Parts, Roanoke, VA
Data Analyst / BI Developer March 2009 – June 2011
Description:
EDW Phase II is an application implementing a Data warehouse to interface with the various mainframe-based systems, designed data model to provide global Reporting, Analysis, and Information Management and on-line reporting capability feature.
Phase 2 of the Core Merchandising System (CMS) project being implemented includes the capture, maintenance and execution of Purchase Orders (POs) in CMS instead of on the current mainframe-based system
Responsibilities:
Involved in gathering business requirements and translated business requirements.
Interacted with users and application architects for getting the requirements.
Involved in Full Project Life Cycle (requirement gathering to implementation phase to closing phase).
Designed/captured the business processes & created the conceptual data model.
Created and maintained Logical Data Model (LDM) / Physical Data Modeling for the Order Provisioning system. Includes documentation of all entities, attributes, data relationships, primary and foreign key relationships, allowed values, codes, business rules, glossary terms, etc.
Responsible in designing and introducing new (FACT and Dimension Tables).
Responsible for collecting information from SRS (System Requirement Specifications) for data mapping.
Responsible for data mapping and writing transformation rules.
Developed the data model using ERWIN & printed reports to support the data dictionary.
Created Logical and Physical model database and dimension database in DB2.
Normalizing the Data and Developed the Database in Star & Snow flake schema.
Built Data marts and developed procedures and packages for populating the data from the Data Warehouse.
Actively involved in Database designs discussions, identifying the Facts and Dimensions tables for building the Metadata Manager Data warehouse.
Writing Complex SQL and PL/SQL procedures, Functions and Packages to validate data and testing process.
Provided help to fellow ETL developers, assisting them with troubleshooting.
Used Informatics power center for (ETL) extraction, transformation and loading data from source systems.
Designed staging tables, to load data from various sources.
Good understating of all the projects supported by the team and played an important role in production support.
Walt Disney World, Orlando, FL
Data Analyst / BI Developer August 2008 – February 2009
Description:
Worked as a BI Developer in building Universes, WebI and DeskI based on Guest information projects like Guest information and Organization Informations. Designed and developed complex reporting for upper management.
Responsibilities:
Creating Universes and designing classes and objects using Universe Designer on XI R3.
Resolving loops using aliases and contexts by checking the integrity and also developed user objects.
Interacted with Business Users and Business Owners to understand their Business views in developing and modifying Universes and Reports accordingly.
Involved in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications for Business Objects Universe and Reports.
Involving in Resolving Problems like 'Chasm Trap' and 'Fan Trap'.
Created reports using different data sources like Database tables, stored procedures, command prompt and Universes independently and in combination.
Creating formulae using both the crystal syntax and the basic syntax to use in the reports and for reusability.
Created Custom functions to evaluate the business hours and converting to time zone.
Using dynamic cascading prompts and static parameters for different record selection criteria.
Built reports using drill down and hierarchal grouping functionalities of crystal.
Created alerts and filters in several reports.
Exporting reports into various formats like Editable RTF, XML, PDF, HTML, EXCEL, and WORD using Crystal Reports XI for user.
Involving in the administration of Central Management Console (CMC) for implementation of security at Report level, Folder level. Created Users, user groups.
Used Infoview to schedule crystal, Desktop Intelligence and Web Intelligence reports to deliver them to clients.
Creating various object Attributes, Facts, Filters, Attribute element Prompts.
Publishing objects to Business Objects XI 3.1/R2/R1 Enterprise system using Import Wizard, Publishing Wizard, Infoview and CMC.
Used Schedule Manager to change the database parameters for multiple reports at once while migrating reports between environments.
Extensively used TOAD (Oracle) and Teradata Query analyzer (Teradata).
Interaction with the End users for the Functional requirements and Design specifications
Gather the business requirements, Analysis of user requirements and outline the proposed IT solution.
Offered training to Business users in using Infoview to schedule, run and view the report instances.
Address business needs. Assist business analyst in performing functional testing.
EDUCATION:
University of Central Florida Orlando, FL
Master of Science in Electrical Engineering and technology 2006 -2008
Jawaharlal Nehru Technological University Hyderabad, India
Bachelors of Technology in electronics and communication 2002- 2006
Contact this candidate