PROFESSIONAL SUMMARY:

• 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008(R2)/2005 in Development, Test and Production Environments with various business domains like Financial, Healthcare pharmaceutical, Insurance and manufacturing.
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. That increases my ability in Performance Tuning, Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL Server for deadlocks, long running queries and tune the same to improve performance.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions,Extract, Transform and Load (ETL)solutions for Data warehousing applications.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in creating SSIS packages to automate theImport and Export of datato and from SQL Server 2005, 2008R2, 2012 using SSIS tools likeImport and Export Wizard, Package Installation and BIDS.
• Responsible for creating SQL Server Drill down and Drill through Reports using SSRS to fit business requirements, and implemented into SQL Server 2005.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and end users.
• Expertise in using Team Foundation Server (TFS), Visual source safe (VSS) and Sub version tortoise (SVN) as a tool for repository of codes and version control, branching and merging into production.

TECHNICAL SKILLS:

Languages: C, SQL, T-SQL

RDBMS: MS SQL Server 2012/2008/2008 R2, 2005, MS-Access

ETL: DTS, SSIS

Web Technologies: ASP.Net, HTML, XML

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS

Operating System: Windows 95/98/2000/XP/NT,MS Dos and UNIX

Tools: Microsoft Visual Studio 2005,2008 R2, 2012, MS Office

Reporting Tools: Crystal Reports, ProClarity, SSRS

Data Modeling Tool: ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Englewood, CO

Business Intelligence Developer

Responsibilities:

• Designed packages which utilized Tasks and Transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Created SSIS packages to extract and Scheduled Jobs to call the packages and Stored Procedure.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS and Deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Created complicated reports like parameter based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, chart and tabular using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Performed data analysis to generate various trend reports and generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.
• Developed stored procedures, Triggers, Cursors to facilitate consistent data entry into the database
• Created stored procedures to generate different market claims for different types of accounts.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, functions.
• Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
• Created Indexes for fast retrieval of the data and used string functions for space management in database. Involved in Performance tuning and Query Optimization using execution plan.
• Used Tortoise as Version Control Tool.

Environment: SQL Server 2012, MS Excel, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services

Confidential, Oklahoma City, OK

Business Intelligence Developer

Responsibilities:

• Designed and developed integration from existing legacy application to new Enterprise operational Data. These were developed in accordance with integration standards using integration Framework.
• Involved in SQL Development support using Microsoft Technologies including but not limited to SQL Server, SSIS, in relation to support and enhancement of packages and reports as authorized by Boardwalk representatives.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2012).
• Extensively designed the packages and data mapping using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Created numerous simple to complex queries involving joins, correlated sub-queries and CTE’s techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Involved in Performance tuning and Query Optimization of Stored Procedures and queries using execution plan and profiler.
• Created User defined scalar and table valued functions and complex stored procedures to implement business logic
• Used new functions like Last Valve, First Value and Concat in Sql Server 2012
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling. Implemented error handling techniques like Try and catch, @@ error in Stored procedures.

Environment: SQL Server 2012, MS Excel, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services

Confidential, Scottsdale, AZ

Business Intelligence Developer

Responsibilities:

• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for data warehousing
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2012).
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Designed SSRS reports using table filters, single value parameters, multi value parameters, and Cascading Parameters.
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Developed Queries for generating drill down, drill through reports in SSRS 2008.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Environment: SQL Server 2008R2, MS Excel, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services.

Confidential, Chicago, IL

SQL Server SSIS/TSQL Developer

Responsibilities:

• Extensively designed the packages and data mapping using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.
• Experience in using different transformations like fuzzy lookup, derived column, Look up, Row count, OLEDB Command, Data conversion task transformations etc. in SSIS
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Loading data from various sources like Excel, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008R2.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Deployed SSRS Reports inSharePoint for web based access for multiple end users
• Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
• Created reports usingstored procedure and also involved inscheduling, creating snapshotsand subscriptions for the reports SSRS.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed flowcharts for complex stored procedures and effectively used views to prevent unauthorized access.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Tuned SQL queries using execution plans for better performance.

Environment: SQL Server 2008 R2 Enterprise Edition, T-SQL, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Windows Server 2005,Visual Studio 2010, MS Excel .

Confidential, Champaign, IL

SQL BI/TSQL Developer

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement.
• Created SSIS packages to extract data to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
• Extract Transform Load (ETL) development using SQL Server 2008R2, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling And Logging.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Installed SQL Server 2008 R2 on standalone and cluster environments
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Creating Reports as per user requirements using MS Reporting Services 2008/2008R2 Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2008R2/2008. Extensively worked in sorting the data, defining subtotals for the reports
• Designed and implemented stored procedures and triggers for automating tasks.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Effectively used views to prevent unauthorized access.
• Used Tortoise as Version Control Tool.

Environment: SQL Server 2008, SSIS, VBScript, XML, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS).

Confidential

SQL Server Developer/ BI Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2000 and SQLServer 2005 with latest Service Packs.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Created the SSIS/DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Created and managed the databases in development environment.

Environment: Windows 2000/2003 Advanced Server, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential

SQL Server Developer/SQL Server DBA

Responsibilities:

• Managed high-availability SQL Server environment supporting financial, business intelligence and CRM systems with load-balancing across multiple data centers.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries, Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Performance tuning and optimization of procedures and queries.
• Responsible for the creation and maintenance of entity relationship diagrams, Meta data repository and comprehensive system documentation including everything from environment configuration information through standards, policies and procedures.
• Responsible for change control management documentation.
• Interacted with higher management for reporting root cause analysis and suggested best practices to reduce the down time.
• 24x7 Production support.

Environment: MS SQL Server 7.0/2000/2005, Windows 2000 Advanced Server, Windows 2000 Datacenter, T-SQL, SQL Server Integration Services (SSIS), HP Proliant Servers DL Series, HP Storage WorksMSA20.