SUMMARY:

• More than 13 years of IT experience in RDBMS like MS SQL Server, Oracle, MS Access, Essbase with experience in SQL, T*SQL and PL/SQL programming involving writing Stored Procedures, Functions, Triggers and SQL queries/reports and scripts.
• Experience in Developing Oracle Reports, SSRS, SSIS, SSAS,Excel Reports, and Crystal Reports & Web applications for the user purpose.
• Have Strong Knowledge of Software Development Life cycle, worked with end users in understanding the requirements. Worked with business users in finalizing the reports and testing reports and different applications.
• Experience in requirement gathering and Analysis, Design, Development, Testing and Implementation of large scale Business Applications.
• Worked on transferring the Reports from older version to new version with environment like SQL server and Oracle Database.
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills.
• Ability to work on multiple tasks in a fast paced environment independently and in a team, Quick learner with passion to learn new technologies.

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/XP/Vista, UNIX

Languages: SQL, PL/SQL, T/SQL, Visual Basic, VBA, HTML, ASP

Database: Oracle, MS SQL SERVER, MS Access, Essbase

BI Tools: SSIS, SSRS, SSAS, Business Intelligence Development studio Cognos 8 BI, Crystal reports, Remedy 7.5

PROFESSIONAL EXPERIENCE:

Confidential, NM

Sr. Analyst

Responsibilities:

• Confidential modeling, cube design, cube development using SSAS
• ETL development for all lines of Business using SSIS
• Developing reports in SQL and SSRS which includes dynamic queries that accept user parameters for data set extraction
• Auto sys schudling jobs for all lines of Business(cards, ntwk, UCCB, Global)
• Gathering requirements from customers and Analyzing the data.
• Designing, configuring, programming and testing the reports
• Extensively working on backend & unit testing using SQL queries

Environment: SQL Server, T - SQL, SSRS, SSIS, SSAS, Visual studio 2008, Confidential (BIDS), Autosys, TFS

Confidential, Raleigh, NC

SQL Reports Analyst

Responsibilities:

• Converting Reports from Access database to SQL server database
• Developing reports in SQL and SSRS which includes dynamic queries that accept user parameters for data set extraction
• Performing Business analysis on requested reports to determine most efficient method of pulling data
• Working with internal clients to support all the reports and training end users
• Creating complex reports using with drill through capabilities, summarization, grouping and filtering
• Developing Linked, List, Matrix,Tablix and master-detail reports
• Managing reports in report manager. Setting up subscriptions to deliver the reports automatically via email or file share
• Developing ad-hoc reports as required, including the creation of Excel pivot tables.
• Designing, configuring, programming and testing the reports
• Developing Test Plans, Test Cases to test the Screens and workflows for Quality Assurance
• Extensively working on backend & unit testing using SQL queries
• Creating SSIS packages to transfer the data from Access to SQL environment

Environment: SQL Server2008, T-SQL, Excel, VBA, Access, SSRS, SSIS, Visual studio 2008, Confidential (BIDS), BMC Remedy 7.0.5 applications

Confidential, Raleigh, NC

SQL Analyst

Responsibilities:

• Worked in Hosted environment to develop sql reports
• Standardized all adhoc reports to run automatically
• Created Stored Procedures, SQL queries and scripts for various projects
• Worked with Clients to fix problems regarding software Installations
• Generated Reports for Incident tracking management system

Environment: SQL Server2005, T-SQL, Excel, Sales force, EasyCMDB, SQL Diagnostic manager

Confidential, New York, NY

SQL Consultant

Responsibilities:

• Responsible for requirements gathering, functional and technical specification writing, creation of project roadmap and milestone creation
• Automated manual reports to run automatically as required
• Developed complex Stored Procedures, SQL queries and scripts for various projects
• Oversaw software development and directed QA testing efforts
• Planned and implemented multiple project deployments/implementations
• Created ad-hoc reports and tested the queries before developing standard reports

Environment: Oracle 9i, SQL * PLUS, Excel, VBA, ODBC, TOAD, QA, Remedy Report generator

Confidential, Phoenix, AZ

Database Analyst

Responsibilities:

• This job reporting to the Director of Information Technology of Confidential provided detailed sales reports to the Vice President of Finance as needed, and also on a weekly and monthly basis
• Worked on Transferring the Data from Vax system to SQL environment.
• Principal responsibility was to design, develop, test and document the database Projects
• Programmed an automated a feature-rich Excel Pivot Table reporting system
• Developed numerous complex reports using Excel/VBA front-end, all of which are in production throughout Confidential, Inc
• Wrote ADO code and SQL statements to transfer data into and out of Excel spreadsheets
• Generated lot of Ad-hoc reports according to the company’s requirement
• Developed custom Web applications to validate and retrieve the data for the users
• Directed QA testing efforts. Planned and implemented multiple project deployments/implementations
• Worked with other team members to complete the task as a group depending on the necessity
• Provided technical support & trained users on the use the reports

Environment: SQL Server 2000, T-SQL, Visual Basic, VBA, Excel Reports, Pivot tables, Crystal Reports ASP, HTML, VB Script and Visual Inter Dev, Essbase

Confidential, Chandler, AZ

SQL Developer

Responsibilities:

• Worked on Backend Programming using T*SQL, Stored Procedures, Functions, also SQL queries/reports and scripts
• Developed custom Web applications such as Medical Monitoring which has the medical status of the employees
• Time Tracker to keep track of time card information in a central database. This real time application is used to generate receivable and payroll information
• Supported testing and debugging of Web applications

Environment: SQL Server 7.0, T*SQL, ASP, HTML, JavaScript, VB Script and Visual Inter Dev

Confidential

Software Engineer

Responsibilities:

• Worked on Transferring the Data from Pascal to Oracle environment
• Participated in the development of below modules for HMT Watch Division using as a member of a small team
• Stock Control Module: Developed forms for registering incoming goods and store stock tracking
• Materials Accounting Module: Developed forms to maintain detailed account of various materials used for manufacturing watches. This module is also used to keep track of stock balance of materials in the warehouse
• Trained operators to access and retrieve data using SQL queries, Forms and Reports

Environment: Oracle 8i, SQL*Plus, PL/SQL, Oracle Forms 4.5, Oracle Reports 2.5 and UNIX