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

• 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.
  

SQL Programmer Consultant

• 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

• 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.

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
  

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.

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)