Data Analyst

SUMMARY:

Over * years of experience in IT industry specializing in Data Warehousing in large scale Data warehouse Applications including; Data Transformation (DT), Data Extraction/Conversion, User Interface, Integration Testing, Optical networking and Software Testing.

Worked with various data sources like Oracle, SQL, MS-Access, flat files. Project experience includes working directly with the users to better understand tasks and reporting needs.

Experience with the full Software Development Life Cycle (SDLC), which includes Requirements, Planning, Analysis, Design, Agile Development, Testing, Implementation and Support.

Data Discovery, Analysis and Classification, Reference and Data Quality Analysis, Domain Data Profiling, Reconciliation Testing, Data Monitoring, Sanity Checks, Alerts; RACI Matrix, and Data Stewardship.

ETL Architecture, hands-on Development, Workflow & Dataflow Diagrams, Workflow Automation, Reconciliation Testing.

Extensive experience in OLAP & Reporting Layer Development with MS SSAS OLAP Cubes and a variety of tools.

Master Data Management (MDM), Common Reference Data (CRD), Data Governance, Business Rules Engine.

Creative approach to solving problems, multiplied by vast experience, ability to work independently, assuming multiple roles on a project, always striving to meet and exceed client / user expectations.

Good Knowledge of Health care and Financial domain encompassing Mortgage, SOX compliance procedures & Regulations.

Worked in teams with large and small sizes successfully by supporting the team members in research, analysis, implementation, development and production.

Strong analytical, technical, communication and interpersonal skills.

TECHNICAL SKILLS:

Tools/IDEs: Oracle SQL Developer, TOAD, Oracle Enterprise manager,

SQL Monitor, MS-office 2000/2005/2007/2010,

AUTOSYS, Informatica, Cognos.

Operating Systems: Windows 95/98/XP Professional.

Language: SQL, PL/SQL.

Database: Oracle 9i/10g/11g, OLAP, OLTP,

MS-Access 2000/2005/2007/2010.

Functional Domain: Health care, Fixed Income, Risk Management, SOX & Mortgage systems.

PROFESSIONAL EXPERIENCE:

Quality Life Healthcare Services - South Holland, IL Nov 2013 - Present

DataWarehouse Analyst

Responsibilities:

Identify data anomalies for identified data sources and review results with users and data stewards

Created source to target mappings with transformation rules

Wrote SQL Queries for Data Accuracy, Data Analysis and Data Extraction needs.

Created requirements for data modelers like minimum, maximum values, acceptable range, null acceptance etc

Hands on with HIPAA, Facets, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.

Created data set reports for users by writing SQL queries which then were used for UAT

Define data dictionaries for identified sources by working with data stewards and subject matter experts

Worked with ETL developers with data mapping specifications

Participated in initiating, planning, executing aspects of the project

Reviewed project deliverables and ensure adherence to Communicate with hospital executives regarding the status of specific projects

Interface with all areas affected by the project including distributors, end users and vendors

Weekly monitoring of Clarity effort and adjustments based on staff input

Ad Hoc adjustment of Clarity tasks, effort or staff assignments based on approved Change Controls

Heal 10 Integration updates in clarity

Environment: RUP, Java, SQL, UML, MS Word, Visio, PowerPoint, Excel(Pivot Tables), and Project, Share Point 2010, ProClarity, Business Intelligence development studio(ETL),Data Warehouse, SQL server Management Studio, Harvest,CA Clarity, FIX, SWIFT

Best Med Healthcare - Chicago, IL April 2012 – Oct 2013

Data Analyst

Responsibilities:

Processed large Excel source data feeds for Global Function Allocations and loaded the CSV files into Oracle Database with SQL Loader utility.

Performed code Inspection and moved the code into Production Release.

Documented all the Relative activities in Quality Centre and coordinated with QA team.

Performed Data filtering, Dissemination activities, trouble shooting of database activities, diagnosed the bugs and logged them in version control tool.

Performed source data analysis and captured metadata, reviewed results with business. Corrected data anomalies as per business recommendation.

Created source to target mappings for multiple source from SQL server to oracle. This was used by ETL developers.

Performed the batch processing of data, designed the sql scripts, control files, batch file for data loading.

Performed the Data Accuracy, Data Analysis, Data Quality checks before and after loading the data.

Coordinated with the Business Analyst Team for requirement gathering and Allocation process Methodology, designed the filters for processing the Data.

Designed and developed the Database objects (Tables, Materialized Views, Stored procedures, Indexes), SQL statements for executing the Allocation Methodology and creating the OP table, CSV, Text files for business.

Performed the physical database design, normalised the tables, worked with Denormalised tables to load the data into fact tables of Data warehouse.

Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.

Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into base tables.

Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for Data Accuracy, Data Analysis and Data Extraction needs.

Designed star schema with dimensional modeling, created fact tables and dimensional tables.

Involved in data analysis, data discrepancy reduction in the source and target schemas.

