SUMMARY

• Extensive experience in disciplined software development life cycle (SDLC) process and familiar with Agile, Scrum, and Waterfall methodologies.
• Experience in relational, dimensional, and multidimensional data modeling for creating conceptual data modeling.
• Experience in designing of star schema, snowflake schema for online analytical processing (OLAP) and online transactional processing (OLTP) systems.
• Experience in building data marts, data quality reports, data profiling, data analysis and data archives.
• Proficient in Normalization/De - normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
• Experience in data analysis to track data quality and for detecting/correcting inaccurate data from the databases.
• Experience in data transformation and data mapping from source to target database schemas and data cleansing.
• Performed extensive data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Experience in performance tuning and query optimization techniques in transactional and data warehouse environments.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) tools.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data warehousing environments.
• 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.
• Conduct data analysis, mapping transformation, data modeling and data-warehouse concepts.
• Experience in designing Logical, Physical & Conceptual data models for to build the Data Warehouse.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Worked in a quality driven process to deliver objects adhering to timelines.
• Strong leadership skills
• Strong Client-facing Skills with good interpersonal skills.
• Excellent troubleshooting skills
• Excellent Team leader

TECHNICAL SKILLS

ETL Tools: Informatica 9/8, Data Junction, Ab-Initio, Data Stage, SSIS

RDBMS: Oracle 10g/9i/8i, Teradata 14/12, DB2, SQL Server 2000/2005/2008, MySQL, Sybase, JIRA

Modeling: SQL Data modeler, Oracle Designer, MS Visio and SAP Power Designer

QA Tools: Quality Center

Operating System: Windows, Unix

Reporting Tools: SSRS,Tableau, Business Objects6.5, Power BI

Languages: SQL, PL/SQL, T-SQL, Base SAS,Python

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Sr. Data Analyst

Responsibilities:

• Established data standards and policies,datamodeling, systems architecture design, and migration system architectures to ensure access to and integrity ofdataassets.
• Analyzed changes in online transactional processing, business processes, and external information sources and recommends modifications, to improve quality of applications and meet additional requirements.
• Assisted development team in the design of new BI solutions.
• Worked with product owner and business users to understand and translate user stories and/or requirements into data models, analytics reports and scenario models
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Developed standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise
• Worked with Business Analysts and potentially business customers to verify requirements for datawarehouse and resulting reports.
• Created SQL Jobs to schedule SSIS Packages
• Handled performance requirements for databases in OLTP and OLAP models
• Created design documentation for relational and dimensional datastructures
• Designed and implement datawarehouse tables and datamarts for consumption by report and ETL developers
• Focused on the delivery of engagement results to the client, require involvement in several engagements simultaneously and the coordination of other resources involved in a specific project phase
• Defined the strategy and roadmap for BI Analytics, Enterprise DataWarehouse tools, and future state reporting architectures to meet enterprise needs; research and educate on the use of BI platforms for strategic decision making.
• Evaluated, developed and identified specifications, best practices, integration and proper use of emerging technology as they relate to overall reporting architecture.
• Used MS VISIO for relational database design.
• Experienced in debugging and performance tuning in SQL Server and SSIS to meet performance requirement.
• Extensively used Star Schema Technologies in building and designing the Logical data model into Dimensional Models.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Prepared excellent documentation in the MS developers understands the concept of the project.

Confidential, Lafayette, LA

Data Modeler

Responsibilities:

