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:
Tools | SQL Plus, SQL Developer, TOAD, PLSQL Developer, ERWin, OBIEE 11g/ 10g |
Operating Systems | MS DOS, Windows 95/98/2000/XP/Vista/7, UNIX, Mac |
RDBMS | Oracle 11g/10g/9i/8i |
Programming Query Languages | C, SQL, PL/SQL, Java, XML, HTML |
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.