SUMMARY

• Around 7+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using 2008/R2, 2012,2014,2016 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 TSQL 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 2017 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.
• 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.
• Functional knowledge of C#, .Net, JavaScript, HTML, XML, RDBMS (Oracle, SQL Server), SharePoint Server, Communications protocols (TCP/IP)
• Experience in developing web applications using ASP.Net, ADO.Net.
• Worked very closely with Customers and End users, collect requirements and training 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 10, UNIX V7
• Databases: MS SQL Server 2016/2014/2012, Oracle 8i/9i, 10g, 11g, MS Access
• 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 (TSQL), PL/SQL, C, C++, Java, C#, ASP.Net, VB ScriptDB Modeling Tools: MS Visio, 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

PROFESSIONAL EXPERIENCE

Confidential, Frisco, Texas

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 2008 to 2012 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)
• 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.
• Created user defined functions in SSRS using VB script.
• Deployed SSRS reports on Microsoft office SharePoint (Moss).
• Wrote complex TSQL 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 2014/2016 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports, SharePoint 2007, C#, TSQL, ODBC, Excel, Access, Windows .

Confidential, Phoenix, AZ

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.
• 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.

Environment: SQL Server 2014, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, SSAS, ASP.NET, C#.NET, SSRS, 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, TSQL scripting and jobs.
• Successfully implemented indexes on tables for optimum performance.
• Developed complex stored procedures using TSQL to generate Ad-hoc reports within SQL Server Reporting services.
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided using SSRS.
• 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 2012, SSRS, DTS, TSQL, Oracle 10g, PL/SQL, TOAD, TSQL, Mainframes, C#. NET, VB.NET, Windows Sever, SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Confidential, Dallas, TX

SQL Server/ BI Developer

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PLSQL to create Tables, Views, and Triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning TSQL procedures, triggers and other database objects
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Used informatica for ETL process.
• Extensive use of TSQL DDL and DML commands for various applications.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
• Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Generated the various kinds of reports using Graphs and Images.
• Migrated some Crystal reports to SSRS reports
• Created Parameterized reports and linked reports using Bookmark links, Drill through links and Hyperlinks.

Environment: TSQL, SQL Server 2012, Crystal Reports 9.0, Windows 2000 Server, MS Access, Oracle, VB.Net, Erwin Data Modeler.