SUMMARY

• Around 7+ years of experience in database design, development, analysis, testing, performance optimization and documentation.
• Experience in SQL Server Business Intelligence tools like SQL Server Integration Services(SSIS),SQL Server Analysis Services(SSAS), SQL Reporting Services(SSRS) as a backend developer in health care,banking,insurance and State companies.
• Experience in Logical and Physical Database design & development, Normalization and data modeling using Erwin.
• Extensive Knowledge in T - SQL Queries (DML and DDL).
• Expertise in writing and evaluating complex T-SQL queries using Joins, Stored Procedures, Triggers, Tables, Functions, Sub-queries, Cursors, and Views etc. in MS SQL Server 2008R2/2008/2005 database.
• Good understanding of ACID properties, RDBMS, Normalization, denormalization and database modeling.
• Expertise in working with Business Intelligence development studio for design and development of Integration, Analysis Services and Reporting Services (SSIS, SSAS,SSRS).
• Extensive experience with SQL Server Reporting services (SSRS) in design, development and deployment of different kinds of reports: simple, parameterized, drill-down, ad hoc, linked, snapshot, Cross-tab, sub reports etc.
• Extensive experience in designing, developing and publishing the reports using Business Intelligence Development Studio (BIDS).
• Hands on experience in scheduling the reports and subscriptions using report manager in SSRS.
• Experience in generating Ad-Hoc, Drill down, Drill Through reports using local and Global variables, Expressions and Filters in SSRS.
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Experience in Extracting, Transforming and loading the data using SQL Server Integration Services (SSIS) between homogenous and heterogeneous systems.
• Also importing and exporting data from excel, flat files to SQL server using BCP utility and DTS packages.
• Expert in design and deployment of MDX cubes in BIDS and Strong knowledge in writing MDX queries for retrieving the data.
• Also defining the relationships and working with various properties of Cube.
• Strong experience in Query optimization techniques, Performance tuning in SQL server.
• Experience in IBM Maximo, Visual source safe and Crystal reports.
• Strong knowledge in technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimensional modeling for OLAP.
• Also familiar with Erwin and MS Visio tools for creating logical and physical data modeling.
• Knowledge in identifying the Facts and Dimensions for cubes with MDX queries in SSAS 2005/2008.
• Strong Knowledge on Data warehouse concepts and Database Administration.
• Strong experience in MS Access, Word, Visio, Excel.
• Experience in all phases of the Software Development Life Cycle (SDLC) including analysis, design, development, testing, implementation and maintenance of client/server database driven applications.
• Excellent problem-solving and interpersonal communication skills, able to work both in teams and individually.
• Ability to handle multiple tasks, Initiative and Adaptable.
• Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

TECHNICAL SKILLS

Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Query Analyzer, SQL*Plus, Enterprise Manager, BIDS, Visual Studio 2010/2005/2008 , Erwin, Microsoft Visio, Crystal reports, VSS, Remedy, Virtual change

Databases: SQL Server 2000/ 2005/2008/2008 R2/2012, Oracle, Informix, MS Access, Sybase

Languages and Scripts: T-SQL, SQL,SQL*PLUS,PL/SQL,Classic ASP HTML, XML, C, C++, ASP.NET, VB.NET, JAVA script

Operating Systems: Windows NT/2000/XP, Linux, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

SQL SSRS/SSIS Developer

Responsibilities:

• Worked closely with the Business Analysts/Engineers/Vendors in gathering requirements and providing services as required.
• Experience in writing and managingT-SQL queries - stored procedures,indexes, views, UDFs, Database Constraints to meet business requirements and policies.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Design, developed and deployed reports using SQL Server Reporting services 2005/2008/2008 R2.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required.
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created report model projects as per the requirements using Report builder in SSRS and provided for end users.
• Promoted RDLs to Reporting Service Server (SSRS).
• Worked on scheduling the reports as required using normal and data driven subscriptions.
• Created and deployed the reports in web portals and also in share point sites as required.
• Created various SSIS packages which would load raw data in to the tables of the databases.
• Created clustered indexes and non-clustered indexes to increase the performance of the database.
• Created several SSIS packages to pull data from SQL Server and Flat files into Excel sheet and to archive the data as per the business logic.
• Worked on SQL Server Integration Services (SSIS) for migrating data from one or more databases to other database.
• Used different tasks and transformations in designing the SSIS packages and executed/deployed them as required.
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.
• Worked closely with SQL Admins for installing and configuring the SQL server databases and SQL Server Reporting services (SSRS).
• Worked on importing the work orders data from spreadsheets into the IBM Maximo.
• Worked on documenting the process of various kinds of reports and also database architecture.

Environment: SQL Server 2008R2/2008/2005, Visual Studio 2008, SQL Server Reporting Services, SQL Server Integration Services, T-SQL, Windows platform, ASP.net, VB.net, Microsoft.net Framework 3.5, MS Access, MS Office, Excel, IBM Maximo, SharePoint Designer 2007.

Confidential, South San Francisco, CA

SQL BI Developer

Responsibilities:

• Involved in gathering requirements from application owners, business analyst and others involved in business.
• Designed, developed, defined and uploaded the data to the data warehouse based on the business requirement for deploying reports.
• Responsible for creating the reports basing on requirements using SSRS 2008.
• Wrote and maintained T-SQL queries, stored procedures and functions for retrieving the data from different databases and for generating reports.
• Created reports using graphs, charts (bar, area, pie) for business and marketing analysis and also worked on weekly, monthly parameterized reports.
• Created and deployed Linked and sub reports as per the requirement using SSRS.
• Deployed the reports in report manager and organized.
• Created reports from OLAP cubes using ProClarity tool.
• Developed several reports (Summary, Master) with consistent drill-down functionality and created queries for these reports.
• Worked on query optimization techniques and performance tuning.
• Developed cache reports using report manager as required.
• Designed and developed DTS and SSIS packages to automate the process of sending reports to the client’s directly.
• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to Datawarehouse databases and datamart databases.
• Scheduled and monitored the daily, weekly, monthly reports in the report manager and also worked on the subscriptions.
• Worked with team in developing SSIS packages using Control flow task, Sequence container task, Data Flow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task for transforming the data within the databases.
• Involved in creating and deploying the OLAP cubes using BIDS with the groups and hierarchies based on the report needs.
• Designed and developed datamart using SSAS.
• Involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL.
• Analyzed and created Multidimensional Cubes in Facts and Dimensions Tables using SSAS.
• Wrote MDX queries according to the business requirements.
• Have knowledge in Microsoft Amalga health enterprise platform to retrieve display patient information from many sources including scanned documents.
• Involved and worked closely with DBA in administration of reports database, creating jobs, analyzing logs, Alerts using SQL Server Agent.

Environment: SQL Server 2008/2005/2000 , Microsoft Amalga,Business intelligence studio (SSIS, SSAS, SSRS) 2008/2005, ProClarity, VSS, T-SQL, SQL*PLUS, Windows platform, MS Access, MS Office, Excel, SQL Server Agent.

Confidential, Chicago, IL

SQL Server Developer

Responsibilities:

• Performed all tasks which include defining the requirements, design, development, testing, implementation and maintenance reports using SSRS 2005 and Crystal Reports for management.
• Involved as a primary developer to develop and maintain all the reports required as per the business needs using SSRS.
• Worked as a developer in creating complex T-SQL code for applications and also created the database objects including SQL Views, SQL stored procedures and Functions to provide data for reports.
• Worked with clients to develop the report templates and with testing team to test the reports for data validation.
• Worked on the reporting component in order to invoke reports from the application.
• Designed Entity-Relationship modeling and dimensional modeling for OLTP and OLAP databases using Erwin tool.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS cubes.
• Worked closely with business analysts and DBAs in physical and logical dimensional models for databases using third party tools MS Visio and Erwin.
• Created cubes based on data volumes mostly adhere to star schema.
• Worked on documentation of Installation, design qualification documents and maintained them with version control.

Environment: MS SQL Server 2000/2005, SSIS, SSRS, T-SQL, Enterprise Manager, Sybase, Oracle 9i, Crystal Reports, MSBI Reporting, VSS, Microsoft Visio 2003, MS-Access 2000 & Windows XP Professional, NT, 2K platform, Erwin 4.1.

Confidential

SQL Developer

Responsibilities:

• Designed the database, tables and Procedures.
• Developed complex T-SQL code for Application.
• Designed the database schema using third party tools like Erwin.
• Involved in Logical and Physical design.
• Created Stored Procedures, Functions, Triggers, and Views, to meet the business requirements using T SQL.
• Solved problems by reconfiguring parameters, creating/rebuilding Indexes, running DBCC commands and recompiling Stored Procedures.
• Imported data using BCP utility.
• Installed SQL server 2000 and 2005 applied service packs and security patches.
• Imported data from text files and excel spreadsheets into SQL Server 2000/2005 databases using DTS/SSIS packages.

Environment: SQL Server 2005/2000/7.0 , Unix, T-SQL, Enterprise Manager, Query Analyzer, MS Access, MS office, SSIS, SSRS, MS Reporting Services, DTS, Erwin 4.0.