OBJECTIVE:

• Seeking for a responsible, challenging, and awarding role in a software industry where in my skills and technical abilities can be utilized and enhanced, contributing to growth and success of individual as well as teh organization.

SUMMARY

• 9+ years of strong experience wif demonstrated success in teh Database Design, development and deployment of large - scale enterprise applications.
• Expert in MS SQL Server 2012/2008r2/2008/2005 suite of products like SSRS, SSAS, and SSIS.
• Extensive Experience in Microsoft .Net Technologies using .Net Framework 1.1,2.0/, VB.Net
• Expertise in providing Enterprise Reporting solutions using SSRS 2012/2008r2/2005
• Strong Experience in teh design, development, configuration, testing, deployment, support and/or maintenance of new applications and SQL Server Reporting Services.
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS,SSIS,SSAS) using MSSQL Server 2005/2008/2008 r2
• Analyze report, script and stored procedure performance and identify areas for improvement andDevelop and enhance scripts to automate routine administration tasks.
• Prepared estimation/assessment documents for modifying existing and developing new reports.
• Expert in Deployment solutions into various environments including production, design and develop future solutions to optimize system performance, resource usage and management overhead.
• Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
• Expert in Implementing High Availability Solutions such as for Log Shipping, Mirroring and Replication in MS SQL Server Environments.
• Gathered business requirements and Converting them into technical requirements and Implementing by using SSRS.
• Experience in Change Management process for Patches, bug fixes and new application development.
• Implement/code reporting and database solutions using client standard coding and design standards which include MSSQL queries and stored procedures Implement and test solution architecture
• Extensive noledge in T-SQL queries (DDL and DML).
• Maintain and Monitoring of Various SSRS reports, SQL code, store procedures and Solving Tickets on Daily Basis for Production Issues.
• Experience in providing 24 x 7 production support. Excellent communication skills, organizing skills, highly punctual and an excellent listener.
• Proven experience in project and team leading wif minimal defect delivery. Equally comfortable working independently as well as in a team environment
• Ability to work in a team and as an individual wif minimal supervision.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
• Highly proficient in teh use of T-SQL for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
• Worked wif DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Extensive noledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Created and managed Indexes and optimized queries using execution plan.
• Involved in Scheduling jobs, address Batch process issues, Debug code and Maintenance and bug fixes.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Reporting Services (SSRS 2005/2008r2/2012)
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServerReporting Services (SSRS) in Business intelligence development studio (BIDS)....
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in developing Crystal Reports.
• Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
• Experience in Integrating SQL Server Reporting Services wif Microsoft Office Share Point Server (MOSS).
• Extensive noledge in ETL Process &Progressive noledge in using DTS/SSIS utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Extraction &Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400,DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
• Solid Knowledge in developing cubes using Partitions, KPI’s, andPerspectives, slow moving dimensions etc and created various user roles.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports
• Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
• Expert in Implementing High Availability Solutions such as for Log Shipping, Mirroring and Replication in MS SQL Server Environments.
• Installation, configuration, upgrade, and migration
• Database security: understand security model and configurations to use it effectively to control access to teh data
• Performance monitoring and tuning-- monitoring teh database server on a regular basis to identify bottlenecks and addressing teh issues
• Troubleshooting--quickly determine root cause and resolve problems wifout losing data

TECHNICAL SKILLS

Operating Systems: MS-DOS, Windows 98/NT 4.0/XP/2000/2003 Server, UNIX

Programming Languages: T-SQL, C, HTML,CSS,XML

RDBMS/Databases: MS Access, MS SQL Server 2000/ 2005/2008/2008 r2/2012

Database Design Tools and Data Modeling: ERWIN, MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Database Tools and Utilities: SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2012

Version Control Tools: VSS

PROFESSIONAL EXPERIENCE

Confidential, Colorado

BI Developer

Responsibilities:

