SUMMARY

• An Information technology professional with more than 6years of extensive experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of various web - based applications in OLTP, Data Warehousing, and OLAP applications.
• Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams with all related entities and relationship with each entity based on the rules provided by the business manager using ERWIN
• Worked extensively in forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Published Data model to acrobat PDF files, extensively created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBAs to apply the data model changes
• Extensive Experience on Creating Visualization Dashboards using Tableau and Alteryx.
• Very large database optimization and performance tuning to address data latency requirements utilizing performance analysis, execution plans, Bitmap Indexing, Partitioning, Materialized Views, Parallel Queries, Merge and Pipelines
• Deep Knowledge within SAP BW including ETL, data modelling and frontend development.
• Enterprise-wide applications security and compliance, corporate standards, and best practices
• Collaboration software (SharePoint), technical specifications and system documentation
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of Data warehousing using Fact Tables, Dimension Tables, star, and snowflake schema modeling.
• Strong experience with Database performance tuning and optimization, query optimization, index tuning, caching, and buffer tuning.
• Extensive experience in backend programming including Database table design, Stored procedures, Triggers, Indexes, Performance tuning in DB2/Netezza/Teradata and Oracle
• Good knowledge in analysis and reporting using various Business Intelligence tools such as Cognos and Business Objects.
• Excellent verbal, presentation, and written communication skills. Able to communicate with technical, non-technical and senior management audiences. Have played a significant role in requirements planning, client interaction and documenting.
• Excellent problem-solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
• Decomposition and documentation of Business Lineage and Technical Lineage.
• Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
• Highlighted Data Quality issues and areas of system control gaps.
• Linked data lineage to data quality and business glossary work within the overall data governance program.

TECHNICAL SKILLS

Data modeling: Erwin,(8.2,8.1,7.3.5) Power designer,Embarcadero

Databases/Tools: Teradata,12.0Netezza, Oracle 15g/11g MS SQL Server 2014, MySQL, Sybase 11.5/11.2, MS Access, Cobol Copybook, Mainframe Files, DB2 UDB, XML, SQL Navigator, Toad

ETL Tools: Alteryx,Informatica PowerCenter 8x, 7x/6.1, 5.1, DataStage.

BI Tools: Tableau, SAP BW,Business Objects, Cognos,OBIEE,Crystal Reports 2008

Architectures: OLAP, OLTP, OOP, SOA, Client-Server

Databases: Teradata, SQL SERVER, Oracle, Mongo DB

Operating Systems: UNIX, Linux 7.0+, Macintosh 9+, Windows 95/98/2000/XP

Programming Languages: C, C++, JAVA, XML, HTML, SQL, JavaScript, Perl, PHP, Shell Scripting, webservices.

Software Engineering Tool: Rational Rose, Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, DALLAS

SENIOR BI / DATA ANALYST

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.
• Worked Extensively on Various Projects implementing Database changes in the respective Data Models and implementing Reverse Engineering of Database Structure to enhance the models and also comparing the models to in corporate changes
• Created complex KPI Dashboard using Tableau and Alteryx
• Created tasks, workflows, and schedule, run, monitor sessions by using workflow manager and workflow monitor
• Extensively used Erwin and Normalization Techniques to design Logical/Physical Data Models, relational database design.
• Created 20 workflows using Alteryx
• Experience in handling, configuration, and administration of databases likeMySQLand NoSQL databases likeMongoDBand Cassandra.
• Ability to recognize and resolve discrepancies between executed DDL and the physical data model using complete compare
• Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
• Decomposition and documentation of Business Lineage and Technical Lineage.
• Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
• Highlighted Data Quality issues and areas of system control gaps.
• Linked data lineage to data quality and business glossary work within the overall data governance program.
• Analyzed data quality issues through Exploratory data analysis (EDA), using SQL, python and pandas
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Developed tableau data visualization using cross tabs, Heat maps, whisker charts, scatter plots, pie charts and bar charts.
• Worked extensively with advanced analysis actions, calculated fields, parameters, trend lines and maps.
• Unearthed raw data by doing Exploratory Data Analysis (Classification, splitting, cross-validation, Regression).
• Data transformation from various resources, data organization, features extraction from raw and stored data.
• Converted raw data to processed data by merging, finding outliers, errors, trends, missing values, and probability distributions in the data.
• Worked on developing ETL pipelines on S3 files on data lake using AWS Glue
• Mastered the ability to design and deploy rich Graphic visualizations with Drill down and drop-down menu option and Parameters using Tableau.
• Converted existing BO reports to tableau dashboards.
• Worked on creating automation scripts leveraging various python libraries to perform accuracy checks from various sources to target databases.
• Collaborating with the project managers and business owners to understand their organizational processes and help design the necessary reports
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: AWS,Glue,Tableau 2018.2/2019.2 , Alteryx, Teradata, SAP BW, Mongo DB,Netezza, Oracle 9i/10g/11g,Sql Server 2008/2012/2015 , DB2 LUW, DB2 ZOS, Unix AIX 5.2, Linux, ERWIN 7.3/8.28

