SUMMARY

• Around 5+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2000/2005/2008/ R2, 2012 for both OLTP & Data warehousing applications in various business domains.
• Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Involved in relational data modeling and multi-dimensional modeling using De-normalizations, Fact tables, Dimension tables, Star schema for OLAP systems.
• Experience in SQL Server DTS and SSIS package design, development, and deployment using SQL 2008/2005 in Control flow, Data flow, Error Handling and Event handling in different heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Extensive experience in SSRS and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down and Sub reports.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Worked on SQL BI solution integration with Microsoft Share Point Server (MOSS).
• SSExpertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Knowledge of normalization, data warehousing and data transfer, maintenance, code review and automation.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Worked on OLAP Data warehouses, Modeling, Design, cube development including KPIs, Data mining, working with changing dimensions.
• Experience in OLAP cube partitions, aggregations, optimization as well as refreshing cube data.
• Experience in developing web applications using ASP.Net, ADO.Net.
• Worked very closely with Customers and End users, collect requirements and or resolve any business process related issues.
• Expert at understanding Business and transforming requirements into SSIS packages.
• Self-Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS

Operating Systems: MS DOS, Windows 9x/2000/NT/Server 2003/XP/Vista/7, UNIX 4.0

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005, Oracle 8i/9i, 10g, 11g, MS Access 2000/2003/2007

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Analysis Tools: SQL Server Analysis Services(SSAS)

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Bulk Insert and BCP

Languages: Transact SQL (T-SQL), PL/SQL, C, C++, Java, IIS, C#, ASP.Net, VB ScriptBusiness Tools Word, Excel, PowerPoint, Access, Visio, Outlook

DB Modeling Tools: MS Visio 2010, Rational Rose, Erwin 4.0,Visual Paradigm for UML

Reporting Tools: SQL Server Reporting Services (SSRS), Report Writing in SSRS, MS Excel

.Net Frameworks: .Net Framework 1.0/2.0/3.0/3.5 , Microsoft Office SharePoint Server (MOSS 2007)

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

MS SQL Server/BI Developer

Responsibilities:

• Designed and developed databases for OLTP and OLAP Applications.
• Provided support to 50 database Servers. Support included Production, QA and Development
• Upgraded database tables from 2000 to SQL 2005 and SQL 2008, 20 SQL environment.
• Created complex Stored Procedures for data retrieval.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse.
• Created SSIS packages to transfer data across heterogeneous data sources.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Create business class using C# to access SQL Server 2008
• Strong work experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created triggers, UDF, views, tables, and generated TSQL script for application.
• Analyzed execution plan and optimized queries by creating indexes.
• Created linked servers to fetch data from Oracle.
• Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application jobs execution.
• Created user defined functions in SSRS using VB script.
• Deployed SSRS reports on Microsoft office SharePoint (Moss).
• Wrote complex T-SQL queries and Stored Procedures for the reports
• Created Cubes in Analysis Services.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Tested the data with complex queries, joins and sub queries.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, ASP.NET, C#, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP.

Confidential, Frisco, Texas

MS SQL Server/ BI Developer

Responsibilities:

• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Extensively worked in analyzing Stored Procedures on Legacy Environment, produce documentation and re-create them on New environment
• Created more than 1000 stored procedures using Common Table Expression (CTE) and various types of UDF functions
• Generated multiple Enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, sub-reports, charts, Pie charts, conditional and dynamic reports using SSRS 2012.
• Worked with Oracle Database and Microsoft SQL Server using custom Windows services and SSIS; Ported data from DB2 to SQL Server using both SSIS and custom C# applications when decommissioning older applications
• 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.
• Worked on all types of report types like tables, matrixes, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Used most of the controls and features in SSIS for transforming data from different sources.
• Developed, monitored and deployed SSIS packages.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional, Split, Derived columns etc.
• Identified duplicate data by using an Aggregate transformation that group’s data by contract id. An email task was used to point other team members and managers to the files with the unacceptable data and also state the data issues.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Involved in creating the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.

Environment: SQL Server 2000/2005/2008/ 2012, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, SSAS, ASP.NETC#.NET, SSRS 2005/2008/2012 , MS SQL Server Analysis Services(SSAS), VBA and VB Script.

Confidential, Herndon, Virginia

MS SQL Server Developer

Responsibilities:

• Gathering the requirements by interacting heavily with the business users, multiple technical teams to design develop the workflows for the new functional piece.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes
• Extensively used joins and sub queries for complex queries involving multiple tables from different databases.
• Performance tuning of stored procedures and functions to optimize the query for better performance.
• Transformed complex business logic into database design and maintaining it by using Sql objects, stored procedures, user defined functions, views, T-SQL scripting and jobs.
• Successfully implemented indexes on tables for optimum performance.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting services.
• CreatedSub Reports, Parameterized and Drill down Reportsbased on the requirements provided using SSRS.
• Advanced C# techniques, including LINQ queries, memory management, threads, asynchronous & parallel programming, reflection.
• Worked on COSMOS Workgroup Feed Import. The Automated feed will update tables from COSMOS Data.
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
• Scheduled SSRS reports for end users and managed the security of the reports.
• Exported SSRS reports to various formats like PDF, Word and Excel and scheduled to reports to send as an email body.
• Strong analytical and problem solving skills coupled with interpersonal and leadership skills.
• Interaction with the clients to gather out the requirements and assist them in immediate workarounds for the issues with the application.
• As SSRS developer, working closely with Business Analysts gathering and clarifying data reporting requirements

Environment: MS SQL Server 2008R2, SSIS 2008/2005, SSRS 2008/2008R2, DTS, T-SQL, Oracle 10g, PL/SQL, TOAD, T-SQL, Mainframes, C#. NET, VB.NET, Windows Sever 2000/2003/2008 , SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Wrote complex queries, triggers and stored procedures, views and user defined functions.
• Design and implement database logical and Physical Schemas.
• Responsible for database tuning using normalization and application tuning.
• Maintenance of Development, System test, Assemble test and Integration Servers and databases.
• Query tuning, Index Tuning and performance tuning.
• Creation and maintenance of databases, objects.
• Users and user group creation and maintenance.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Created custom and standard reports using Crystal Reports.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
• Created and modified stored procedures to Create Reports.

Environment: SQL Server 2005 Enterprise Edition, MS PowerPoint, MS Access 2000 & Windows 2K platform