Designed and developed the star schema Data model, Fact Tables to load the Data into Data Warehouse.

Implemented one-many, many-many Entity relationships in the data modeling of Data warehouse.

Developed the E-R Diagrams for the logical Database Model, created the physical Data Model with Erwin data modeler.

Analyzed the tables once the imports were done.

Edited the Database SQL files with Vi Editor, used Unix Commands like Cron, Job scheduling, Executing files, Process, Background, Grep etc

Written PERL Scripts to extract the data from Oracle Database, checking the database connections, regular expressions etc.,

Developed the VBA Integration with Excel feeds and SQL database, SQL Extraction, Transformations of Excel Data into SQL database.

Involved in writing Oracle PL/SQL procedures, functions, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.

Involved in debugging and trouble-shooting of database objects.

Involved in Data loading and data migration – Used SQL * Loader to load data from excel file into staging table, Data Cubes and developed PL/SQL procedures to load data from staging table into base tables of Data warehouse.

TOAD, SQL Developer tools were used to develop programs for executing the queries.

Worked with SQL Query performance issues. Used index logic to obtain the good performance.

Involved in the monitoring of database performance in Enterprise Manager Console.

Created the XML control files to upload the data into Data warehousing system.

Environment: Oracle 11g, Data Warehouse, OLAP, SQL Navigator, SQL Developer, Erwin 4.0, XML, OLTP, MS-Excel 2000, MS-office 2000, Microsoft XP Professional.

Freddie Mac - McLean, VA. Feb 2011 – March 2012 Data Analyst

Multifamily Secondary Mortgage is one of the Major Business divisions of Freddie Mac corporate. This division handles the Mortgage Loans for Multifamily. The IT Division handles systems, which process the Data for Multifamily Underwriting I&E Group.

Also worked in Multifamily production Support Group for Financial light enhancement projects.

Responsibilities:

Understood the Business of Multifamily group of Freddie Mac by discussions with Business Analyst.

Migrated the data from oracle 9i version to 10g using the oracle migration work bench with all the Database objects & Data.

Proof Reading of the conceptual, logical and physical model of financial business Applications for General ledger and Asset Resolutions.

Studied, Suggested & Modified the keys, Attributes and relationships of database physical model.

Designed & Developed SQL queries on oracle 10g Database for Data Analysis, Accuracy & Anomalies.

Created tables, Views, Indexes in oracle DB, Analyzed the queries with SQL Trace for Data Integration.

Designed and Developed the cross Tab Reports and worked on various formulas as per the need of Business users.

Designed the Test Data Models, data for UAT and Staging Databases.

Discussed and Gathered the Requirements from Business users to enhance the Financial Applications.

Suggested for updations for the Table Design, Definition of Tables and stored procedures to enhance the mortgage Applications.

Environment: Oracle 9i/10g, SQL Navigator, SQL Loader, Oracle Enterprise Manager, MS- Excel 2000, MS-office 2000, Windows XP, Rational Clear case.

Citi Group, Global Corporate Investment Bank June 2008 – Dec 2010

India

Data Analyst

Data Analyst in GCIB (Global Corporate Investment Bank), one of the Major business division of Citigroup corporate that handles the Capital Markets and Trading Functions of the London and New York operations. Various products supported by this system are Derivatives for confirmations, Breaks, Equity, Collateral, Settlements, Trade captures and financial controls. The Trade Bookings are stored in financial front end systems

of MS-Access 2000 Database.

Responsibilities:

Study and understanding the Business of GCIB and its operations by discussions with Business Analysts.

Designed and Developed the Database logical and physical Model, SQL Tables, Queries for Breaks processing in Oracle database.

Analyzed the existing Database for the performance and redesigned the Model for improving the performance of the system.

Developed the stored Procedures, SQL Joins, queries for data retrieval, accessed for analysis and exported the data into CSV, Excel files.

Designed and developed SQL scripts, stored procedures, and views for data processing, maintenance etc., and database operations.

Performed the SQL Tuning and optimized the database.

Enhanced the Technical Document for Global functions Allocations operations.

Imported the Excel Sheet, CSV, Delimited Data, advanced excel features, ODBC compliance data sources into oracle database for data extractions, data processing and business needs.

Designed and optimised the SQL queries, Pass through query, make table query, joins in MS-Access 2003 and exported the data into oracle database server.

Handled huge volumes of Data for confirmations, swaps, Breaks and generating Reports for the Senior Management.

Designed and developed Data processing procedures for Implementing Business Rules and accessing the Oracle Database systems.

Queried and extracted the Data from oracle Database for Analysis.

Environment: Oracle 10g, OLTP, Windows XP Prof, MS-Access 2000, MS-Excel 2000.

ADDITIONAL INFORMATION:

EDUCATIONAL QUALIFICATION: Bachelor’s in Computer Science and Engineering at JNTUH, INDIA.

Contact this candidate