SUMMARY:

• Over 10 years of IT experience SQL Developer/ BI Developer in all phases of SDLC involving Analysis, Design, Development, Implementation, Testing and Deployment of Business applications and Products using SQL, other database technologies in various domains like Package Delivery, Web Data Harvesting and Extracting, Healthcares.
• Experienced in Agile (scrum).
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Analysis Service(SSAS), Reporting Services(SSRS), and ETL package design, and RDBM systems like SQL Servers.
• Worked with Medical Database JIVA32( ZeOmega's suite of care management), XCELYS(Dell Medical Claims Oracle Database), CACTUS - (Provider and Physician Credentialing Database).
• Good knowledge of Data Modeling using ETL tools, Star Schema and Entity-Relationship Diagrams
• Designed Logical and Physical Data Bases
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Participated in scrum team planning, scoping, and prioritization.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS) and ETL package design, and RDBM systems like SQL Servers.
• Experience with SQL back-end programming - advanced SQL, Database Triggers, Packages, Stored Procedures, Functions, Materialized views.
• Proficient in RDBMS concepts, with hands on in Relational database environment using SQL Developer, MS SQL Server, T-SQL, complex queries, Dynamic SQL, Analytical functions, WITH statement, Exists clause and Rollup in developing projects
• Proficient in SQL skills writing and working with database objects like tables, Sequences, Synonyms, Views, Materialized Views, Partitioned Tables
• Proficient in Tuning of SQL Queries.
• Proficient in TortoiseSVN
• Proficient in ColdFusion, Eclipse, HTML, CSS, JavaScript, Eclipse, and ASP.
• Worked in an Agile software development environment to interpret customer specifications and implement solutions.
• P rovide technical to the technical support team and to external customers.
• Update and develop documentation for application, application development processes and procedures
• Strong knowledge of Medical Database JIVA32 , XCELYS. CACTUS.

TECHNICAL SKILLS:

ETL: SQL Server Integration Services (SSIS), SQL Server DTS.

Programming: T-SQL, MDX, VB, ASP, C#, ADO.NET, HTML, WebQL, Access XP.

Databases Systems: MS SQL Server 2012/2008/2005/2000.

OLAP/Reporting: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).

Tools: MS Visual Studio 2005/2008/2010 , Visio, LogiXML, Share Point, TortoiseSVN.

EXPERIENCE:

Confidential

Business intelligence developper

Responsibilities:

• Responsibility to manage the rapidly expanding Supply Chain database and develop reports
• Design, plan, develop, test, document and maintain new data and reporting requirements from the Supply Chain department
• Develop web applications, that feed into SQL database, to collect data from internal and external users
• Automate reporting to distribute data to end-users in an easy-to-use and understandable format
• Provide data and analytical/modeling support to the Supply Chain department and multiple groups within Confidential
• Maintain up-to-date knowledge of programming discipline, design methods and documentation techniques. Demonstrate use of accepted industry standards and procedures.
• Perform ad hoc reporting/special projects when assigned

Tools: Used: MS - SQL Server 2008 R2, SSIS, SSRS, C#, Visual Studio 2008, T-SQL

Confidential

Senior Programmer Analyst

Responsibilities:

• Designs and codes application programs to meet user business requirement specifications.
• Unit tests application programs, reports & extracts to identify errors in program logic and verifies functionality and compliance with user specifications.
• Works with application development management to prepare estimates on design and development efforts.
• Develops in-house standard reports and extracts using Microsoft SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS) and other tools on a SQL Server database.
• Leads and/or participates in design and code reviews.
• Recommends changes in procedures or tools as required.
• Leads and provides technical direction to less experienced programmer/analysts.
• Updates and/or develops documentation for application and/or application development processes and procedures.
• Provides application and operational support to the production operations and help desk teams.
• Works closely with Confidential architecture guidelines to ensure compliance with internal technical directives and strategic roadmaps.
• Document technical specifications for reports and extracts development work.
• Worked with Medical Database JIVA32( ZeOmega's suite of care management), XCELYS(Medical Claims Oracle Database), CACTUS - Provider and Physician Credentialing Database.

Tools: Used: MS - SQL Server 2008, SSIS, SSAS, SSRS, Visio, C#, Visual Studio 2008, T-SQL, LOGIXML, Visio, TortoiseSVN, SharePoint.

Confidential

Application Developer

Responsibilities:

• Worked in an Agile software development environment to interpret customer specifications and implement solutions through utilization of company’s proprietary WebQL product

Tools: Used: regular expressions(REGEX), HTML, WEBQL.

Confidential

Application and Web Developer

Responsibilities:

• Collected and reviewed Requirements, built Process/Logic Flow, completed Wireframe, finalized Timeline.
• Completed Data model/Layout Rough Draft, used database Sizing Tool, built Database structure, evaluated with test Data, Complete Data Dictionary, complete Database Assessment, create Mature Dataset for Development and Testing using SQL 2000, SQL 2005, SSIS and SSAS.
• Implemented File Structure, Coded Page Variables, Coded Stored Procedures Using T-SQL, Cold Fusion, Eclipse, HTML, CSS, JavaScript.
• Performed Code, Quality, Performance .
• Built User Acceptance Testing, Built Staging Script, Submit Final Documentation, Requested Production Install
• Responded to any requests for changes or update from the project end user.
• Supported and maintained existing projects.
• Developed reports project using SSRS tool.
• Worked remotely using UPS communication system and SharePoint.
• Developed project definition and requirement, working closely with the project end user.
• Was responsible of Project Deployment

Tools: Used: MS - SQL Server 2005, SSIS, SSAS, SSRS, Visio, Visual Studio 2005, T-SQL, HTML, Cold Fusion, Javascript, CSS.

Confidential

Technical Support

Responsibilities:

.

• Designed and developed applications and reports using Visual Basic, Access, and Excel.
• Built Web applications using SQL 2000, T-SQL, HTML, ASP.
• Trained Internal and external customers on UPS Shipping Software and internal applications.
• Provided T echnical support - Software and Hardware -, Enterprise Reporting and technical to the Technical support team and to external customers.
• Developed project definition and requirement, working closely with the project end user.
• Was responsible of Project Deployment

Tools: Used: MS SQL Server 2000, MS SQL Server 2005, DTS, T-SQL, HTML, ASP, MS Access, MS Excel