SUMMARY

• 6+ years of experience in Designing, Analysis, Development, Maintenance, Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) using SQL Server, Oracle, Crystal Reports etc.
• Strong experience in MS SQL Server 2005/2008 with Business Intelligence in SSIS/SSAS/SSRS, OLTP and OLAP.
• Requirements analysis, design and creation of reports with Microsoft Reporting Services 2005 using OLAP Cubes and SQL Server 2005 Relational Tables as data sources and data extraction with stored procedures.
• Strong skills in Database Modeling (logical / physical) using best practices of data integrity and relational databases concepts; Data Warehouses/Marts modeling for OLAP, utilizing dimensional models as well as relational models. OLAP Cubes development in SQL SSAS
• Migrating SSIS packages from SQL Server 2005 to SQL Server 2008 and DTS packages from SQL Server 2000 to SQL Server 2005/2008.
• Experience in SSRS design and deployment of Parameterized, Drilldown, Sub, Linked, Snapshot, Cached, and Ad hoc Reports.
• Transformation of OLTP data to the Data Warehouse using SSIS and T - SQL.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Indexes, Packages and complex queries on SQL Server 2005/2008.
• Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle 11g/10g and also SQL queries/reports and scripts
• Expertise indevelopingcomplexreportsin Crystal Reports using multiple sub reports and drilldown features and using conditional suppression formulas.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008.
• Adept in designing Stylish Report layout and having Proficiency with drill down reports in SSRS 2005/2008.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008.
• Extensive experience in scheduling and delivery of reports with Crystal Enterprise in multiple formats.
• Experience in Microsoft SQL Server configuration, performance tuning, client/server connectivity, and query optimization, back-up/recovery.
• Proficiency in .NET technologies such as C#, ASP.NET, ADO.NET, Win Forms, Windows services.
• Experience with all phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging).
• Experience designing and developing applications using Visual Basic 6.0.
• Expert in Microsoft Office tools namely Access, Excel, Outlook, PowerPoint and Word and good knowledge on Business Objects
• Experience in industry standard systems analysis techniques including data modeling, process modeling, data flow diagramming, unified modeling language (UML), E-R modeling and design patterns
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008 and SQL server 2005 suite of products like SSIS, SSRS.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Experienced in using version control tools such as VSS (visual Source Safe)
• Developed stored procedures to support real time data solution reviewed and propose corrections and enhancements to existing reports.

TECHNICAL SKILLS

OPERATING SYSTEM: - Microsoft Windows Server 2000/XP/Vista, MS DOS, UNIX

DATABASES/ DATA ACCESS: - SQL Server 2000/2005/2008 , Oracle 10g, 9i, 8i, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services

PROGRAMMING LANGUAGES: - PL SQL, C, C++, C#, HTML, Visual Basic 6

UTILITIES/TOOLS: - Crystal Reports 10/11, SSRS, MS Performance Point Server, Visual Studio.NET

FUNCTIONAL AREAS: - Healthcare, Logistics

WEB TECHNOLOGIES: - ASP.NET, XML, CSS, Web services, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Environment: Microsoft SQL Server 2005/2008, Visual Studio 2005/2008, SSIS, SSRS, Business Intelligence Studio, SQL Profiler, Windows XP / NT / 2000/2003, MS Access, Microsoft Visio, MS Office 2007.

Sr. SQL Server BI Developer

Responsibilities:

• Responsible for developing the stored procedures, triggers, views, and user-defined functions to support application development.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Developed, executed and maintained SQL queries/scripts and similar artifacts to validate completeness, integrity and accuracy of data.
• Designed and tested (Unit, Integration and Regression) packages to extract transform and load data using SQL Server integration services (SSIS).
• Worked as a developer in creating complex Stored Procedures, SSIS packages.
• Created Efficient Triggers, Cursors, Tables, and Views and other SQL Joins and statements for application.
• Analyzed Reports and Fixed Bugs in stored procedures.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Involved inQuery Optimizationsand Performance Tuning for the Stored Procedures.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Created views to restrict access to data in a table for security.
• Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.

Confidential

Environment: Microsoft SQL Server 2005/2008, Visual Studio 2005/2008, SSIS, SSRS, Business Intelligence Studio, DTS, SQL Profiler, Windows XP / NT / 2000/2003, MS Access, ODBC, Oracle 9i, Microsoft Visio, MS Office 2007.

Sr. SQL Server BI Developer

Responsibilities:

• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Responsible for developing the stored procedures, triggers, views, and user-defined functions to support application development.
• Developed, executed and maintained SQL queries/scripts and similar artifacts to validate completeness, integrity and accuracy of data.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Designed and tested (Unit, Integration and Regression) packages to extract transform and load data using SQL Server integration services (SSIS).
• Worked as a developer in creating complex Stored Procedures, SSIS packages.
• Created Efficient Triggers, Cursors, Tables, and Views and other SQL Joins and statements for application.
• Analyzed Reports and Fixed Bugs in stored procedures.
• Involved inQuery Optimizationsand Performance Tuning for the Stored Procedures.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Created views to restrict access to data in a table for security.
• Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Confidential, Washington US

Environment: SQL Server 2005/2008, SSRS, SSIS, SQL Query Analyzer, MS Access, Excel, Microsoft VSS, Visual Basic 6, Crystal Reports 10,Windows XP/2000,VPN Connectivity, Remote Desktop Connection

