SUMMARY

• 8+ years of IT Experience in System Analysis, Designing, Testing Development & Support of SQL Server 2012/2008/2005/2000 in Production, Staging, Development environments. 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, Cursors, 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 TEMPeffective 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 wif 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.
• Has worked in fast paced AGILE environment & attended daily scrum meeting.
• Excellent verbal and written communication skills combined wif 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 wif a desire to learn client's business requirements..

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft -SQL Server 2008/2005/2000/7.0, Oracle 8i & 9i, MS Access.

BI /Data model Tools: Microsoft SQL Server Reporting Services 2005/2000, Crystal Reports, DTS, SSIS, Erwin And Visio.

Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/Windows XP, IIS 5, 6

Programming Languages: T-SQL, PL/SQL, C, Visual Basic 6.0, VB Script, SQL * Plus, VB .NET, ASP .NET

Application Packages: MS Office, MS Outlook.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2005, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE

MS SQL BI Developer

Confidential, Austin, TX

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible to support SQL Servers wif ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios
• Administering the MS SQL Server by creating user logins wif appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2008 R2 / 2012 Reporting Services, Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Has used BCP, BULK INSERT to transfer data from and to SQL server database
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: - MS SQL SERVER 2008 R2, SQL Server 2012, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

MS SQL Server Developer/SSRS/SSAS/SSIS

Confidential

Responsibilities:

• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• Gatheird user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Responsible for upgrading and installing SQL Server 2008 to SQL Server 2012.
• Involved in Writing SQL Queries, Triggers, functions and Stored Procedures on SQL Server 2012.
• Designed databases for applications wif requirements for large numbers of transactions, heavy access and high availability.
• Optimized T- SQL code.
• Worked wif Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin

Environment: - T-SQL, MS SQL Server 2012/2008, MS SQL Server Analysis Services 2012, MS SQL Server Integration Services 2012,MS SQL Server Reporting Services 2012.

MS SQL Server/ BI Developer

Confidential

Responsibilities:

• Analyzed the existing reports in Report.Net, Actuate and their data sources
• Analyzed & designed the business rules for data cleansing dat are required by the staging & OLAP and OLTP databases.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Worked wif integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of sales based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of sales wif respect to customers.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Used Visual Source safe for repository and maintaining versions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.

Environment: - MS SQL Server 2008 Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Microsoft Performance Point Server 2007, Microsoft Share Point Server, T-SQL, NET, C# MS Access and Excel.

SQL Server BI Developer (SSIS/SSRS)

Confidential

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 wif 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

SQL Developer

Confidential

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 wifin development team.
• Modified database structures as directed by developers for test/develop environments and assist wif 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 wif 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.