SUMMARY

• Highly motivated SQL server Developer with Ten Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005 , SSIS and SSRS. Knowledge of working on SQL Server 2014/2016.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/2008/2005 /2000.
• Experienced in client requirement Analysis, design, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/2008/2005 /2000, SSIS, SSAS and SSRS 2005/2008/2012/2016.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts and Batches.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Worked Extensively on ETL process using SSIS package.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Extensive professional experience in design, development, implementation and support of mission- critical Business Intelligence (BI) applications.
• Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.
• Expert in creating various type of reports such 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.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting
• Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production.
• Maintain disaster recovery strategies for the database and failover methods.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts and Data Visualization with Tableau software.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Good understanding of Health care, and Retail domains.

TECHNICAL SKILLS

• SQL Server 2016/ 2012/2008/2005 /2000
• MS-Access
• OLE-DB
• SSAS and OLAP
• Transact SQL
• VBScript
• VB.Net
• ASP.Net
• C/C++
• C#.Net
• Familiarity with process and Python software development
• SQL Enterprise Manager
• Query Analyzer
• Advanced knowledge of SQL
• Query Optimization
• Performance Tuning with SQL Server
• SQL Server Management Studio
• SQL Server Integration Services (SSIS)
• Import Export Data
• BI Reporting Tools: Power BI
• Reporting Services (SSRS)
• Tableau and MicroStrategy
• SQL Server Reporting Services (SSRS)
• Microsoft Excel
• Crystal Reports
• Windows 95/ 98/NT/2000/XP/Vista

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the application
• Developed Physical data models and created DML scripts to create database schema and database objects
• Performed Debugging on the Stored procedures for the requirement to handle the errors
• Employed Transparent Data Encryption, a new feature of SQL Server 2008 to store the data securely by encrypting the database files.
• Development of custom scripts and stored procedures for data import and manipulation
• Implemented Full Text Search for fast and efficient querying when large and unstructured data is encountered.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts. Visualize Data.
• Server databases using SQL Server Integration Services (SSIS ) to overcome transformation constraints.
• Implemented Incremental load, used Event Handlers to clean the data from different data sources
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS )
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports .
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder and Power BI with updating Statistics.
• Developed Power BI reports using query logic based on business rules, and visuals selected by stakeholders
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005
• Interacting with the Database Administrator to maintain the database used DBCC Statements to perform maintenance tasks before backing up the databases.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production.

Environment: SQL Server 2000/2005/2008/2012/2016 , Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, C#, .Net, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, MS Access, MS visual Studio, BIDS, BI Reporting Tools: Power BI, Tableau and MicroStrategy.

Confidential, Allen, TX

SQL Server SSIS/SSRS Developer

Responsibilities:

• Played an active role during the requirements gathering, analyzing and designing of the system.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created logical data model using ER/Win 4.0.
• Development of large-scale test databases and associated maintenance scripts.
• Development of custom scripts and stored procedures for data import and manipulation
• Configuring, tuning, and optimizing SQL Server 2005.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery .
• Created horizontal partitioning of data for different file groups.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS .
• Production support, troubleshooting and debugging in a high volume transaction processing environment utilizing a lot of XML .
• Configured and trained users to use Reporting Services.
• Create parameterized Reports using Charts, Cross-Tab and Sub-report types.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).

Environment: Windows 95/NT/2000/2003, Microsoft SQL Server 2000, Microsoft Excel, ODBC, XML, SQL Query Analyzer, DTS, Erwin, Visual Source Safe, Reporting Services(SSRS), BIDS.

Confidential, Wayne, NJ

SQL Server SSIS/SSRS Developer

Responsibilities:

• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases
• Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of operational systems
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Wrote stored procedures for report generation in SQL Server2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Created and Maintained Database Maintenance Plans .
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting
• Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production.
• Maintain disaster recovery strategies for the database and failover methods.

Environment: SQL Server 2000/2005, Windows Server 2003, Windows NT, .NET, DTS, BIDS.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases
• Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of operational systems
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Wrote stored procedures for report generation in SQL Server2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Created and Maintained Database Maintenance Plans .
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting
• Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production.
• Maintain disaster recovery strategies for the database and failover methods.
• Assisted the team in developing complex Business Requirement Documents (BRD)
• Involved in creating Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Involved in Translating Business Requirement Document (BRD)

Environment: SQL Server 2000/2005, Windows Server 2003, Windows NT, .NET, DTS, BIDS.

Confidential

Data Analyst, Quality Analyst

Responsibilities:

• Conducted functionality, usability, interface, compatibility and security testing of the web application developer.
• Defined the test scenarios (testing the bounds, validations) for the web application, identified and reported bugs to the development team.
• Additionally performed bug fixes for the application, as part of the development team.
• Developed and maintained checklists to ensure development was aligned with clients specifications and requirements.
• Maintain medical records.
• Worked on various billing and coding procedures.
• Assisted in preparing user stories in the product backlog after the collection of functional requirements from system users and prioritized the requirements in product backlog.
• Provided support to QA team.
• Creation and Execution of the Functional Test Cases.
• Responsibilities of site feasibility assessment for business, improvements on site draw backs, and focus on new techniques for low CAPEX and maintenance. His major contribution was on systems setup, QA/QC processes, data warehouse management which enabled smooth transition of various tasks with zero snags. Also involved in Vendor Management.
• Managed all surveillance projects as per contract documents and ensured compliance to all requirements.
• Prepared reports for all Projects and Warehouse in/out Transactions of all business units across India.
• Worked closely with the team in developing complex Business Requirement Documents (BRD)
• Involved in creating Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Co-ordinate with the team in Translating Business Requirement Document (BRD)

Environment: SQL Server 2000/2005, SQL, Oracle, Windows Server 2003, Windows NT, .NET, DTS, BIDS, QTP, WinRunner, LoadRunner, Unx