SUMMARY

• 7+ years of IT Industry experience in development, design and support of Microsoft SQL Server 2014/2012/2008 database.
• As a technical consultant, gained valuable experience in full Software - Development-Life-Cycle (SDLC) in implementation and support projects for healthcare, pharmaceutical and chemicals &Oil and gas industries.
• Experience in T-SQL Data Definition Language and Data Manipulation Language.
• Expertise in writing SQL Queries, Stored Procedures, Indexes, Views and User Defined Functions.
• Expertise in migrating from SQL Server 2005 to SQL Server 2008 and 2012.
• Expert in MS SQL Server suite of products like SSIS and SSRS of MS SQL Server 2008 and 2012.
• Experience in developing reports using SQL Server 2008 and 2012 Reporting Services (SSRS).
• Experience in creating varied reports like Drill-Down, Parameterized, Cascading, Table, Matrix, Chart, and Sub Reports.
• Hands on experience in creating ETL packages using SQL Server 2008/2012/2014 Integration Services (SSIS).
• Experience in Reporting Services, Power BI (Dash Board Reports), Tableau using MS SQL Server.
• Have been involved in end to end technical solution of several business processes of clients by active interaction with customers and end users.
• Experience in production support; identify and fix issues, and provide root cause analysis of issues reported in production environment in a timely manner.
• A team player with motivation, ability to work independently and work closely with the Business Analysts, Quality Assurance, Data Analysts and Functional Design Teams.
• Excellent analytical skills suitable for troubleshooting.

TECHNICAL SKILLS

DB Utilities: Management Studio, SQL Server 2008/2008R2/2012/2014 Query Editor, Reporting Server, DTS Import/Export

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), SISS 2005, SISS 2008, SSIS2012

Reporting Tools: SSRS (2012, 2008R2, 2008, 2005), Tableau

Methodologies: Database Design and Normalization, Data Modeling, OLAP

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

Operating Systems: Windows XP/2000//2008, Windows 7,Windows 10

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

SQL/ BI Reports Developer

Responsibilities:

• Designed, implemented and maintained the overall depression center’s SQL server database.
• Created and maintained SQL scripts, indexes and complex queries to extract data and generate analysis ready datasets.
• Designed and implemented application database code objects i.e. Stored procedures and views.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts.
• Utilized Power BI to amplify data visualizations with collaboration and data management.
• Generated meaningful routine reports as well as ad hoc reports for stakeholders leveraging visualization using SSRS.
• Developed multiple dashboards with Power BI depicting differing KPIs for business analysis .
• Performed quality assurance and testing of SQL Queries on SQL server 2012/2014 database servers.
• Created automated, interval backups of all research study and project database on newly commissioned server.
• Worked in collaboration with business stakeholders, contracted application developers and across functional units to identify business needs and get a consensus on recommended solution options.
• Ensured that IT best practices are applied and healthcare governance is followed to maintain integrity and privacy of healthcare data.
• Created Power BI Dashboards to show KPI's in the project.
• Maintained thorough documentation of the data security, change management and manual of operations.
• Following data management standards and healthcare governance to ensure analytics and reporting meet quality initiatives needs while ensuring accuracy, quality of data and privacy of the data.

Environment: SQL Server 2012/2008/2005 , Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, T-SQL, Windows 95/NT/ 2000/2003/2007 , XML, MS Excel and MS Access, visual studio 2005/2008/ 2012 , TFS 2008/2010(Team Foundation Server).

Confidential, Dallas Texas

SQL-BI Developer

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement.
• Created SSIS packages to extract data to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
• Extract Transform Load (ETL) development using SQL Server 2008R2, SQL 2008 Integration Services (SSIS).
• Designed SSRS reports using table filters, single value parameters, multi value parameters, and Cascading Parameters.
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup.
• Involved in Performance tuning and Query Optimization of Stored Procedures and queries using execution plan and profiler.

Environment: SSMS, SQL Server 2008/2012, MS Excel, SQL Profiler, T-SQL, MS SQL Server Reporting Services.

Confidential, Phoenix, AZ

SQL BI Developer

Responsibilities:

• Gathered the requirements by discussing with theUsers, Business AnalystsandTeam members.
• Wrote complex stored procedures, queries, triggers, functions and cursors for the OLTP batch and online processes.
• Created indexes, Constraints, and rules on database objects.
• Updated functional specification and technical design documents.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008/2012).
• Developed Query for generating Drill Down and Drill through Reports in SSRS 2008(R2).
• Involved in Optimization and performance of queries and stored procedures using SQL execution plan.
• Proactively monitoring the performance of SQL Server databases, troubleshooting system issues and monitored scheduled jobs.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Environment: SQL Server Integration Services 2012, 2008 (SSIS), SSRS 2008R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server 2008, Microsoft Office, Windows 2007.

Confidential, Allentown, PA

SQL BI Developer

Responsibilities:

• Migrated data from different sources (text based files, Excel spreadsheets) to SQL Server databases using SQL Server Integration Services (SSIS).
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008/2012).
• Extensively designed the packages and data mapping using Control flow task elements, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Designed SSRS reports using table filters, single value parameters, multi value parameters, and Cascading Parameters.
• Created Sub-Reports, Drilldown-Reports using MS SQL Reporting Services (SSRS).
• Worked on querying data and creating on-demand reports.
• Involved in Performance tuning and Query Optimization of Stored Procedures and queries using execution plan and profiler.

Environment: MS SQL Server 2000/2008, SSIS, SSRS, T-SQL, Windows XP 2000, MS Project.

Confidential, Sunnyvale, CA

SQL BI Developer

Responsibilities:

• Consolidating functional requirements, high level software design and transform it into real application.
• End to end production support and maintenance of the existing application.
• Developed and optimizedstored procedures, views, and user-defined functionsfor the application.
• Created Power BI Dashboards to show KPI's in the project.
• Migrated data from different sources (text based files, Excel spreadsheets) to SQL Server databases using SQL Server Integration Services (SSIS).
• Extracted the data from Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008/2012).
• Developed Sub Reports,Charts,Matrix reports,Linked reports and Drill-downreports as per the requirements using SSRS.
• Involved withQuery Optimizationto increase the performance of the Report.
• Comfortable in writing Unit/System testing Test Cases and preparing Test Data.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports.

Environment: MS SQL Server 2012/20 /7.0, DTS, Windows Server 2008, SSMS,SSRS, SSIS, SSAS, Report Builder 3.0, Team Foundation Serve, MS-Visual Studio, XML.

Confidential, NY

SQL developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server2000.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforced referential integrity.
• Involved in Implementation of Database design and Administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server 2000, Windows server 2003, SQL Profiler, SQL Query Analyzer, DTS, T-SQL