Lead Data Modeler / Data Analyst Resume Marlborough, MA - Hire IT People (2024)

SUMMARY

• Over 10 years of professional experience in data modeling, designing, and data analysis with Conceptual, Logical, and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Extensive experience in the Data Warehousing implementations for Financial, Insurance and Banking Industries
• More than 5 years of experience working with data modeling tools like Erwin and ER Studio
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, E - R Studio and Microsoft Visio.
• Experience in handling business and technical issues & communicating with both business users and technical users
• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas
• Strong understanding of dimensional and relational modeling techniques. well versed in Normalization / Denormalization techniques for optimum performance in relational and dimensional database environments
• Experience with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration
• Good Knowledge in designing the data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling techniques
• Worked extensively on XML data and XSD schema designing
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using Erwin tool
• Experience in creating project progress reports. Conducted workflow, data analysis, and GAP analysis to derive requirements for existing system enhancements.
• Involved in implementing the Referential Integrity by using Primary and Foreign key relationships
• Good Knowledge in designing the data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling techniques.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD/JAR sessions
• Quick learner, self-motivating and enthusiastic to work with new technologies. Good team player and have strong ability to work under high stress environments.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena

TECHNICAL SKILLS

Data Modeling Tools: Erwin Data Modeler, Rational Rose 2000, ER Studio

Reporting Tools: Oracle Reports, Business Objects, Crystal Reports 2008

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

Operating Systems: Windows NT, 2000 & XP, Vista

Languages: SQL, PL/SQL, T-SQL, HTML, C, XML

Others: MS Office, TOAD, SQL Navigator, E Mortgage - MISMO

PROFESSIONAL EXPERIENCE

Confidential, Marlborough, MA

Lead Data Modeler / Data Analyst

Responsibilities:

• Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications.
• Extensively involved in developing logical and physical data models that fit in exactly for the current state and the future state data elements and data flows using Erwin
• Defined the key columns for the Dimension and Fact tables of both the Warehouse and Data Mart
• Interacted with the End users frequently and transferred the knowledge to them
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and Development teams to gather, analyze and document the Business and reporting requirements.
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
• 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.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Explained and guided Front end Developing team on the database architecture and built objects for effectively accessing the database.
• Maintain change log and history tables for each data model and solved the production issues by debugging the code.
• Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.

Environment: Oracle 10g, PL/SQL, Erwin 7.2, Microsoft Excel, MS Word, Power Point,TOAD for Oracle Version 8.6.0.38, and SQL developer for Oracle, XML

Confidential, Somerset, NJ

Senior Data Analyst/Data Modeler

Responsibilities:

• Responsible for project management, logical and physical OLTP database and data warehouse modeling, ETL mappings, data analysis and integration, XML schemas, and functional and technical specifications
• Implemented and maintaining DR strategy for BCP-DRP (Business Continuity Plan - Disaster Recovery Plan)
• Optimized and updated logical and physical data models to support new and existing projects
• Maintained conceptual, logical, and physical data models along with corresponding metadata
• Provided the means of system integration by understanding the source and target data and built the data mapping
• Maintained high-level data architecture documentation, which illustrates the source and destination of data to and /or from approved data sources
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models
• Performed Data Analysis for building the reports and building Enterprise Data warehouse(EDW)
• Defined timelines for project delivery and provided the status update to the client team on a regular basis
• Created entity/process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams
• Assisted with project and problem analysis, effectively communicated with management and adhered to firms policies and procedures

Environment: Erwin, Microsoft Access, SQL Server 2000, MS PowerPoint, MS Access, Lotus Notes, Microsoft Excel

Confidential, New York, NY

Data Modeler/Data Analyst

Responsibilities:

• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project
• Coordinated with DBA on data base build and table normalizations and de-normalizations
• Understanding clients’ information needs, business objectives, and market sectors and implementing appropriate data analysis strategies
• Recognized and extracted critical indicators from large and complex data sets and interpreted and expressed those indicators in the business context
• Designed and maintained processes for measurement, tracking, reporting, and analyzing traffic and user experience
• Maintained the quality of data analysis, researched output and reporting, and ensured that all deliverables met specified requirements
• Communicated directly with clients to clarify requirements and present research findings and ensured clients received coherent service
• Developed SQL and PL/SQL scripts to perform data cleansing and PL/SQL procedures to populate date and time dimensions
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process
• Created mapping specification spreadsheets to document the transformation logic
• Worked with Model Manager and multiple data marts, involving multiple subject areas simultaneously, domains and Naming Standards
• Coordinated with Business Analyst and designed logical and physical data models as per the requirements
• Conducted and participated in JAD sessions with the project managers, business analysis team, finance and development teams to gather, analyze, and document the business and reporting requirements

Environment: Oracle 9i/10g, MS SQL Server, DB2, Oracle SQL Developer, PL/SQL, Business Objects, Erwin, MS office suite

Confidential, Lakewood, NJ

Data Analyst/Data Modeler

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 the forward engineering in 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, ER/Studio, TOAD, SQL*PLUS, SQL*LOADER

Confidential

Data Analyst/Developer

Responsibilities:

• Analysed the business requirements of the project by studying the Business Requirement Specification document.
• Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks
• Created a logical design and physical design in Erwin.
• Maintained security and data integrity of the database
• Identified the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Extensively used Erwin for developing data model using star schema methodologies.
• Created Entity relationship diagrams (ERD), Function relationship diagrams(FRD), data flow diagrams(DFD) and enforced all referential integrity constraints using Erwin data modeling tool
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Good knowledge and experience on Global Custody operations, capital markets, securities services, vendor management operations, trade finance, trade settlements, income processing, tax, corporate actions, market claims and reconciliations, NAV generations

Environment: Oracle 8i, SQL, PL/SQL, Erwin, SQL*Loader, Perl, TOAD and UNIX.

Confidential

SQL developer

Responsibilities:

• Gathering business requirements from business users
• Designed Logical and Physical models of Relational Database
• Built strong relationships with key business and technology partners inside and outside the platform and infrastructure team
• Partnered with finance, MIS teams, and accounting to ensure the consistency and accuracy of data and reporting
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer
• Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL
• Wrote stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems
• Involved in developing scripts for validating the data and maintenance of security and integrity of database
• Created scheduled batch jobs using PL/SQL for downloading data into temporary tables to generate the data required for some of the reports
• Worked with the team of business analysts, developers and end users for generating audit reports and troubleshoot the related queries and fix the connectivity issues

Environment: Erwin, SQL Server, Crystal Reports, MS Office, Windows 2003