SUMMARY:

• Over 5+ years of experience in the Analysis, Design, Development, Implementation and Testing of applications using Microsoft SQL Server 2008/2008R 2/ 2012/2014/2016 and the Business Intelligence Suite.
• Experience with software development life cycle (SDLC) and Project Management Methodologies in the healthcare sector and finance industry working for clients.
• I have been work in Dev, Test and Production Environment.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, Merge using SQL Servers to facilitate efficient data manipulation and data consistency.
• Expertise with SQL development skills including Stored Procedures, Trigger, Indexes, Views, User Defined Functions, Scalar, Table valued functions and SQL Transactions
• Experience with Database Administrator roles, like implementation of point in time backup and restore of databases, executing package, deployment, scheduling and managing jobs on SQL Server Agent and maintain good documentation, Mirroring, Log Shipping, Replication, Failover Cluster, Always on, Indexing, Performance Tuning and etc.
• Managed and maintained user’s security and permissions; and migrate database objects from one server to another server and database to another database.
• Experienced in creating SSIS Packages using Lookup, Derived Columns, Conditional Split, Sort, merge Join, Union All, extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task and etc.
• Expert in Power BI, Data warehouse/Data mart environment, Data Extraction, Transforming and Loading (ETL) using various tools such as SSIS, DTS, Bulk Insert, data cleansing and profiling.
• Experience in SSAS Cube Design, Star schema and Snowflake schema, Cube Deployment, Named Queries, Named Calculation, Perspectives, MDX, Tabular model, Creating Hierarchies, Creating Partitions, Rank Function in MDX .
• Experienced in creating Data Source and Datasets, Configuring and deployment report, Working with tables, Drop Down list Parameters, Cascading Parameters, Matrix, Lists, Document reports, Charts, Sub Report, Document Map and etc
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Experienced in Object Oriented Analysis and Design using UML Methodology.
• Experienced in SQL development with the tea in waterfall and Agile methodologies and Use Team Foundation Server (TFS) for central repository as a versioning control.
• Experience in working independently and inter-personal, problem solving, and communication skills.
• Highly experienced with Microsoft SQL Server 2008/2008R 2/ 2012/2014/2016 , MS-Access databases, excel and other relational Databases.
• Experienced in developing technical documentation in various stages of Software Development Life Cycle(SDLC).

TECHNICAL SKILLS:

Databases: MS SQL Server 2008R 2/ 2012/2

Programming Languages: T-SQL, C, C++, PL/SQL, MYSQL

SQL Server Tools: SSMS, SSIS, SSRS, SQL Profiler, SQL Server agent, Configuration Manager

Development Environment: SSDT/ Visual Studio 2005/2008/2012/2016

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

Reporting Tools: SQL Server Reporting Services(SSRS), Power BI, Tableau

Operating Systems: Windows XP/2003/2008 Server, Win 95/98, Vista, Win 7 Win 10, MAC OSX, Bootcamp & VMware

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SQL Server BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• The aim of project was to integrate data from different sources and build a central data repository for reporting, analysis and many other internal operational purposes.
• Actively involved and supported requirements gathering, understating them and create appropriate solutions to meet the business needs.
• Created Packages for Transaction processing using containers as For-Each Loop, Sequence & controlling flow of data using Components like Script Task, Data Flow, File System, and Execute Package.
• Used Event Handlers to debug packages and capture errors and report them to responsible departments.
• Developed SSIS packages for developing a fully-fledged data warehouse solution and deployed them.
• Created jobs to run the deployed packages as per requested schedule.
• Designed the product after analyzing the requirements.
• Gained performance improvement by direct execution of packages on server.
• Experience in creating Drill Through, Drill Down, Tabular & matrix reports.
• Created Ad-hoc Reports directly from Staging and Operational Data Storages for quick test and quality of data.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Wrote User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance
• Developed functional and design specifications
• Involved in Database design using SQL 2005 and wrote Stored procedures, triggers etc.
• Actively Involved Business in decision-making process ensuring quality Deliverables.
• A analyz ed the functional requirements for gaps, high level and low level designs, develop ed interfaces, unit testing of interfaces, support ed integration testing.
• Documented Technical artifacts
• Developed test plans and participated in code testing to ensure workability, completeness and quality
• Active Code review participation.
• Submitted estimates relating to project planning and technical issues for proper direction.
• Responded to project issues and concerns with logical and immediate action .
• Excellent experience in Requirement elicitation and analysis
• Prepared user guide, operating instructions and other documents required by users and the computer operation staff
• Developing enhancement, modification or customization as required for in house developed software
• Designed and implemented database in SQL(2005,2008,2012)/Oracle9g/11g and wrote complex queries, stored procedures, Triggers etc.
• SQL server for display and reports used windows forms and Excel reports developed in C#

Environment: MSSQL Server 2012/2014/2016

Confidential, Dallas, TX

Business intelligence Developer | Data analyst

Responsibilities:

• Used the SSIS to migrate Databases such as Oracle and Access database, flat files to centralized IT destination.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Successfully created dynamic configuration packages in SSIS.
• Used Event Handlers for Exception Handling in SSIS packages. Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Used Team Foundation Server (TFS) for central repository as a versioning control.
• Defined scope, time and cost of the project
• Based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables. Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Developed contextual diagram to depict the various integration with other several systems
• Developed Test script and Perform unit and integration test
• Worked as designer and senior programmer and analyzed user specifications for workability, completeness and business flow
• Participated in defining System Design, Architecture and Specifications and performed project and task estimation
• Designed databases and wrote Queries, Stored Procedures in SQL 2008R2/MSSQL Server2012/2014.

Technology & Tools: MSSQL Server 2008/2012/2014 , SSIS, SSRS, T-SQL, Visual Studio 2008, MS Office, SQL Profiler.