• Interacted with clients while designing internal and externaldata interfaces to ensure that database development needs are according to client specifications.
• Coordinated with clients, externaldataproviders, and business team to ensure that business model is accurately represented and understood by all relevant parties.
• Created/maintained the Enterprise Business Intelligence data architecture to increase the robustness, performance, and scalability of systems.
• Create ETL Processes and reports using Microsoft SQL Server Suite (SSIS, SSRS) and other data integration tools like Informatica.
• Responsible for the development of logical data models and physical data base designs applied across multiple computing environments
• Documented the business definitions for the entities and attributes
• Communicated and syndicated business entity model with key IT and business stakeholders
• Data Profiling and Analysis
• Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and dimension tables using Erwin.
• Architectand designed data virtualization and abstraction solutions.
• Used business requirements to document clear and concise technical database and ETL design.
• Maintained design and naming standards
• Created DDL, View SQL, and contribute to performance tuning.
• Contributed to project planning discussions, provide status updates for development progress and be a critical resource for issue resolution.
• Collaborated with report builders on design for optimum performance
• Gathered and translated business requirements into detailed, production-level specifications, new features, and enhancements to existing technical business functionality.
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Prepared High-Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.

Confidential, Northbrook, IL

Data Modeler

Responsibilities:

• Analyzed business requirements and functional specifications to guide in building an efficient model by interacting with Business Analysts and Subject matter experts.
• Identified the key facts and dimensions necessary to support the business requirements for dimensional modelling.
• Coordinated with DBA on database build and table normalization sandde-normalizations
• Participated in mapping logical data models to physical data models and co- ordinated business requirements for data.
• Prepared analytical and status reports and updated the project plan as required.
• Migrated Packages from DTS to SSIS.
• Responsible for Master data management in identifying each instance of a business element and representing these instances using a standardized data model.
• Developed Data Mapping, Data Governance, Transformationand Performed reverse engineering of Physical data models from database and SQL scripts.
• Initiated and conducted JAD sessions for various teams to finalize the required data fields and their formats.
• Created the cubes with Star Schemas using facts and dimensions through SQL Server Analysis services (SSAS).
• Developed standard methodologies for standard naming conventions and coding practices to maintain consistency of data models.
• Participated in data architecture sessions and promoted integrated systems and controlled data redundancy.
• Worked proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Prepared Dashboards using Calculations, parameters in Tableau.
• Performed data profiling on unstructured data collected from various sources which were used for data analysis.

Confidential

Data Analyst

Responsibilities:

• Prepared and documented detailed specifications of the programs utilized to pull data including creation and use of documents to facilitate the request and data integrity of the data that is provided to the internal customer.
• Participated inUAT sessionsto educate the business users about the reports, dashboards and theBI System
• Worked with the test team to provide insights into the data scenarios and test cases.
• Worked on dataprofiling anddatavalidationto ensure the accuracy of the data between thewarehouse and source systems.
• Applied second and third NF to normalize existing ER data model of OLTP system.
• Performed complexdata analysisin support of ad-hoc and standing customer requests.
• WroteMySQLqueries from scratch and created views onMySQLfor reporting.
• Coordinate with business users to Outline work plans, determine resources, documented timelines, and generated initial protocols for resident's safety with a data-driven, process-oriented mindset with analytical skills.
• Build Data Pipeline to automate daily reports based on student database by writing SQL queries and integrating with Tableau, which resulted in 20% more productivity and saved resources from manual work.
• Consolidate data, developed operations, and procedures, improving workflow by 18%.
• Designed MS SQL scripts to automate data transformation for data loads and extracts.

Confidential

Data Analyst

Responsibilities:

• Prepared and documented detailed specifications of the programs utilized to pull data including creation and use of documents to facilitate the request and data integrity of the data that is provided to the internal customer.
• Worked with Data investigation, discovery and mapping tools to scan every single data record from many sources.
• Created and reviewed the conceptual model forthe EDW (Enterprise Data Warehouse) with business users.
• Implemented the standard naming conventions for the fact anddimension entities and attributes of logical and physical model.
• UsedModel Mart of Erwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Participated inUAT sessionsto educate the business users about the reports, dashboards and theBI System
• Worked with the test team to provide insights into the data scenarios and test cases.
• Worked on dataprofiling anddatavalidationto ensure the accuracy of the data between thewarehouse and source systems.
• Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management.
• WroteMySQLqueries from scratch and created views onMySQLfor reporting.