Sr.data Modeler/analyst Resume
Houston, TX
SUMMARY
- 8+ years of professional experience in Data Modeling, Data Analysis and design of OLTP and OLAP systems.
- Extensive experience in the Data Warehousing implementations for Retail, Financial, Insurance and Banking Industries.
- Experience in designing star schema (identification of facts, measures and dimensions), Snowflake performance in relational and dimensional database environments.
- Strong experience working with conceptual, logical and physical data modeling considering Meta data standards.
- Worked extensively schema for Data Warehouse, ODS architecture by using tools like Erwin data modeler, Power Designer, Embarcadero E - R Studio and Microsoft Visio.
- Having good knowledge in Normalization and De-Normalization techniques for optimum on XML data and XSD schema designing.
- Experience working with Agile and Waterfall data modeling methodologies.
- Experience in designing a canonical model.
- Experience in Ralph Kimball and Bill Inmon approaches.
- Extensive experience analyzing and documenting business requirements and system functional specifications including use cases; facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
- Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.
- Worked with various RDBMS like Oracle SQL Server DB2 UDB, Teradata.
- Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
- Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.
- Experience in SQL and good knowledge in PLSQL programming and developed Stored Procedures and Triggers.
- Experienced in Data loading using PL/SQL Scripts and SQL Server Integration Services packages (SSIS).
- Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
- Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
- Having very Good exposure to ETL tool like Informatica.
- Building reports using SQL SERVER Reporting Services SSRS Crystal Reports and Business Objects.
- Experience in using and Database Tools for TOAD for data analyst.
- Excellent communication skills, self-starter with ability to work with minimal guidance.
TECHNICAL SKILLS
Data Modeling Tools: Erwin Data modeler7x/6x/5x Rational Rose 2000, MS Visio ER Studio 16.0.3, ER Studio 11.0
Databases & Database Tools: MSSQL servers, Oracle, MS Access, Teradata, DB2, TOAD 9/7 Data Stage, Informatica 8, Visio, SVN, SQL
Reporting Tools: Congo's 8, Business Objects XI, Crystal Reports, Actuate Reports 10, OBIEE
Programming Languages: UML, XML, XSD, XSLT, HTML, JavaScript, .Net, C, C++, and Java, PL/SQL
PROFESSIONAL EXPERIENCE
Confidential, Houston TX
Sr.Data Modeler/Analyst
Responsibilities:
- Working with business users to gather the business requirements.
- Initially phase designed the specialty marine data model for Contractor's Equipment and now working on enhancing this model for additional Inland Marine product offerings.
- Worked with ACORD XSD structure and Property and Casualty Insurance data model.
- Created lot of reference data for this application.
- Worked extensively with XSD, WSDL.
- Maintaining change logs, Sub models.
- 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.
Environment: ORACLE 11g, Erwin Data Modeler 9.2, Erwin Model Manager 9.2 MS Visio, JAVA, XML, XML SPY, Windows XP, WSFTP Pro 99, QC Explorer.
Confidential, Houston TX
Sr.Data Modeler/Analyst
Responsibilities:
- Gather the various requirements from the business analysts.
- Reverse Engineering the existing data marts and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
- Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the Dimensions involved.
- Designed a STAR schema for sales data involving shared dimensions (Conformed) for other subject areas using Erwin Data Modeler.
- Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
- Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
- Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
- Ensured the feasibility of the logical and physical design models.
- Worked on the Snow-flaking the Dimensions to remove redundancy.
- Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
- Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
- Worked closely with the ETL Developers to explain the complex Data Transformation Logic.
- Employed naming standard editor for defining new naming standards for the entities, attributes, domains, columns and tables that applied consistently all over the enterprise.
- Extensively used the SVN and help Developers creating Tags as per the releases in all the layers, DEV, SIT, UAT, PROD and keeping consistency across the environment
- Provided source to target mappings to the ETL team to perform initial, full, and Incremental loads into the target data mart.
Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Crystal Reports 7.5/8.0, Windows 2000, Micro strategy 9.3, Crystal Enterprise8.0, Erwin, Informatica Power Center, power designer, CSV files, XML files.
Confidential, Barrington, IL
Data Modeler/Analyst
Responsibilities:
- Involved in gathering requirements from Business System Specialist and also involved in discussions with BSS for dashboard design.
- Involved in Analysis, profiling and cleansing of source data and understanding the business process.
- Built ODS integrating the source systems for ad-hoc reporting.
- Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
- Built conceptual, logical and physical models using Erwin.
- Used Normalization techniques to normalize the data in ODS.
- Forward engineered the physical data model and generated DDL script using Forward Engineering option in Erwin.
- Identified facts and dimensions based on KPI and also identified the source tables.
- Built Conceptual, Logical & Physical start schema using Erwin.
- Created STTM documentation for data mart integrating different source systems.
- Involved in documentation of Data Mapping and ETL specifications for development from source to target.
- Implemented the change Data Capture (CDC) while integrating the enterprise data sources.
- Created Indexes and Partitions to optimize the performance.
- Assisting ETL Team, BI team and end users to understand the data model.
- Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
Environment: Erwin 9.5, Oracle 11g, JDE 9.0, IBM Data stage 11, Congo's Framework Manager, SQL Developer, MS Office, Crystal Reports, Flat files, Shell Script, Teradata
Confidential
Data Modeler/Analyst
Responsibilities:
- Worked with business analyst to gather information on requirements
- Documented Technical & Business User Requirements during requirements gathering sessions.
- Gathered business requirements through interviews, survey with users and business analysts.
- Involved in preparing logical data models and conducted controlled brain-storming sessions with project focus groups.
- Conducted team meetings and JAD sessions
- Involved in business process modeling using UML through Rational Rose.
- Used Rational Requisite Pro to document technical requirements and business user requirements.
- Worked with analysts to create reporting universes in Business Objects. Provide mentoring, guidance and training on how to use the Business Objects reporting and analysis tools.
- Implement Cognos FM, cube and report development to support business user to identify opportunities for improvement in operations and processes
- Created logical data model from the conceptual model and its conversion into physical database design.
- Extensively used star schema methodologies in building and designing the logical data model into dimensional models.
- Involved in dimensional modeling, identifying the facts and dimensions.
- Implemented referential integrity using primary key and foreign key relationships
- Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
- Used Erwin tool for relational database and dimensional data warehouse designs
- Reverse Engineered DB2 databases and then forward engineered them to SQL Server 2000 using Erwin, Power Designer
- Produced entity/process relationship matrices, entity-relationship graphs, efficient decomposition diagrams and statistics flow diagrams
- Developed logical data model using Erwin and created physical data models using forward engineering in generating DDL scripts and creating indexing strategies
- De-normalized the database to put them into the star schema of the data warehouse
- Created documentation and test cases, worked with users for new module enhancements and testing
- Understood existing data model and documented suspected design affecting the performance of the system
- Conducted logical data model walkthroughs and validation
- Supported clients of the CSG and AMDOCS billing system and Report Store application in a Tier 2/3 capacity by addressing issues related to functionality, reporting tools, CSG, AMDOCS developments.
- Identify the potential customers from the given data base and counsel the organization on ways of converting them to loyal customers as a part of CRM.
Environment: DB2, SQL Server 2000, Hyperion Essbase, Informatica Power Center, Erwin r8, Microsoft Visio, Rational Requisite Pro, Rational Rose, Windows 2003 Server.
Confidential
SQL DBA
Responsibilities:
- Installation of SQL Server 2008 R2 with latest Service Packs
- Involved in Migrating SQL Server R2
- Wrote SSIS Packages to migrate users, logins, stored procedures, and tables
- Used SQL Server Management Studio to manage the SQL Server Analysis Services(SSAS)
- Used SSRS to produce our own reports
- Worked performance tuning, Query optimization, using Perfmon, profiler.
- Worked in Active/Passive and Active/Active Clustered Environment
- Extensively involved in Database Mirroring
- Configured Log Shipping in SQL Server 2012
- Database monitoring and maintenance, Database performance using EMC Greenplum
- Extensively involved in replication and Implemented Snapshot, Transactional Replications
- Involved in semiannual Disaster Recovery Testing drills
- Identified flaws with DR Strategies and offered suggestions of improvement
- Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from Sql server database to oracle database.
- Implemented 11G and Upgraded the existing database from Oracle 9I to Oracle 11G.
- Performed Database Backup, Recovery, and Transfer operations
- Used Quest Lite speed 6.1.0 for back up and compression
- Wrote custom scripts and jobs to manage backups due to lack of disk space
- Installing applications and establish the connectivity with the database
- Maintained tables, indexes
- Used Idea Diagnostic Manager for Monitoring solutions Troubleshooter issues related to database space.
- Used Ticketing System Software BMC remedy to track issues in Environment and to troubleshoot issues by opening a ticket with Microsoft team for technical support
- Worked in both Production and Testing Environment
- Doing 24x7 production support on rotation basis
Environment: MS SQL server 2008 R2/2005, Windows 2008 R2/2003 Enterprise edition, SQL profiler, Idea Diagnostic Manager, SQL Light speed Backup Software
Confidential
SQL Server DBA
Responsibilities:
- Helped the development team in deploying and testing the application, which uses SQL Server as backend.
- Participated in migration and implementation planning.
- Extensively involved writing stored procedures and Triggers in MS SQL Server.
- Interacting with the users and troubleshooting the problems.
- Migrated all the servers from SQL 2005 to SQL 2008 R2 servers.
- Maintained more than one TB size databases.
- Configured log shipping between production and DR servers.
- Managed databases for 4 different billing applications running on databases size up to 160 GB.
- Migrating SQL Servers from old servers to new servers.
- Installing service pack 1 CU3 for SQL Server 2008 R2 on all production Dev and QA servers.
- Involved in requirements gathering, documenting the requirements, developing, testing and implementing the system.
- Designed and created a Multidimensional model using MS SQL Server Analysis Server.
- The metadata structure was designed to populate OLAP data.
- DB Refreshes from Production to Test and Development based on user requirements.
- Job Scheduling & Re-Scheduling on Production Databases.
- Performance Monitoring on Production Databases.
- Good exposure on Performance Tuning and T SQL Scripts. Created users, groups and setting up privileges and accesses.
- Performed monitoring and tuning of databases. Involved in preparing documentation for migration and implementation
- Resolved the trouble tickets as soon as possible
- Data Transfer using DTS and BCP for transferring data across severs and also from different database sources. Scheduled the DBCC commands to control the Database and Log file growth
Environment: SQL Server 2008 R2, SQL Server 2005 & 2000, PL/SQL, Advanced Server, VMware, Recovery Point, VB Script, Oracle, Excel, Visio, Access, ASP.Net, VB 6.0, ERWIN, MS SQL Reporting Services, Performance monitor
