SUMMARY

• Data Analyst with expertise in Data Analysis, Database Design, Modelling, development, maintenance Installation etc., Worked with various data sources like Oracle, IBM DB2, Sybase, SQL Server, SQL, MS - Access, Excel files, flat files.
• Project experience includes working directly with the users to better understand tasks and reporting needs. Self-motivated, quick learner and strong problem solving skills.
• Experienced as Database Analyst in Database Management Systems.
• 8+ Yrs of experience as Data Analyst in Relational database systems & other ODBC compliance Data sources.
• 7+ Yrs of experience in data analysis, data profiling and data mapping.
• 2+ Yrs of experience in UNIX (Sun Solaris) Operating system.
• 3+ Yrs of experience in Data Warehouse environment.
• Good knowledge of Informatica Power Center, Power Designer 9.x, Data flux Data Quality tool.
• Excellent knowledge of Health Care, Banking, Global Supply chain management, Mortgage business domains.
• Experience in all phases of the Software Development Life Cycle (SDLC) - design, development, testing and maintenance.
• Good Knowledge of Health care, Mortgage, SOX compliance procedures, policies & 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.
• Self-motivated, quick learner, team player, independent, accountable & problem solver.

TECHNICAL SKILLS

Tools: /IDEs: Oracle SQL Developer, TOAD, SQL Navigator, SQL DeveloperOracle Enterprise manager, SQL Server Enterprise ManagerSSAS, SSRS, SQL Analyser, Informatica Power center 9.xPerformance monitors, SQL MonitorSybase ASE, Winsql, MS-office 2000/2005/2007/2010 , MS-Visual source safeMS-Project plan, MS-Visio, TFS

Operating Systems: Unix System V, Sun Solaris 7/8, Windows 95/98/XP Professional.

Language: SQL, PL/SQL, Unix Shell scripting.

Database: Oracle 9i/10g/11g, SQL Server 2005/2008, SybaseOLAP, MDM, OLTP, MS-Access 2000/2005/2007/2010 .

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

PROFESSIONAL EXPERIENCE

Confidential, BUFFALO, NY

Data Analyst

Responsibilities:

• Studied and understood the Reinsurance and Risk Adjustment policies, calculations & data by studying the Requirement documents.
• Interacting with Business Analysts team to get the business related data for enrollments, Medical and Pharmacy Claims.
• Studied and understood the data model of Facets for Enrollments, Medical and Pharmacy claim modules.
• Prepared and delivered the data mapping documents for Enrollments, Medical and Pharmacy claims.
• Profiled the data in the EDW for Enrollments, Medical and Pharmacy claims for data Anomalies, Duplicates, Nulls, bad data and documented in the template.
• Discussed and designed the Intermediate data tables between the source and target outbound XML files.
• Studied and understood the outbound XML files which will be placed on Edge Server for CMS.
• Designed and developed the SQL queries, Joins required for data analysis and profiling for all Claims and Enrollments data.
• Studied the Enterprise Data warehouse model related to Facets for Enrollments and Claims Processing.

Environment: IBM DB2, Winsql, Informtica power Center 9.xOracle 10g, Data modeling, XML, NormalizationData Warehouse, ODS, SQL Navigator, SQL DeveloperErwin, XML, OLTP, MS-Excel 2010, MS-office 2010Microsoft XP Professional.

Confidential, Jersey City NJ

Data Analyst

Responsibilities:

• Analyzed the queries and developed pl/sql procedures with SQL Developer tool.
• Created, scheduled and monitored the stored procedures to perform file operations, ASCII data loading, process excels files, email operations to send automated emails attachments to the business managers and upload all of them into the Data warehouse.
• Monitored the pl/sql package for FI data loading into the data warehouse server connection.
• Created the Database objects (Test Tables, Views, Joins, Indexes etc.,) for development operations and tested the same to move the code into production Release.
• Designed and developed the logical & Physical database model, performed the system Analysis from the specification provided by the Business Analyst Team.
• Designed the star schema Data model and Fact Tables to load the Data.
• Developed the UNIX shell scripts, created batch jobs, create Indexes, Analyzed tables once the
• Imports are done.
• Automated the data loading, extraction with UNIX shell scripts.
• Edited the Database SQL files with Vi Editor, used Unix Commands like Cron, Job scheduling, Executing files, Process, Background, Grep etc.,).
• Involved in writing Oracle PL/SQL packages, 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.
• Performed the Data loading and data migration - Used SQL * Loader to load data from excel file into staging table and developed PL/SQL program to load data from staging table into base tables.
• Designed & Developed the Dimensional Data model, Data Mart, staged the Data in the Fact tables of the Data warehouse.
• Worked with Database Aggregates (Min, Max, Count, Sum, Avg) to speed up the Queries in Data warehouse.
• Used TOAD, SQL Developer tools to develop SQL and execute DDL, DML, DRL and DCL operations.
• 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 file, control files to upload the data into Data warehousing system.
• Worked with the core team to gather business requirements from multiple stakeholders, accounting, operations and management groups - and reconciled conflicts by conducting Joint Application Development (JAD) sessions based on the project scope.
• Analyzed Business Requirements and segregated them into high and low level Use Cases and Activity Diagrams using MS Visio.
• Performed GAP analysis involving the current state and proposed state.
• Worked closely with other BAs and ETL Leads/Managers and was responsible to perform detailed data requirements analysis and create design specifications and operational documentation.
• Provided the ETL team with the Data mapping document and helped them to create the ETL mappings.
• Extensively worked with Query Studio to test the Framework Manager models.
• Worked closely with the architects, database administrators and technical team during Data Mapping and Data Integration.
• Organized meetings with the SMEs and Data Owners to walk through the findings and determine the cleansing process.
• Participated in various sessions with Business to understand the business rules and to come up with naming conventions to standardize the data.
• Conducted JAD sessions with Management teams and Decision support teams to elicit, Collect and agree upon requirements for BI Reports.