• Analyzed teh existing tool and participated in meetings wif teh business users to gather Requirements and design goals of data warehouse.
• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Gathered requirements and created logical database design from Business team and created physical database design from SQL server 2012.
• Extract Transform and Load (ETL) source data into respective target tables to build teh required data marts.
• Analyze teh complex stored procedure, functions in dimension modelling.
• Developed sample SSAS cubes for school data and complexcalculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.

Environment: SQL Server 2008r2/2012, T-SQL, SSAS, SQL Server Integration Services, SQL Server Reporting Services.

Confidential, Sacramento, California

BI Developer

Responsibilities:

• Performed Reporting Analysis, design, development, documentation, testing in different environments.
• Created Cascaded Reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS.
• Responsible forInstallation, Configurationand AdministrationofSQL Server 2012 and SSDT 2012 Installation of Service Packs & hot fixes.Created report snapshots to improve teh performance of SSRS.
• Gathered and analyze reporting requirements from Business team and created database design document and implementation plan.
• Technical support for web based applications.
• Worked wif Team Foundation Server(TFS) and Visual Studio 2010,2015.
• Coded reports and database solutions using coding and design standards which include complex MS SQL queries and stored procedures.
• Used various transforms in SSIS to load data from flat files, excel to teh SQL databases.
• Participated in project team meeting as a technical expert and provided solutions.
• Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Maintain and Monitoring of Various SSRS reports, SQL code, store procedures
• Design and develop new SSRS reports by using SSDT 2012.
• Convert Crystal reports to SSRS.
• Created and scheduled Snapshots and Subscriptions for teh reports using SSRS.
• Tracking bug fixes in data base development and deliver reports on time by using Team Foundation Server (TFS).
• Created various reports includes charts, Indicator by using SSDT 2012.

Environment: SQL Server 2008r2/2012, Windows 2000/2003, T-SQL, SQL Server Integration Services, SQL Server Reporting Services.

Confidential, Olympia, WA

BI Developer

Responsibilities:

• Responsible forInstallation, Configurationand AdministrationofSQL Server 2012 and Installation of Service Packs & hot fixes.
• Ad hoc reports and distributed reports in multiple formats using SQLServerReporting Services (SSRS) in Business intelligence development studio (BIDS) and SSDT 2012.
• Created Data mart for reporting and case management for injured workers from Confidential and for use by COHE staff.
• Extract Transform and Load (ETL) source data into respective target tables to build teh required data marts.
• Providing Logging, Error handling by using Event Handler for SSIS Packages. And Improves teh performance of SSIS packages by using break points, check points applications and avoid teh fully blocking transformations.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Analyzed teh existing tool and participated in meetings wif teh business users to gather Requirements and design goals of data warehouse.
• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Gathered requirements and created logical database design from Business team and created physical database design from SQL server 2012 .
• Created Report specification documents for reporting purpose.
• StrongSQL ServerDevelopment skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, and User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following teh Data Integrity using Constrains, Rules and Default.
• Provided Technical support to OHMS team.
• Tracking bug fixes in data base development and deliver reports on time by using Team Foundation Server (TFS).

Environment: SQL Server 2008r2/2012, SQL Server Integration Services, SSRS,SQL Server Analysis Services

Confidential, Salt Lake City, Utah

BI Developer

Responsibilities:

