PROFESSIONAL SUMMARY

• 7+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Worked with different versions of SQL - 2005, 2008, 2008R2, 2012, 2014.
• Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
• Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Involved in DBA activities such as backups and restores.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

PROFESSIONAL EXPERIENCE

SQL Server Tools and Databases: SQL Server Management Studio (SSMS), SQL Server 2012, 2014,2016, MS Access 2008, Oracle 11g, SQL Server Integration Services (SSIS), SSRS (Reporting Services), SSAS (Analysis Services), Microsoft Visual Studio 2012/2014/2016, SQL Server Business Intelligence Studio(BIDS), SharePoint, .Net

BI tools: Power BI, Qlikview, Tableau

Statistical tools: SPSS, SAS JMP

Applications: Visual Basics, Excel -Macros

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

SQL BI Developer/ Power BI/ Data Analyst

RESPONSIBILITIES:

• Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• T-SQL in constructing User Functions, stored procedures, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Working on live site issues to fix slow running stored procedures, triggers etc. and provide Root cause analysis.
• Experience in Data Analysis, understanding trends and patterns in data.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.
• Converted the old Data flow logic written in .NET C# to SSIS packages.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Responsible for the analysis and reporting of consumer data generated for compliance across all touch points from multiple databases
• Involved in scorecard and KPI Reporting.
• Experience in generating performance reports (using slicer), cluster/scatter charts along with various other basic charts.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Experience with Power BI desktop and Power BI Service.
• Published dashboards on an intranet site using SharePoint Server.
• Migration of SQL Databases from SQL 2008 to SQL 2012/2014.
• Recommended internal process changes using data analysis.
• Collaborated with different stakeholders from various business units to validate and approve compliance tests independently.

ENVIRONMENT:MS SQL Server 2012/ 2014/ 2016,Microsoft Management Studio, Teradata SQL Assistant, Microsoft Visual Studio, MS SQL Server Integration Services (SSIS) 2012/2008R2/2008, SQL Server Reporting Services (SSRS), Power BI,T-SQL.

Confidential, Annapolis, MD

SQL BI / Data Analyst

RESPONSIBILITIES:

• Analyzed company’s business practice and product performance to determine potential growth.
• Extensively used SQL queries to translate data into valuable information for decision making.
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on SQL Servers.
• Gathered data from various data points such as SQL, Access DB, and Excel and flat files.
• Designed and implemented data models and reports in Power Pivot, Power BI to help clients analyze data to identify market trends, competition and customer behavior.
• Developed custom calculated measures using DAX in Power BI to compare the companies industry wide.
• Developed dashboards including various charts- bar charts, pie charts, scatter charts, bubble charts and shape maps.
• Involved in reporting of KPI and gauges for some parameters to keep track of close competitors in the industry.
• Provided in-depth market research reports for qualitative and quantitative methods.
• Provided SWOT analysis on financial data using Power BI charts.
• Analyzed data from SSAS by using excel pivot tables.
• Collaborated with different stakeholders from MAGNET to understand client’s businesses, their operational and manufacturing strengths.
• Recommended new product lines based on data driven analysis.
• Responsible for introducingproductsin new categories resulting in 40% increase in overall portfolio.

ENVIRONMENT:MS SQL Server 2012/ 2014/ 2016,Microsoft Management Studio, Microsoft Visual Studio, Oracle 11g, Access DB, Power BI, Power Pivot, Tableau.

Confidential, Atlanta, GA

Sr. SQL BI Developer /DBA

RESPONSIBILITIES:

• Detailed Data mapping for different schedules for FRY-M and FRY-Q’s
• Created SSIS process design architecting the flow of data from various sources to target.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services (SSRS).
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• DesignedSSIS Packagesto transfer data from various sources of the Company into the database that was modeled and designed.
• Design the ETL frame work for the data load into FRY Tables.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on the ADW Data Warehouse for Santander Bank.
• Create Master Package to run different other ETL in one Master package.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Worked in an agile scrum methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Migration of SQL Databases from SQL 2005/2008 to SQL 2010/2012/2014.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Perform T-SQL tuning and optimizing queries for SSIS packages.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Production support for SSIS and SSRS jobs.
• Worked as an IBM - COGNOS Report Designer and created number of Business Critical sales reports for company’s Management team.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.

ENVIRONMENT: MS SQL Server 2012/2014, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 ( MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server, Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Erwin Data Modeler.

Confidential, Owings Mills, MD

Sr. SQL Server Programmer

RESPONSIBILITIES:

• Experience in usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Extensively used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server 2008 R2
• Analyzing and designing reports and reporting solutions according to the specifications given.
• Knowledge and implementation of Reporting Services and other MS tools and in combination to design report solutions to deliver on several CI projects.
• Meet deadlines while meeting the reporting needs of the business users and project owners.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Designed the SSIS packages with error handling.
• Built a consolidated Data Mart for five different Company Organizations which was further populated and used to build a Cube on SQL Server 2012 for further reporting requirements.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Ad Hoc and Parameterized Reports using SQL server 2008 R2 Reporting services.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports using Sql Server Reporting Services 2008 R2 and and COGNO’s.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Wrote the Visible Basic expressions in SSRS according to the requirement of the report developed.
• Worked on some ETL development using Informatics.
• Reports were created according to the report specifications and make sure to submit the work assignment before the due time.
• Scheduling the jobs for monthly reports and yearly reports
• Played a major role in production support and maintenance of SSIS jobs.
• Documenting the Developed Code by following the Organizational guide lines where ever required.
• Perform T-SQL tuning and optimizing queries for Reports and SSIS packages.
• Assisted in Creating SSIS process design architecting the flow of data from various sources to target.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Use of version control system (SERENA) for proper accounting.

Environment:MS SQL Server 2008/2012, Micro Soft Visual Studio, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2007 (MOSS 2007Performance Point Server, MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential

SQL Server Developer / Admin

RESPONSIBILITIES:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing the physical design for the database.
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Created Stored Procedures, Triggers, Views and SQL Joins and other statements for various applications.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
• Thorough understanding of first NF (1NF), second NF (2NF) and third NF (3NF).
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Subreports using Sql Server Reporting Services 2008.
• Created SQL Server Analysis Project using MS SSAS 2008.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created complex SSAS cubes with multiple fact measures groups.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterizedand cascading reports using SSRS 2008.
• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multidimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Created Analytical reports by PROCLARITY tool.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Prepared quantitative data for statistical analysis- transformation of the unstructured data into structured data formats (excel).
• Developed VB code on Excel Macros for an automated application which pulled the data from manually entered Excel sheet to update the HR competency matrix itself by executing macro.
• Analyzed the training data for all the employees using SPSS.
• Used algorithms like regression and decision tree on SPSS.
• Developed various charts on Excel for analysis for decision making.
• Recommended which trainings are effective for employees from the analysis.
• Recommended the process on how to maintain the matrix.
• Experience with different phases of project life cycle- SDLC Process (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Experience in Agile- Scrum methodology.

ENVIRONMENT: Statistical tool- SPSS, VB, Excel- Macros