Environment: Windows XP, MS Visio, oracle 10g, Informatica power Center 9.x, TOADSQL, SQL Developer, Oracle Enterprise manager, ERWINMicrosoft Office (Word, Excel, Access, Outlook).

Confidential, Washington DC

Data Analyst

Responsibilities:

• Analyzed the queries and developed pl/sql for Data Anomalies in SQL Developer tool.
• Created, scheduled and monitored the stored procedures to perform file operations, ASCII data loading, process excels files, email operations to send automated emails attachments to the business managers and upload all of them into the Data warehouse.
• Monitored the pl/sql procedures for consensus forecast data loading into the data warehouse server used flat file connection.
• Created the Database objects (Test Tables, Views, Joins, Indexes etc.,) for development operations and tested the same to move the code into production Release.
• Designed and developed the logical & Physical database model, done system Analysis from the specification provided by the Business Analyst Team.
• Designed the star schema Data warehouse Data model, Fact Tables to load the Data for Data Integration.
• Designed and developed the ER Diagrams for the logical Database Model in Erwin data modeler.
• Developed the UNIX shell scripts, created batch jobs to create Index and Analyze tables once the Imports are done.
• Automated data loading, extraction, report generation with UNIX shell scripts.
• Edited the Database SQL files with Vi Editor, used Unix Commands like Cron, Job scheduling, Executing files, Process, Background, Grep etc.,).
• 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 and developed PL/SQL program to load data from staging table into base tables.
• Used Erwin for designing Database both logical and physical data modeling of Data Warehouse.
• Designed and developed the ODS, Data Cubes for ETL process for the Data Warehouse.
• Extracted & published the Meta Data on the Front end XML files from Data warehousing tables.
• Designed & Developed the Dimensional Data model, Data Mart, staged the Data in the Fact tables of the Data warehouse.
• Worked with Database Aggregate, Row, Conversion functions to speed up the Queries in Data warehouse.
• TOAD, SQL Developer tools were used to develop programs and executed 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 Manger console.
• Created the XML file, control files to upload the data into Data warehousing system.

Environment: Oracle 10g, Data Warehouse, ODS, Data cubesSQL Navigator, SQL Developer, Erwin 4.0, XML, OLTPMS-Excel 2000, MS-office 2000, Sun Solaris 7.0, Microsoft XP professional.

Confidential, McLean, VA

Data Analyst

Responsibilities:

• Understood the Business of Multifamily group of Confidential 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 & Modifed 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, Analysed 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 ManagerMS-Excel 2000, MS-office 2000, Windows XP, Rational Clear case.

Confidential

Data Analyst

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.
• Analysed 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, views for data processing, maintenance etc., 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, Sun Solaris 7.0, Windows XP Prof, MS-Access 2000, MS-Excel 2000.

Confidential, New York

Client/Server Developer

Responsibilities:

• Designed and Developed the GUI, General, class Modules for data processing system for AP press.
• Designed and developed the RS 232 Serial communication for com port using the Microsoft VB API.
• Programmed with VB 6.0 common controls, forms, General, class modules for application processing.
• Complied, executed, debugged, code walk through of the application and used all the features of IDE.
• Created standard exe applications and installed on system users machine for data processing.
• Created a system log file, application log file logging the application execution and error message.
• Performed unit, functional, Integration testing of the application developed.

Environment: Visual Basic 5.0, MS-Access 97 and Windows 95/98.

Confidential

Client/server Developer

Responsibilities:

• Designed and Developed the Client Server 2 Tier applications for Business clients in Middle East, Germany & USA for IT operations & technology group.
• Performed the system Analysis, Requirement gathering and documentation of the applications, products.
• Programmed with VB 6.0 common controls, forms, General, class modules for application processing.
• Complied, executed, debugged, code walk through of the application and used all the features of IDE.
• Designed the Database tables, views, procedure, queries for database operations.
• Created Installable applications & products for clients on need basis, Deployed and supported successfully.
• Performed unit, functional, Integration testing, white Box, black box testing of the application developed.

Environment: Visual Basic 5.0, SQL Server 7.0, MS-Access 95MS-office 95/98, Windows 95/98, UNIX server, Oracle.