We provide IT Staff Augmentation Services!

Lead Data Analyst Resume Profile

NY

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.

Hire Now