SUMMARY

• Over all 7+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005/2000.
• Experienced in Installing,Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data WareHouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access,Excel,CSV,Oracle,flat files using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables,Expressions and Functions for the business users.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Databases: SQL SERVER 2008/2012/2014, MS-Access MS Access, MS SQL Server 2000/2005/2008/2012, Oracle 8i/9i/10g. Tools/Utility,Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS,Analysis Manager, BCP, SQL Profiler.MY SQL

Programming: T-SQL, CSS, HTML, ASP.NET, C#, .NET Framework, C.

Operating System: Windows NT/98/2000/XP/2003 Server,Unix, Linux, Sun Solaris.

Reporting Tools: Excel,SQL Server Reporting Services 2012,2008,2005.

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler.

PROFESSIONAL EXPERIENCE

Confidential - Phoenix, AZ

SQL Server BI Developer

Responsibilities:

• Designed and developed OLAP cubes for Multi - dimensional data reporting using SSAS 2008 R2 & 2012 versions
• Created On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2008 R2 & 2012 (SSRS).
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools. Designed, deployed, and maintained of various SSRS Reports.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Worked on Stored Procedure, Formulated Stored Procedure/T-SQL coding, Performance Tuning and Query Optimization.
• Develop SQL Server Stored procedures and SSIS Packages Scripts to extract data from the database.
• Worked on creating Excel Pivot tables and charts shows the summarized data and gives the control to the user on how they want to view the data.
• Created covering indexes, filtered Indexes for better Performance to resolve Lookup Operations
• Worked on C# .Net to perform additional filters on SSRS reports.
• Created transform files using C# .Net for running the reports automatically every day and sending them to the target location.
• Created SQL Jobs for auto running the ETL packages, SSAS Cubes, and SSRS reports.

Environment: SQL Server … R2, SSAS, SSIS, SSMS, SSRS, Dynamic SQL, PowerPivot(Excel 2010), VB Script, C# .Net, Excel 2003, SharePoint, SQL Server Jobs.

Confidential, Indianapolis, IN

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling,creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins,Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition,SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Los Angeles, CA

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008,.NET Framework, C#, ASP.NET,CSS,T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential, Los Angeles, CA

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS.
• Created reports that call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Created several packages in SSIS.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Performed Query optimization & Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2008 Enterprise Edition,SQL Server Agent,SSIS 2008, SSRS 2008, C#,T-SQL,Windows 2000/2003 Server, XML, MS Excel, MS Access.

Confidential, Westlake Village, CA

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in documenting the code for understandability.
• Participated in creating reports that deliver data based on stored procedures.
• Experience in creating snapshots of static reports and configure subscription.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Involved in developing triggers to audit schema changes at the database level.
• Created sub-reports to present more detailed information about the summary.
• Designed and implemented stored procedures and triggers for automating tasks.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Data from various sources like flat files, to SQL Server database Using SSIS Package.
• Used Lookups Transformation to get the data from reference data sets
• Scheduling the SSIS packages and Jobs
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2005/2008.
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Worked on improving the performance of the system.
• Created permanent tables, temporary tables and table variables.
• Used Query Analyzer to optimize SQL queries.

Environment: SQL Server 2005/2008,SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS),C#,VBScript,ASP.NET,T-SQL,MS Excel 2003, MS SQL Query Analyzer, SQL Profiler.

Confidential 

SQL Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access and Created new security accounts.
• Performed Backup and restore of databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.