SUMMARY

• Around 7+ years of extensive experience in database design, development and administration as SQL Server Developer/Business Intelligence Developer.
• Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.
• Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases.
• Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.
• Experience with SQL Server 2008,2016,2017,2019 and Denali 2012.
• Experience in designing and creating data warehouse(star and snowflake schema), fact table, dimensions and measures.
• Proficient in T - SQL queries using Stored Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL etc.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Proficient in Performance Tuning of SQL query.
• Excellent in MS SQL Server 2008 suite/2012,2016,2017,2019 of products like SSIS, SSRS
• Good experience in developing reports using SQL Server (SSRS) 2008/2012,2016,2017,2019
• Experience in Creating Triggers, Tables, Stored Procedures, Functions, Indexed Views, Indexes and Constraints in T-SQL.
• Used SSIS Import/Export Wizard for performing the ETL operations.
• Experience in using CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Deployed SQL Server Reports on to the report manager and delivering using ‘pulled’ and ‘pushed’ methodologies.
• Experience in installation of Agents on Hosts in both OEM12c & OEM 13c, Database Health checkup & Performance tuning running AWR report taking backups creating users by OEM 13c.
• Experience in generating different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Expertise with parameterized reports and Cascade Parameterized Reports in SSRS 2005/2008/ R2.
• Excellent experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database
• Involved in Huge data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Good in debugging an application using the tools provided by Visual Studio.Net IDE and resolving bugs.
• Exposed to complete software application development life cycle phases starting from business analysis, system study to deployment and support.
• Experience in making formal and informal presentations to technical and non-technical staff.
• Excellent team player with problem solving and trouble-shooting capabilities.
• 24 x 7 production support availability.

TECHNICAL SKILLS

SQL Server Tools: SSMS, Query Analyzer, Profiler, DTS, BIDS, SSIS, SSRS

SQL Monitoring tools: SQL Server Profiler

Databases: SQL Server 2008R2/2012,2016,2017,2019 MS-Access, Oracle 9i/10,13g

Reporting Tools: SSRS 2008R2/2012,2016 MS Excel 2010/2013

IDE: BIDS 2008/2010

Programming Languages: T-SQL, SQL, PL/SQL, VB.NET, C

Web Technologies: HTML/DHTML

Repository Tools: SVN, Star team, JIRA

Data Warehouse/Business: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL

Intelligence Tools: Server Analysis Services (SSAS), Visual Studio, Business Intelligence Development Studio (BIDS)

Operating systems: Windows XP, 2000, 98, 95, Windows 2003, Windows Vista, Windows 7UNIX

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

SQL/SSRS/SSIS Developer

Responsibilities:

