SUMMARY

• Overall 4+ years of IT experience as SQL Server - BI Developer/Data Analyst with solid understanding of Database Design, development and implementation of SQL Server and providing ETL/Business Intelligence Applications using Microsoft components.
• Expertise in writing T-SQL queries, dynamic queries and sub-queries, complex joins for generating complex stored procedures, triggers, user-defined functions, views and cursors.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database objects like tables, Constraints and indexes.
• Experience in building Data Integration,WorkflowSolutions and Extract, Transform and Load (ETL) solutions for data warehousing usingSQLServer Integration Service (SSIS).
• Extensive knowledge in tuning T-SQL queries to improve the database performance and availability.
• Experienced in using SSIS Import/ Export Wizard, SSIS designer and other package execution utilities for performance the ETL operation.
• Highly proficient in creating SQL Server reports, Handing sub-reports and writing queries to perform roll-up and drill down operations in SSRS.
• Experienced in creating complex drill-down reports, parameterized reports, dropdowns and images, charts using SSRS.
• Experience in development of Extracting, Transforming and Loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Expertise in data cleansing, data consolidation and aggregating by developing various SSIS Packages using data transformation and deploying them across all environments.
• Experienced in developingPowerBIreports and dashboards from multiple data sources using data blending.
• UsedPowerBIto prepare dashboards to create attractive visualizations.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using PowerPivot,PowerView &PowerBI.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, Java, XML, and PL/SQL.

Operating Systems: Windows, UNIX, Linux.

Microsoft Technologies: SQL Server 2008/2008R2/2012/2014, SSIS/SSRS/SSAS for OLTP & OLAP

Web technologies: HTML, CSS, JavaScript, ASP.NET

Database Query Languages: SQL, PL/SQL, T-SQL, MySQL.

Application Tools: Visual Studio 2005/2008/2010/2012.

Design Tools: UML (Rational Rose), MS Visio

BI Tools: Informatica (ETL Tool), Business Objects, Tableau, Microsoft Power BI

Other Skills: MS-Office, SharePoint.

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer/ Data Analyst

Responsibilities:

• Analyzed the report design Requirements and Constraints.
• Involved in Creating and Modifying T-SQLStored Procedures/Triggers for validating the integrity.
• UsedSSISto create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Wrote T-SQLqueriestovalidatethe error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.
• Deployed the createdSSISpackages in Development and Testing environments.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging forSSISPackages.
• Developed and maintained ETL jobs for the Data Warehouse usingSQLServerAgent.
• Developed tabular, matrix, chart, Drill-down, parameterized and cascading reports (SSRS).
• Created reports using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed Custom/Conditional formatting reports and deployed them onserverusingSQLServer Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data usingSQLServerReporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting ServiceServer(SSRS).
• Created Ad-hoc reports and data exploration using Power View.
• PublishedPowerBIdesktop reports created in Report View to thePowerBIservice.
• Transformed and combined the data using Query Editor inPowerBI.
• UtilizedPowerQuery inPowerBIto Pivot and Un-pivot the data model for data cleansing and data massaging.

Environment: MS SQL Server 2014 SSIS/SSRS/SSAS, Visual Studio 2012, T-SQL, MS Access, MS Excel.

Confidential, Aldie VA

SQL Server BI Developer/Data Analyst

Responsibilities:

• Involved in planning, defining and designing databases according to business requirements and provided documentation.
• Interviewed business stakeholders, participated in JAD sessions and gathered report specification requirements.
• Developed SSIS packages and utilized T-SQLstored procedures to transfer data from OLTP databases to staging objects.
• Deployed various SSIS tasks such as conditional split, derived column and data validation checks during staging, and finally loaded data to data warehouse.
• Configured jobs and alerts inSQLServerfor SSIS packages and scheduled their execution.
• Identified database tables to define queries and generated reports for analyses using SSRS.
• Created various SSRS reports including cross-tab, conditional, drill-down, sub report and parameterized reports based on business requirements. For sub reports, multiple complex formulae were adopted.
• Designed and created report templates, bar graphs and pie charts based on data and inputs from different departments and configured schedules to automatically generate monthly, weekly and daily reports.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.

Environment: MS SQL Server 2012/2014 SSIS/SSRS/SSAS, Visual Studio 2012, T-SQL, MS Access, MS Excel.

Confidential, Warrensburg MO

Teaching Assistant (Business Information Management)

Responsibilities:

• Assisted Undergrads in “Business Information Management” course that explains how raw business data is gathered, stored, analyzed and distilled into valuable strategic information.
• The course mainly concentrates on fundamentals of computing (requirement analysis, information retrieval, Programming, visualization, databases), business (accounting, finance, marketing, management) and analytical methods (statistics, business intelligence, decision analysis).
• Mentoring students on these topics and for performing hands-on tasks predominantly in MS Excel, Access, PowerPoint and Word.

Confidential

SQL Server BI Developer/ Data Analyst

Responsibilities:

• Created complex Stored Procedures, Triggers, functions, cursors, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency and adding/changing tables for data load and transformation, and data extraction.
• Experience in Performance tuning of SSIS packages and implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task, etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse and also migrated data from staging area of SQL Server to SQL server 2012.
• Created and designed complex Reports like Drill Through, Tabular, Drill Down, and matrix, sub Reports in SSRS and generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP), navigation reports (Hyperlink) etc.
• Used Performance Point Server to provide users with rich dashboard filters to dynamically filter all the report views displayed on the dashboard. Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder’s
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Involved in testing of Business Objects Reports and Fix any ETL issues if exists.
• Actively supported Business users for change requests and solving the issues by troubleshooting.
• Involved OLTP systems and Created facts, dimensions and star schema representation for the data warehouse.

Environment: MS SQL Server 2008R2/2012 SSIS/SSRS/SSAS, Visual Studio 2012, T-SQL, Share Point, Performance Monitor, Query Optimizer, Oracle 10g. MS Access, MS Excel.

Confidential

SQL Server BI Developer/ Data Analyst

Responsibilities:

• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity for BI and OLTP operations.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
• Experienced in loading data into relational database using ETL tool.
• Worked with SSIS to design the packages for ETL Support.
• GeneratedT-SQLscripts for application development.
• Created Stored Procedures and User Defined functions.
• Created Indexes to speed up the queries.
• Design many tables for efficient performance of applications and data pull.
• Create roles and permissions for the data warehouse applications.
• Moving and promoting the data from development to production.
• Participated in re-design and development of back-endSQLServer database, wrote queries, triggers and stored procedures.
• ProgrammedSQLServer 2008R2 Reporting Services using Microsoft Visual Studio 2008.
• Used complex expressions to filter and parameterize, and format the contents of a report.
• Performed Migration of databases fromSQL2008 to SQL2008 R2 using SSIS.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Scheduling Jobs and Alerting usingSQLServer Agent.
• Used Performance Monitor andSQLProfiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2008/2008R2, SSIS, SSRS, Visual Studio 2008, Erwin r7.2, MS Access.