Professional Summary

• Over 8 years of experience in Data Analysis, Requirement Analysis, Report Design, Report Creation and updating existing reports.
• I develop/update excel reports by gathering referrals and sales information from asset management and Investments system.
• With the gathered information, I evaluate the Number of referrals, number of qualified referrals, and associate sales revenue for each month and for each business area.
• The end result of this particular reporting decreases possible future errors and minimize time taken in creating non-qualified referrals also preparing the business segments to achieve their referrals targets.
• Expert in prioritizing and meet certain deadlines, maintain open communication with other teams/departments, researching skills when errors occur, and become familiar with division-wide data applications
• Experienced extensively in PL/SQL and SQL for mission critical project with US Client.
• Expert in converting Functional specs to Technical Specs.
• Experience in working with DWH Data Warehouse environment and Data Modelling using Erwin Tool.
• Understanding ETL concepts and performing mapping logic validation.
• Capable to execute large analysis Project with greater understanding and in depth knowledge about data flow.
• Regular interaction with Oracle CRM and Finance modules.
• Ability to organize/distribute teamwork and lead them in technical or Functional issues.
• Proficient at interviewing stakeholders and end users, and in translating users' statements of needed system behavior and functionality into Business and Technical Requirements.

Technical Skills:

Confidential

Role: Lead Data Analyst

Role Responsibilities:

• Data Analysis for Referrals, Pipeline, Opportunities, and Performance to plan areas.
• Report outputs are being generated for Asset Management Group and Retail line of business
• Created PL/SQL program units cursors, loops, joins, procedures, functions packages
• Managed the oracle data structures such as tables, indexes, synonyms sequences
• Optimized complex SQL queries to support reporting needs
• Understanding ETL concepts and performing mapping logic validation
• Worked with Transactional and Multi-Dimensional Databases, Data Warehousing, Star and Snowflake Schemas
• Analyze application problems, recommend and develop solutions
• Produce and maintain program code and documentation
• Analyzed SQL from reporting with performance issue and suggested index creation where required.
• Write efficient, complex queries against very large data sets using PL SQL Developer and TOAD
• Worked with basic UNIX shell script, JavaScript and HTML for reporting needs
• Demonstrated analytical and problem-solving skills
• Team work for Successful release.

Environment: Toad, Windows XP, Oracle 10g/11g, SQL, TOAD

Confidential

Role: Lead Data Analyst

Role Responsibilities:

• Analyze Client data, documentation and create reports to exercise good judgment in identifying issues and driving resolution.
• Performance tune and maintain existing sql and reports with in depth understanding of data.
• Used database concepts and data modeling fundamentals for different phases of project
• Created PL/SQL program units procedures, functions packages
• Managed the oracle data structures such as tables, indexes, synonyms sequences
• Optimized complex SQL queries to support reporting needs
• Updated data models conceptual and logical data models
• Worked with basic UNIX shell script, and JavaScript and HTML for reporting needs
• Understanding ETL concepts and performing mapping logic validation
• Worked with Transactional and Multi-Dimensional Databases, Data Warehousing, Star and Snowflake Schemas
• Reports are developed for Business Development Officers, Analysts and Managers role.
• Reports are being generated for Asset Management Group.
• Team work for Successful release.

Environment: Oracle 11g/10g, SQL Developer, BI Publisher 10.1.3.4, Toad, Windows XP

Confidential

Role: Data Analyst

Role Responsibilities:

• Proposed estimation and Architecture.
• Worked closely with Business Users in understanding the requirements and to identify and refine business requirements and translate Design Specifications in to Technical Design Document.
• Data Analysis for home equity submission, Minus SQL Creation, Report Development in BI Publisher.

Environment: Oracle 11g/10g, BI Publisher 10.1.3.4, Toad, Web Logic Server 10.3.3, SQL Developer, Windows XP, Linux.

Confidential

Role: PLSQL Developer and Data Analyst

Role Responsibilities:

• Starting from requirement gathering to required report development with UAT. Report are based on commission requirement for analyzing companies performance based on actual and target activities.
• Designed, implemented, and maintained new enterprise systems
• Performed PL/SQL coding
• Effort Estimation for PL SQL component development
• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectations.
• Used P SQL developer tool to create and run scripts and enhance Data base performance for end reports.

Environment: Oracle 10g, Unix Shell Scripting, MS Excel, Flat Files, SQL Server 2008/2005, PL/SQL, Windows.

Confidential

Role: PLSQL Developer

Role Responsibilities:

• Understanding the Functionality of existing process.
• Developed and maintained system documentation, including technical specifications, data mapping, program logic, and flowcharts
• Resolved application performance issues in very large RDBMS environments
• Provide detailed technical support for all PL/SQL code identifies and analyze queries and stored procedures for optimization
• May perform shell scripting as needed
• Analyze existing programs or formulates logic for new systems
• Devise logic procedures
• Test/debug application modules
• Develop conversion and system implementation plans
• Recommend changes in development, maintenance, and system standards

Environment: Oracle 9i, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL Loader, SQL Plus, PL/SQL, Windows 2000, UNIX Sun Solaris , TOAD, PL/SQL Developer.