SQL Server BI Developer

Responsibilities:

• Installed and configured MS SQL Server tools SSIS, SSRS, and SSAS.
• Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Generated production reports, parameterized reports and regular reports using the tools SSRS.
• Used stored procedures, functions, tables, views and triggers and worked in designing and developing Reports, Data warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schemas.
• Reviewed cube with end user and changed the cube and documentation according to their requirements.
• Designed facts and dimension tables defined relation between facts and dimensions.
• Created logical multi dimensional models and studied relationships among the logical objects.
• Designed, administrated and developed Star Schema Data marts.
• Objects moving between Development, Staging, Pre Production and Production.
• Enforced referential integrity via creation of constraints on database objects.
• Populated user databases in SQL Server 2005 via DTS utility.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Worked on DTS Packages, DTS Import/Export for Transferring data from Heterogeneous Databases.
• Maintained SQL Script for creation of Database Objects.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Confidential, Miami, FL

Environment: SQL Server 2005/2008,SSRS, SSIS, Crystal Reports 10, Oracle 9i with PL/SQL Toad, Crystal Enterprise Server, SQL Query Analyzer, Microsoft VSS, MS Access 2003, MS Excel 2003, Windows Server XP, VPN Connectivity

SQL Server BI Developer

Responsibilities:

• Responsible for developing the stored procedures, triggers, views, and user-defined functions to support application development.
• Migrated SSIS packages from SQL Server 2005 to SQL Server 2008.
• Created various management and analytical reports using SSRS.
• Created tabular, matrix, chart, drill-down, and parameter reports as per the business requirement.
• Optimized SSIS package performance to reach the expected timeframe for data loading.
• Responsible for scheduling and delivery of reports with Crystal Enterprise 10 in multiple formats.
• Experience in SSRS design and deployment of Parameterized, Drilldown, Drill through, Sub, Linked, Snapshot, Cached, and Ad hoc Reports.
• Transformation of OLTP data to the Data Warehouse using SSIS and T-SQL
• Used Query Analyzer and execution plan to optimize SQL Queries.
• Created SQL*Loader scripts to load data from external system to oracle.
• Involved in preparing test cases, unit functional testing of developed reports and jobs
• Involved in generating crystal reports with strong knowledge of relational database modeling principles, techniques and dimensional modeling.
• Responsible to generate test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Created the lookup tables and generated the lookup data to meet the specification
• Optimizing and tuning of various stored procedures and functions in SQL server 2005/2008
• Generated database SQL scripts and deployed databases including installation and configuration
• Ensure that the customers receive high standard services and analyze business requirements to provide efficient solutions
• Planned and co-coordinated database security measures and database integrity
• Coordinated with other reporting analysts in analyzing data and creating management reports

Confidential

Environment: Crystal Reports, SSRS, SSIS, SQL Server 2005/2008,SQL Query Analyzer, Windows Server 2003, ASP.Net, C#, ADO.Net, HTML, Microsoft VSS, HTML, SSRS, DUNDAS, PPS

SQL Server Developer

Responsibilities:

• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Developed, executed and maintained SQL queries/scripts and similar artifacts to validate completeness, integrity and accuracy of data.
• Experienced in agile software development process, using pair programming, unit testing, short iterations, and close customer relationship.
• Experienced in working with XML document structures and hierarchical data.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Reviewed cube with end user and changed the cube and documentation according to their requirements.
• Created Partitions, Calculated Members, Schema and File Groups for fact tables and cubes.
• Scheduled Jobs and Alerting using SQL Server Agent.
• Worked as a developer in creating complex Stored Procedures, SSIS packages.
• Created Efficient Triggers, Cursors, Tables, and Views and other SQL Joins and statements for application.
• Analyzed Reports and Fixed Bugs in stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Performed Unit testing on Reports, and monitored the performance of the Reports.
• Involved in preparation and review of Technical Design Document.
• Developed Reports by using Crystal Reporting Tool and PPS Tool.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Preparation of Test case documents, Data Flow Diagrams.
• Developed Web Forms using ASP.NET, C#, HTML
• Responsible for connectivity of database using ADO.NET Components
• Developed stored procedures, views and functions for data manipulation and querying data from SQL Server 2005/2008
• Maintained Visual Source Safe for version control.
• Assessed internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS) or by Crystal Reporting Service

Confidential

Environment: SQL Server 2000, ASP.Net, C#, ADO.Net, MS Access, Excel, Windows Server 2003 VPN Connectivity, Microsoft VSS, HTML

SQL Server Developer

Responsibilities:

• Worked onClient/Servertools likeSQLServerEnterprise Manager and Query Analyzer to AdministerSQLServer.
• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Wrote complex queries, triggers and stored procedures, views and user defined function.
• Designed and implemented database logical and Physical Schemas.
• Created Database Maintenance Planner for the Performance ofSQLServerwhich covers Database Integrity Checks.
• Updated Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Snapshot Replication was been used to synchronize the data between their Different Stores.
• Worked on DTS Package, DTS Import/Export for Transferring data from DB2 Database.
• Data migration (import & export - BCP) from Text toSQLServer.
• Converted DB2/400 Database toSQLServerusing DTS Package and used DTSRUN.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintainingSQLServer, Written Stored Procedures for ApplicationDevelopers.
• Conducted product evaluations of upgraded and hardware and software; identifying strengths, weaknesses, and potential benefits.