• Created Parameterized reports, Crystal Reports, Cascaded Reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS and designed reports using Crystal Reports.
• Responsible forInstallation, Configurationand AdministrationofSQL Server 2008r2, 2012 and Installation of Service Packs & hot fixes.
• Created report snapshots to improve teh performance of SSRS.
• Gathered and analyze reporting requirements from Business team and created database design document and implementation plan.
• Coded reports and database solutions using coding and design standards which include complex MS SQL queries and stored procedures.
• SAFE TEMPhas hundreds of existing reports that has been written using teh Sybase Info-maker reporting tool that must be evaluated and rewritten using Microsoft SQL Server 2008.
• StrongSQL ServerDevelopment skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, and User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following teh Data Integrity using Constrains, Rules and Default.
• Provided Technical support to SAFE technical team and Mentor State Staff team members in SQL reporting Services.
• Rewrites SAFE existing Info maker reports that are needed in teh new environment to SQL Server.
• Consolidated and optimized SSRS reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Participated in project team meeting as a technical expert and provided solutions.
• Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Maintain and Monitoring of Various SSRS reports, SQL code, store procedures
• Design and develop new SSRS reports and also migration of reports from Sybase to SQL Server 2008r2.
• Created and scheduled Snapshots and Subscriptions for teh reports using SSRS.
• Tracking bug fixes in data base development and deliver reports on time by using Team Foundation Server (TFS).
• Created various reports includes charts, Indicators, median by using SSDT 2012.
• Participate in teh design, development, configuration, testing, deployment, support and/or maintenance of new applications

Environment: SQL Server 2008r2/2012, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Info maker

Confidential, Boise City, Idaho

BI Developer

Responsibilities:

• Analyzed business requirements and provided Database requirements and Design documents
• Build logical and physical data models that describe all teh data and relationships between teh data
• Created standard documentation for Disaster recovery testing and implemented them.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml & OLEDB)
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts usingSSIS, Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Created Packages that Transfers Databases from OneSQL Serverinstance to Another Instance and Scheduled teh SSIS packagefor migration of data from old system to MS SQL 2008.
• Prepare Deployment guide and assist deployment expert and written Release notes and update problem tickets wif solution details.
• Backups and Restore for SQL Server 2008r2
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, Excels to and from SQL Server 2008wif high volume data.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Responsible for data retrieval by extensive use of multiple joins normalization and view.
• Resolved various performance issues by running Database Consistency Checks DBCC command
• Performed data cleansing by creating tables to eliminate teh dirty data using SSIS.
• Used SQL Server Profiler to monitor teh performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Assigned to teh monitoring of Performance tuning, and Optimization of Sql queries by using query optimizer, execution plan and SQL profiler in SQL server 2008r2.
• Completed tasks in a given period by using capacity planning documents and prepared database design documents for application developers and database administrators.
• Involved in Unit Test cases preparation and performed Unit testing.
• Re-built or re-organized fragmented indexes to improve and ensure teh overall database performance.

Environment: Server 2008/2008r2, SSIS,, TSQL/DBA, Erwin, .Net Frame Work, XML, MS Access, Excel, C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server.

Confidential, San Antonio, TX

BI Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Reduced report execution time by tuning teh Stored Procedures and creating Indexes, Hash Joins etc.
• Used various transforms in SSIS to load data from flat files, Siebel CRM and FTP to teh SQL databases.
• Prepared Implementation Guide for Standalone Microsoft SQL Server 2008.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Created Grouping, Sorting columns and writing expressions according to teh business requirements.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in teh SSIS packages and SQL scripts.
• Good Knowledge of Installation and Configuration of Clustered Servers in Active/Passive and Active/Active mode.
• Developed tabular queries for efficient analysis of report using Pivot in T-SQL.
• Worked wif T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Designed, tested (unit testing and integration testing) and implemented stored procedures and triggers for data processing of huge volume of data.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Provided index tuning as required for performance improvement of teh applications (SQL tuning).

Environment: SQL server 2005/2008 on Windows 2003 server, IIS, Visual Studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, Log shipping, Congas Report Studio, Framework Manager, BIDS and SSMS.

Confidential

BI Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update teh cube wif current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build teh required data marts
• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Analyzed teh existing tool and participated in meetings wif teh business users to gather
• Requirements and design goals of data warehouse.
• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements and technical standards.
• Defined appropriate measure groups and KPIs &deployed cubes.
• Created Parameterized reports, Cascaded Reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRSand designed reports using Crystal Reports.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports