SUMMARY:

• 8+ Years of Experience in Data Analysis, Data Modeling, Data Mapping and OBIEE11G/12C helping organizations in their BI journey.
• Working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP.
• Excellent experience in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Proficient in data mart design, creation of cubes, identifying facts& dimensions, star & snowflake schemes.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Worked on OBIEE RPD and Web Catalog Administration. Have good understanding of setting up authentication and authorization for users and groups. Deep understanding of working on EBS OLTP and OLAP models.
• Solid understanding of Data Governance, Meta Data, Data Management and control; Adept in Data warehouse and Data mart architecture
• Hands on experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3, Glacier, ELB (Load Balancers), RDS, SNS, SWF, and EBS etc.
• Experience in Data Analysis, Data Modeling, Data cleansing, preparation of scenario based data and clarification of requirements with SME (Subject Matter Expert).
• Proficient in Oracle PL/SQL skills with packages, procedures and triggers.
• Implemented data clean up transformations, scripts and testing scenarios to unit and system test the deliverable.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Centre.
• Capable of handling different file formats like Parquet, Avro, JSON, XML and Flat Files.
• Experience in Informatica Data Quality (IDQ - Informatica developer … for cleansing and formatting customer master data.
• Provided thought leadership regarding Industry practices around collecting data, staging data, cleansing data, standardizing data, and publishing data into transactional systems and data marts.
• Experience in managing large amounts of data in multiple formats from disparate sources.
• Proficient in statistical concepts to solve complex analytical and business problems.
• Solid understanding of Data Governance, Meta Data, Data Management and control; Adept in Data warehouse and Data mart architecture.
• Designed and developed Informatic mapping codes to build business rules to load data. Extensively worked on Informatica Lookup, stored procedure and update transformations to implement complex rules and business logic.
• Experienced in Data Mapping, GAP Analysis, Traceability Matrices, SWOT Analysis, and Cost Benefit Analysis.

TECHNICAL SKILLS:

• SSIS
• SSSM
• DTS
• Data Analysis
• Data Modeling
• JSON
• AWS
• Oracle
• SQL server database development
• Netezza
• Tableau report creations
• Share-point Application development
• Base SAS
• R
• Tableau
• QlikView
• Weka
• Stata
• MS SQL Server
• Excel (Advanced)MySQL Workbench
• MS SharePoint
• InfoPath
• SSAS
• SSIS
• SSRS.
• SDLC Methodologies: Agile
• Waterfall
• Microsoft Office (Word
• Excel
• Outlook
• PowerPoint
• Access)
• VBA (Microsoft: Excel
• Access
• Word)
• MS Project
• MS PowerPoint
• Visio
• Rational Rose
• Requisite Pro
• Crystal Reports
• Clear case
• Clear quest

PROFESSIONAL EXPERIENCE:

Confidential -Iowa City, IA

Sr.Data Modeler and Business Intelligence Analyst

Responsibilities:

• Created and maintained logical and physical data models for test registration, test delivery, scoring etc., which supports various application across Confidential .
• Designed and developed different mappings using Oracle SQL, MongoDB, MySQL
• Extensive experience in developing DML, DDL.
• Developed, analyzed, and implemented JSON and XML data layouts for use in a microservices architecture and through API consumptions.
• Created values, tables, lookup tables, views, triggers for legacy, operational and staging tables and created mapping rules across databases which satisfy IMS standards.
• Worked on Databases and Schemas which in corporate CEDS data model.
• Architect/Technical leads to design and develop OBIEE RPD, Answers/Analysis and Dashboard etc.
• Mapped, cleaned and incorporated data changes between multiple databases (NoSQL and SQL) and data models.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests
• Designed & Developed dashboards, canned, ad-hoc reports using OBIEE, BI Publisher, Hyperion Interactive Reporting, scheduled the report jobs for email delivery.
• Created, modified and maintained multiple data models using TOAD Data Modeler.
• Developed ETL scripts for Oracle SQL and MySQL database with Informatica.
• Created and Maintained databases schemas, stored procedures, triggers, views.
• Developed reports and analyzed research data using R (R-Studio)
• Analyzed SQL packages and procedures and provide statistical reports.
• Responsible for writing all transformation logics for upstream (Oracle SQL) to staging (MongoDB) to downstream (Oracle SQL) and Reporting (OBIEE) data mart.
• Review Data Staging Model (Relational Model) and Data Mart Model (Dimensional
• Model) with ETL and Business Reporting (OBIEE) Team to confirm that the model satisfies the business needs.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to SQL reporting.
• Created mappings in Informatica MDM to load the data from Landing to staging tables.
• Supported operational data store and data warehouse to consolidate information in the areas of Test registration, Assessment Responses, Score data from multiple ERP systems: Oracle 11i, and in-house system.
• Developed SSIS Packages to consolidate date from multiple data marts, databases and Data loads from various types of sources files (Access, Flat files, CSVs) and developed Ad Hoc reports.
• Did work under complete Agile project model.

Confidential, Omaha, NE

Sr Data Analyst/ Data Modeler

Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Study Wall Street Finance's financial statements and analyze commodity prices, sales, costs, expenses and tax rates to determine a company's value by projecting its future earnings.
• Managed multiple Data Warehouse projects from inception to completion.
• Analyzed requirements and mapped to SharePoint out-of-the-box solutions and extend SharePoint capabilities.
• Designed and Developed different mappings using informatica.
• Extract data from Oracle as JSON file with PLSQL code
• Imported the JSON file into MongoDB Collections using mongo import utility
• Implemented data transport and processing using JSON and XML
• Working on upgrade to SharePoint 2016 project.
• Identified the granularity level of the business model based on the end user requirements.
• Extensively used OBIEE for customizing and modifying the three layers of the repository.
• Migrated reports from Hyperion to OBIEE. And Did UAT testing.
• Involved in creating custom Page Layouts and Content Types in SharePoint Designer.
• Developed logical data models and physical database design and generated database schemas using Erwin.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Coordinated with DBA to create best-fit Physical Data Model from the Logical Data Model using Erwin
• Generated DDL (Data Definition Language) scripts using Erwin and supported the DBA in Physical Implementation of data Models.
• Participated in ETL Functional Specifications Document (FSD) reviews and responded to questions related to the mappings, modeling and processing logic flows. Supported ETL with the development process.
• Imported JSON data by Mongorestore and imported CSV file via mongoimport
• Responsible for running the jobs in Informatica MDM and making sure right data gets into the HUB.
• Worked extensively in Data analysis and quality assurance
• Involved in establishment of framework for Data Governance companywide
• Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Used SharePoint Designer to make custom items filter, SOAP and REST connections in SharePoint farm.
• Generated POC ETL scripts using Teradata SQL for giving demo on complex business transformation logic to implement the backout logic
• Creates and generates adhoc reports through MS-Excel, Quality Spectrum Insight, MicroStrategy, and SQL to core EDW databases.
• Wrote features to filter raw data by JSON processor from BigQuery, AWS SQS, and Publishing API. The data was modified and uploaded to AWS DynamoDB by Python to ensure that the streaming data pipeline safety.
• Defined ETL framework which includes load pattern for staging and ODS layer using ETL tool, file archival process, data purging process, batch execution process
• Designed, Developed and Tested Data Security and Dashboard Security in OBIEE.
• Developed custom reports queries using OBIEE Answers and assigned them to application specific dashboards.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, and Oracle materialized views and making changes to reports.
• Participated in ETL Functional Specifications Document (FSD) reviews and responded to questions related to the mappings, modeling and processing logic flows. Supported ETL with the development process.
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Involved in processing of converting JSON files to XML, and CSV files and also maintained Audit log files and stats in Talend open studio.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent
• Worked as a Data Modeler/Analyst to generate Data Models using Erwin and subsequent deployment to Enterprise Data Warehouse.

Confidential, Atlanta, GA

Data Analyst / Data Modeler

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the data flow and Business Processes.
• Involved in Extraction, Transformation and Loading job of the data warehouse using Informatica.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata, to ensure accuracy of the data between the warehouse and source systems.
• Developed error handling & data quality checks in Informatica to pull out the right data
• Worked on relational database like MySQL and NoSQL database like MongoDB.
• Established join conditions on the tables in the physical layer and established cross database joins if the report demands the data from multiple databases.
• Based on the information required by user, the joins like Left/Right outer Joins are established in BMM layer.
• Used Tableau to develop dashboards for more intuitiveness as per the user requirements.
• Clear understanding of the concept of designing a business report because you can learn and implement that report in Crystal Reports or SQL Server Reporting Services or even with Microsoft Access Reports.
• Developed mappings in Informatica MDM to load the data from Landing to staging tables.
• Manage enterprise data quality services such as data profiling, data validation and quality score-carding.
• Organized meetings and discussions with client and end users to understand the project requirement ensuring the necessity of certified payment solutions for secure money movement.
• Delivered and supported operational data store and data warehouse to consolidate information in the areas of accounts payable, revenue, general ledger and labor cost distribution from multiple ERP systems: Oracle 11i, and in-house system.
• Analyzed, designed, developed, implemented and maintained 7 different multi-dimensional Data Warehouse databases using Microsoft SQL Server Analysis Services (SSAS) (OLAP) Cubes to provide full visibility of Wholesale, Retail, and Warehouse Point of Sale (POS) information.
• Performed numerous data pulling requests using SQL for analysis.
• Coordinated with DBA to create best-fit Physical Data Model from the Logical Data Model using Erwin
• Generated DDL (Data Definition Language) scripts using Erwin and supported the DBA in Physical Implementation of data Models.
• Work on SQL coding for overriding for generated SQL query in Informatica
• Consolidate and analyse financial data (budgets, income statement forecasts etc) considering company's goals and financial standing.
• Worked with Type 1 and 2 dimensions modeling, Fact Tables, Schemas design, Operational Data Store (ODS), levelling and other Data Warehouse concepts
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Functioned as the primary liaison between the ETL developers, PMs and Business team

Confidential - Stamford, CT

Data Analyst and BI developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules in Oracle SQL and MS SQL
• In Erwin DM creating Logical and Physical Model.
• Supported the customers for the HealthCare databases on the EDI transactions billing, Provider database, Medicare database and the Claims database supporting data warehouse.
• SQL data analysis identifying member Healthcare patterns for proactive health intervention initiatives, improving healthcare outcomes, reduce medical costs.
• Responsible for guiding the evolution of business intelligence and data services for the RSD data warehouse. Re-engineering and re-architecting data marts to use the bus architecture.
• Responsible for guiding the evolution of business intelligence and data services for the RSD data warehouse.
• Used various Informatica transformations like expressions, filters, joiners, aggregators, routers and lookups to load better and consistent data into the targets.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests
• Monitoring and improving performance of daily jobs on Oracle database.
• Handled the incentive program for warehouse employees; tracked data and communicated status of goals.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to SQL reporting.
• Designed and developed complex mappings to extract data from diverse sources including flat files, RDBMS tables, and legacy system files.