Data Sql
Resume:
SWATHI KOLLI
******.*******@*****.***
PROFESSIONAL SUMMARY:
8+ years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Dimensional Modeling, implementation and Support of various applications in OLTP and Data Warehousing.
Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio and Power Designer.
Experience with different Data Warehouse architectures like Kimball and Inmon architectures etc.
Experience in modeling DW components (Staging area, normalize, and reporting DB (Star Schema / data mart/ODS).
Experience with Data Governance in managing the reference data and working with Master Data Management team.
Expertise in ETL tools likes Informatica (Power Center 9.1/8.6/8.1/6.2/1.7) for building Data Mart.
Knowledge on Big data, Hadoop, HDFS, Map Reduce and Hive.
Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures.
Experienced in SQL Server Performance Tuning, Query Optimization and running Database checked the physical and logical consistency of a database using DBCC Utilities.
Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
Created ERWIN reports in HTML, RTF, PDF format depending upon the requirement, published Data model in model mart, created naming convention files, coordinated with DBAs to apply the data model changes.
Experience in modeling a source system into the DW and participating in the generation logical and physical models.
Extensive experience in advanced SQL Queries and PL/SQL stored procedures.
Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
Experience with Agile data modeling development and Scrum Methodologies.
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.
Extensive Experience working with business users/SMEs as well as senior management.
Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
Excellent analytical, inter-personal and communication skills with a strong technical background.
Business Domains
Financial services - Brokerage, Trading, Portfolio management.
Insurance – Property and casualty Insurance, PI Claims.
Retail
Manufacturing
PROFESSIONAL EXPERIENCE
State Farm Insurance, Bloomington, Illinois (Oct 2015 - till date)
Senior Data Modeler/Analyst
Responsibilities:
Worked with Business Analysts and architects in gathering data requirements representing Data Architecture team.
Participation in weekly Data Governance meetings to analyze the requests from multiple application teams.
Worked on regulating data as per the ACCORD standards.
Working as a Data Modeler for an Enterprise level project, coordinating with development and ETL teams in design of logical and physical data models.
Modeling the tables as per the corporate standards using Erwin, generation of DDL and coordination with DBA in the creation of tables.
Designed and developed several mappings to load data from Source systems to ODS and then to Data Mart.
Design of Teradata data Warehouse tables as per the reporting requirements.
Developed ETL load SQL queries using Complex Joins which involves tables spanning the entire data model for the Teradata Data Warehouse.
Preparation of Report Mapping documents, Source to Target Mapping documents (STM) and for loading the data to Target tables.
Developed and reviewed SQL stored Procedures for the ETL development team.
Environment – Erwin Data Modeler r7.3, Teradata SQL Assistant 7.1, Oracle E-Business Suite, Teradata, Business Objects, Oracle SQL Developer, Microsoft SQL Server 2008 R2.
Morgan Stanley, New York, New York (Dec 2014- Oct 2015)
Senior Data Modeler
Responsibilities:
Participated in requirements session with IT Business Analysts, SME’s and business users to understand and document the business requirements as well as the goals of the project.
Worked on building of Conceptual, logical and physical data model using ER Studio as per the requirements, Reviewed the model with the Development and ETL teams.
Analyzed the source systems to understand the source data relationships along with deeper understanding of business rules and data integration checks.
Extensively worked on preparation of data mapping documents from XML data o ETL staging tables.
Worked on customizing and enhancing Teradata's Financial Services Logical Data Model (FSLDM).
Analyzed Business in Credit & Operational Risk Management, Financial Control, Legal & Compliance, Investment Banking, Trading/Settlement systems, Securities, Corporate Reference data, Accounting.
Worked on creating Complex SQL queries for loading the required data from Source tables.
Creation of DDL and DML scripts are per the standards.
Worked on Development and performance tuning of the SQL queries and PL/SQL Stored procedures.
Worked on fixing data quality issues like missing data, duplicate data and incorrect data entries.
UNIX Shell scripts are developed for DDL and DML operations on DB2 Data Warehouse tables deployed on UNIX platform.
Creation of data flow diagrams as per the requirements of the projects.
Environment – ER Studio Data Architect 9.0, MDM, DB2, Oracle 11g, UNIX, TOAD, SQL Navigator, Teradata, Informatica V9.5
Florida Power and Light, Juno Beach, FL (June 13- Nov 14)
Senior Data Modeler
Responsibilities:
Participated in requirement gathering session with IT Business Analysts, SME’s, business users and Sprint Teams to understand and document the business requirements as well as the goals of the project.
Worked on enhancements to the Data Warehouse model using Erwin as per the Business reporting requirements.
Analyzed the source system (Progress Databases) to understand the source data relationships along with deeper understanding of business rules and data integration checks.
Reviewed the Logical model and Physical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
Worked on Agile development methodologies like Scrum, coordinating with different Sprint teams.
Worked in the preparation of XML files mapping to Database tables as per the application development requirements.
Developed SQL Stored Procedures and Autosys Scheduler to load data into the database.
Extensively worked on SQL in analyzing the database and querying the database as per the business scenarios.
Creation of LDM and PDM for database using Erwin, coordinating with business to document proper metadata, definitions, UDP’s as per the corporate standards.
Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes, case by case for the facts and dimensions.
Environment – Erwin, Mortgage Express, Business Objects, Oracle SQL Developer, Microsoft SQL Server 2008 R2.
Toyota Financial Services, Torrance, CA (feb 11- May 13)
Senior Data Analyst
Responsibilities:
Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
Created the dimensional logical model with approximately 15 facts, 20 dimensions with 500 attributes using ER Studio.
Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.
Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes, case by case for the facts and dimensions.
Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
Worked with client and off shore team to make sure that the reports and dashboards are delivered on time.
Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System. Worked with the test team to provide insights into the data scenarios and test cases.
Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
Environment – ER Studio 8.0.3, Microsoft SQL 2008 Server, Microsoft SQL Management Studio, Microsoft SQL 2008 Integration Services, Teradata, Microsoft SQL 2008 Reporting Services, Microsoft SQL 2008 Analysis Services, Mercury Quality Center 9.
Qualcomm
Hyderabad, India. (May ’10- Dec’10)
Data Analyst.
Responsibilities:
Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
Created the conceptual model for the data warehouse with emphasis on mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users and Information architects to make sure all the requirements are fully covered.
Worked on rationalizing the requirements across multiple product lines.
Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
Created the logical model for the EDW with approximately 75 entities and 1000 attributes using ER Studio. The logical model was fully attributed till 3rd normalization and contains both current and history tables. Data model is divided in number of sub models for the ease of understanding and comprehension.
Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
Worked with DBA to create the physical model and tables. Worked on Informatica Data Quality tool for data cleansing, conformance and freshness of data.
Had brain storming sessions with application developers and DBAs to discuss about various de-normalization, partitioning and indexing schemes for physical model.
Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.
Environment – ER Studio 7.1.1, Quest Central for DB2 v 4.8, COBOL copybooks, Mainframe DB2, Mercury Quality Center 9, Informatica PowerCenter 8.1
EDUCATION
Bachelor of Technology in Electronics and Communications, JNTU, Hyderabad, India.
Contact this candidate