• Worked with business gathering requirements.
• Created stored procedures to use as datasets for the Report Design.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2016,2017,2019.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data.
• Have written Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters, parameters, indicators, gauges, spark lines.
• Used TFS to maintain version history of SSRS reports (RDL), Store procedures and b.
• Used azure cloud technology to deploy the projects.
• Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader.
• Extract Transform Load (ETL) development usingSQLServer2017,2019SQLServer Integration Services (SSIS).
• Responsible for the database for the current project, where data is dumped into the database and scrubbed into the correct format per the requirement given by the client.
• Developed ETL package with different data sources (SQL Server, Flat Files, Excel Source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services.
• Extensively used Joins and sub Queries to simplify complex queries involving multiple tables.
• Responsible for enterprise level solutions development including data warehousing, data marts and/or software applications.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Responsible for high performance of data architecture and design including Star Schemas, Snowflake Schemas and Dimensional Modeling.
• Experience in Designing and Implementing Data Warehouse applications, mainly Transformation processes using ETL tool also actively involved in Database Querying, Data Analysis, Production support.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developing complex SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting, OLEDB Command with SQL etc.
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in the database
• Developing SSIS packages that upload multiple flat files using for each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: SSIS, SSRS, SSAS, TSQL, PL/SQL.

Confidential, Charlotte, NC

MSBI SQL Developer

Responsibilities:

• Work with business analysts and application developers to identify business needs and transforming business rules to database specifications.
• Designed SSIS Packages to extract data from various data sources into SQL Server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Created complex Stored Procedures to provide data to the front end and in turn load the Override tables based on the modifications.
• Modified the existing Stored Procedures to enhance the performance and provide better logging for error handling.
• Created Table types and used them in Stored procedures to store the ad hoc data requests from UI
• Used SQL Profiler to optimize queries and enhance the performance of databases.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Deploy the SSIS packages on different environments to load the data into data warehouse.
• Scheduled the Jobs in SQL Agent to run on daily & Weekly basis and Monitoring them.
• Developing stored procedures and complex queries to create SSRS Datasets.
• Involved in unit and user acceptance testing and coordinated with QA team for bug fixing.
• Providing the documentation of all the activities that are performed by the development team.
• Participate and provide inputs during business weekly meetings.

Environment: SQL Server 2012, SSIS, Visual Studio 2010, Report Builder 3.0, SQL Server BIDS, SVN, JIRA and MS Excel 2013.

Confidential, Charlotte, NC

MSBI Developer

Responsibilities:

• Created and Modified Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc.,
• Work with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.
• Work on designing, developing SSIS packages (ETL) to extract data from Heterogeneous data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then load the data into destination Data Warehouse tables by performing different kinds of transformations.
• Created mappings to extract data from Staging area to enterprise data warehouse with applying various business rules.
• Used Collections, Bulk Collections for handling large amount of data in PL/SQL.
• Extensively used SSIS Script task to do certain database operations from Web API.
• Profile and gather data from live systems to improve application performance.
• Used SQL Profiler to optimize queries and enhance the performance of databases.
• Creating the deployment scripts and responsible for SQL code migration from Dev to QA and QA to production.
• Deploy the SSIS packages on different environments to load the data into data warehouse.
• Scheduled the Jobs in SQL Agent to run on daily & Weekly basis and Monitoring them.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2012andSSIS packages in Business Intelligence Development Studio (BIDS).
• Generate different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports, Drill Down, Drill Through, Parameterized and Sub-reports using MS SQL Reporting Services (SSRS).
• Deploy and schedule Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly, quarterly and random ad-hoc reports for various business users.
• Work with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.
• Developing stored procedures and complex queries to create SSRS Datasets.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Responsible for Monitoring of Alerts and Performance of the System.
• Resolving the sev1-3 incident and working on Change tickets for the deployments.
• Involved in unit and user acceptance testing and coordinated with QA team for bug fixing.
• Providing the documentation of all the activities that are performed by the development team.
• Recommending technology solutions that meet business needs and producing functional specifications for business approval.
• Providing performance/enhancements Feedbacks on production systems.
• Participate and provide inputs during business weekly meetings.
• Provided shift based on-call DB support.

Environment: SQL Server 2012, SSIS, SSRS, Visual Studio 2010, Report Builder 3.0, SQL Server BIDS, C#.Net, VB Script, SVN, Star Team and MS Excel 2013.

Confidential, Minneapolis, MN

MSBI Developer

Responsibilities:

• Created mappings to extract data from Staging area to enterprise data warehouse with applying Various business rules.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created ETL processes, leveraged Excel spreadsheets, wrote and executed SQL queries to load aggregated data from Microsoft Access 2003 to SQL Server 2008.
• Generated various types of reports (Graphical Reports, Tabular Reports, Parameterized Reports) using SQL Server Business Intelligence development studio and SSRS.
• Created various types of reports sch as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Constructed complex stored procedures, Views, Functions (UDF’s) and SQL queries to aid in report generation and to access Rule base data from SQL Server.
• Performed and fine-tunedStored ProceduresandSQL QueriesandUser Defined Functions.

Environment: SQL Server 2008 R2, SSIS, SSRS, Visual Studio 2010, Report Builder 3.0, SQL Server BIDS.