Confidential, ST.LOUIS,MO

DATA ANALYST

Responsibilities:

• Extensively worked on various database impacts on CMS application once the impacted changes are known in project requirements review.
• Extensively worked with Model maintenance project where all the Data models which are not to up to standards making them standardized
• Writing implementation plans to implement the database changes into QA and Production environment
• Coordinating with DBA in implementing the Database changes and updating Data Models with changes implemented in development, QA and Production
• Created Data dictionary using ERWIN modeler.
• Involved in Low level Design for the scripts of the database sequences, constraints, triggers, and stored procedures.
• Knowledge of Merging several flat files into one XML file.
• Extensively worked on creating, Altering and Deleting the Tables in different Development Environments and Production.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc.
• Extensively worked with logical models to change them into complete physical models from where we can implement these models into database.
• Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
• Extensively worked with developers on analyzing the impacted changes on respective applications based on which design approach is taken and same changes are implemented in database with help of DBA.
• Created physical models for the applications which do not have any physical models from logical models.

Environment: Oracle 9i/10g/11g,Sql Server 2005, Toad 8.6 for Oracle, DB2, Unix AIX 5.2, Linux, ERWIN 7.3/,, Flat Files, Hyperion 8.3.

Confidential, BOSTON,MA

DATA ANALYST

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Worked on the Data Warehouse team analyzing data files that had to be compiled from disparate non-production sources and readied them for production. Tasks included: comparing data to requirements documentation, creation of data layouts, data dictionary, and the pipe delimited and fixed width files. In addition, was team lead for managing the completion and loading of these files for the Data Management group
• Developed Loading Scripts for Teradata database using Fast Load Utility
• Participated as member of a project team performing various lifecycle tasks for an intranet application with Oracle database for tracking public offering orders. Developed logical and physical database models and data dictionary documentation. Worked as liaison between users and developers refining and explaining user requirements.
• Worked with Teradata utilities Fast Load to develop loading scripts to mock the Data
• Assess data quality requirements in terms of data completeness, consistency, conformity, accuracy, referential integrity, duplication and evaluate vendors (Informatica Data Explorer/Data Quality, identify and measure data quality, design and implement data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
• Develop data quality reports/dashboards with Cognos Framework Manager and Report Studio.
• Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc.
• Designed a Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin.
• Worked as a Data Warehouse and Database Developer. Core responsibility is to interview with customers and subject matter experts to gather the requirements for a proposed database analyze these requirements and source systems required to build the data warehouse using Data Warehouse Builder.
• Data Architect in a centralized group doing logical and physical data models in ERWIN. Also, wrote database interface specifications and documented in Data Manager data dictionary.
• Designed Informatica ETL Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.
• Extensively used Erwin and Normalization Techniques to design Logical/Physical Data Models, relational database design.
• Experience with utilities Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
• Conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, data dictionary, publishing model to PDF and HTML format, generating various data modeling reports etc.
• Extensively involved in creating, maintaining, updating documents like requirement document, database design document, System design document, naming standard procedures, SOPs etc.
• Analyzed and optimized the existing business processes using Conceptual Models and Data Flow Diagram. The process included performance enhancement requirements assessment and mapping of existing workflow and data flows.

Environment: Erwin,, DB2v7, XML/XSD, Qwest Center, MS SQL Server, Teradata, RedHat Linux Shell Scripts, PL/SQL, IBM Control Center, Informatica Power Center v 8.6.1, Cognos v8, Tunnelier, Test Track Pro, TOAD, PVCS, Microsoft Project Plan