We provide IT Staff Augmentation Services!

Sql Report Analyst Resume

Islandia, NY

Professional Summary:

  • Around 9 years of professional experience in Information Technology Industry in Analysis, Design, Development and Implementation of various projects with expertise in various platforms, Software Tools and Application Packages.
  • Data modeling experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
  • Experienced in extracting developing complex reports.
  • Expertise in data modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and logical data modeling.
  • Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions.
  • Experienced working with database such as MS SQL Server, ORACLE and DB2.
  • Extensive usage in writing, testing, implementation of the Stored Procedures, Triggers, Functions, Packages at Database level and Form level using PL/SQL.
  • Expertise in standardizing and automating reports by using wide range of data sources and tools like Excel , Crystal Reports and SAS
  • Extensively utilized Unix Shell scripts embedded with SQL queries in executing jobs
  • Ability to work in a team environment or independently and handle multiple tasks concurrently.
  • Ability to adapt to any environment and a quick learner.

Technical Skills: Operating Systems: AIX 5.3/5.4, RHEL4, Sun Solaris 2.8, AT & T UNIX 3.x, Linux 2.4.9, Windows NT 4.x, Windows 2000 Languages: C, C++, Java, Visual Basic, JSP, HTML, DHTML, SQL, PL/SQL Scripting: ASP, Java Script, VB Script Tools: MS Access, MS Excel, Crystal Report, SQL server 2000/2005.

PROFESSIONAL EXPERIENCE

Confidential, Islandia, NY Jan'09 - Dec'10

SQL Report Analyst

Responsibilities:
  • Interacted with executive management to gather and analyze user requirements.
  • Extensively participated in use case analysis, feasibility study and design of the project.
  • Designed the database models based on star and snow flake schema.
  • Prepared detailed specifications in accordance with department standards.
  • Developed well-structured, easily-maintained, efficiently operating program code from moderate to high-level functional specifications for new and existing programs. Identifies areas where additional definition is required to obtain information.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Creation of databases and database objects like tables, indexes, views, and stored procedures, triggers functions.
  • Formulated test plans and tests and debugs developed programs. Participates in user acceptance testing.
  • Worked with clients and business analysts to identify client needs and alternative solutions.
  • Prepared estimates of work effort.
  • Used excel features like pivot table, pivot charts, data refresh in developing business reports
  • Extensively utilized Unix Shell scripts embedded with SQL queries in executing jobs
  • Reports status, activities and issues to project team leader in accordance with department standards.
  • Prepared documentation of developed programs including program and client documentation. Conducts client training, education and presentations.
  • Provides technical guidance and support to less experienced programmers.
Confidential, NY, NY Jun'08 - Nov'08

SQL Programmer Consultant

Responsibilities:
  • Assisted in redesign and development of existing database. Develop additional functionalities and reports as required. Maintain integrity of SQL databases.
  • Work with Director of Internal Development, Project Manager, Architect, etc. to redesign, develop and convert database from SQL 2005 to SQL 2008.
  • Development of additional functionalities and integrations with other business systems.
  • Establish system specifications by conferring with Director of Internal Development and users; analyzing workflow, access, information, and security requirements; designing system infrastructure.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Creation of databases and database objects like tables, indexes, views, and stored procedures, triggers functions.
  • Formulated test plans and tests and debugs developed programs. Participates in user acceptance testing.
  • Worked with clients and business analysts to identify client needs and alternative solutions.
  • Prepared documentation of developed programs including program and client documentation. Conducts client training, education and presentations.

Confidential, Wayne, PA Feb'07 - Apr'08

SQL data Analyst

Responsibilities:
  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Analyze database requirements of the end-user and propose specification to meet requirements.
  • Performed Data Analysis and Data Modeling and prepared the design documentation.
  • Translated the stakeholder requirements into various documentation deliverables such as functional specifications, use cases, workflow / process diagrams,data flow / data model diagrams, etc.
  • Responsible for database dictionary maintenance
  • Used excel features like pivot table, pivot charts, data refresh in developing business reports
  • Extensively utilized Unix Shell scripts embedded with SQL queries in executing jobs
  • Responsible for database structural changes, security policies, and backup/recovery specifications.
  • Assisted in development of transaction logging, backup, and security features
  • Provides technical database information to other systems software, computer operations and applications.
Confidential, Princeton, NJ Jly'05 - Dec'06

SQL Programmer Analyst

Responsibilities:

  • Interacted with management and end users to gather and analyze user requirements
  • Extensively participated in Design, creation and maintenance of MS SQL Server Database Management Systems.
  • Extensively participated in Logical and Physical Database Design.
  • Creation of databases and database objects like tables, indexes, views, and stored procedures, triggers functions.
  • Design, implementation and maintenance of MS SQLServer Replication.
  • Extensively participated in Database Disaster Recovery design, implementation and testing.
  • Created and maintained a separate reporting schema within the MS SQL database which includes defining the intermediate tables, scored procedures and views in order to reduce models, reports complexity.
  • Performing SQL Code analysis and debugging and make recommendations to improve efficiency of database design.
  • Responsible for ensuring that Computer Security Policies are followed
  • Monitoring database and machine performance / troubleshooting database performance problems
  • Design and documentation of DBA procedures
  • Coordinating the resolution of DBMS problems that require DBMS vendor intervention
Confidential, Parsippany, NJ Feb'04 - Mar'05

ASP Consultant

Responsibilities:

  • Assist and support developers in aspects of software development lifecycle.
  • Develop system architecture, design and code in accordance to local area and wide area networks.
  • Creates complex, customized applications to enhance website capability based on business needs.
  • Builds table frames and forms and writes complex script within the browser to enhance site functionality.
  • worked with web authoring languages such as Java, XML, HTML, CGI, ASP
  • Ensures that web pages are functional across different browser types; conducts test to verify user functionality.
  • Assisted in resolving complex production support problems by identifying issues and recommending appropriate solutions and implementing solutions.
  • Investigates and resolves matters of significance for end-user problems and escalates if necessary.
  • Provides support for business system analysis and process definition.
  • Works with end users to address requirements, usability, accessibility, security, and change requests to ensure website functionality. Identifies issues and recommends solutions.
  • Creates test plans, and reports test results. Works with outside vendors as necessary, in developing tests to ensure future site functionality.
  • Researches, tracks, and understands new web technologies to provide technical leadership in developing service applications and analyzing business requirements.
  • Assisted with cost management for site project. Performs necessary quality assurance activities to ensure optimum site functionality.
Confidential, Flushing, NY Dec'01 - Jan'04

ASP Programmer

Responsibilities:

  • Assist and support developers in aspects of software development lifecycle.
  • Develop system architecture, design and code in accordance to the clients\' requirements.
  • Perform analyses of business requirements.
  • Coordinate and collaborate with other team members to design, build and manage web sites.
  • Design and develop installation programs for websites.
  • Optimize and customize existing products as required.
  • Perform object oriented programming and database creation.
  • Configure and normalize and SQL Server query language.
  • Design and develop internet applications using HTML, JavaScript, IIS, COM, .NET and XML.
  • Manage and perform SQL Server administration and Section 508/Accessibility for Web Design.

Educational Background:
M.S (Computer Applications)

Hire Now