PROFESSIONAL SUMMARY:

• Around 7 years of experience as BI Consultant in Data Warehousing Environment that includes: Application Analysis, Design, Development, Data Migration, Testing, Support and Maintenance using MS BI Technologies.
• Involved in Project Planning, Design, Functional Specification, Design specification, Impact analysis, System test plan, User, High and Low level documentation.
• Strong Online Analytical Processing (OLAP) Data Warehousing Design and techniques: snowflake and star schemas design for the integration of fact and dimension tables. Extensive experience in data integrations and data transformations.
• Strong understanding in database and data warehousing concepts (OLTP & OLAP)
• Experience with logical and physical data modeling and database design.
• In - depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.
• Good experience Kimball methodology, Star-Schema modeling and Data Marts design
• Expertise in writing complex SQL queries (Nested & Sub), Query Optimization, T-SQL, Joins, Indexes, Partitioning, Views, Normalization, Stored Procedure, Functions, Error Handling, Trigger, cursors, Derived Tables, CTEs and Temporary tables.
• DBA Database Administration Experience in SQL Server including Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users, Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks, and the use of Performance Monitor/Profiler to solve Dead Locks/Long running queries in SQL Server 2012.
• Extensive experience in Tuning T-SQL queries to improve the database performance and availability.
• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Very good Experience in complete ETL process. Worked extensively on Data Extraction, Transformation and loading from different data sources using SSIS.
• Wrote PowerShell scripts for automating SSIS deployment.
• Experience of implementing Data Warehouse design concepts such as Slowly Changing Dimensions, Fact and Dimension models.
• Established best practice Methodologies and Optimization standards for ETL work.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery, Report security and Report Builder
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Excellent problem solving, analytical, Customer Interaction skills.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Have Domain Knowledge in Retail, Health Care, Banking and Life Science.

TECHNICAL SKILLS:

Programming Languages: C, C#, VB.Net

Relational Databases: MS SQL Server 2008/2012/2014 , MS Access

Operating Systems: Windows NT/98/2000/XP/Vista/7, Windows 2003/08 Server

T: SQL, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SharePoint Services (MOSS 2007), ProClarity, SVN, VSS, TFS, Teradata.

MSWord, MSExcel, MS: PowerPoint, Adobe Photoshop 6/7, Acrobat Reader / Writer, Visio.

Application Development: HTML, ASP.Net, Power Shell

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Data Analyst/SQL Developer

Technical Environment: SQL Server 2012, Report Builder, SSRS, MOSS, DB2, Windows XP/Server 2008, Power Shell, SQL Client toolsTeradata, Power BI

Responsibilities:

• Transformed complex business logic into database design and maintaining it by using SQL objects, stored procedures, user defined functions, views, sub queries, Ranking functions, Derived tables, common table expressions (CTEs) SQL scripting and jobs.
• Analyzed data models, data relationships, and dependencies for greatest optimization.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests.
• Created linked servers to write validation queries against the source and target present on different servers.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules .
• Extensively used SQL to manipulate and architect to produce results for users.
• Worked with Business Stakeholders, Application Developers, and Production teams and across Functional units to identify business needs and implemented solution options.
• Optimizing and Performance Tuning SQL Scripts in order to make reports run smoothly and efficiently.
• Created and scheduled jobs for various tasks and was responsible for maintaining jobs through SQL Agent.
• Trouble shooting and fixing the issues/tickets received from end users.
• Performed quality assurance and testing of SQL server environment.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, Charts and Sub reports.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Confidential, Milwaukee, WI

Business Intelligence Data Modeler

Technical Environment: SQL Server 08/2012, Report Builder, SSRS, MOSS, DB2, Windows XP/Server 2008, Power Shell, SQL Client tools

Responsibilities:

• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers for validating the integrity of the data.
• Played an active role during the requirements gathering, analyzing and designing of the system.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Designed SSIS strategies to pull data from different sources, like flat files, Oracle and load it to the destination database.
• Provided Logging, Error handling by Event Handler and Custom Logging for SSIS.
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard reporting using Report Builder.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS and in Report Builder.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Developed Reports for County end users using Report Builder with updating Statistics.
• Involved in version control using TFS and updating the design documents, code.

Confidential, Boston, MA

BI Developer

Technical Environment: SQL Server 08/2012, SSIS, SSRS, SSAS, MOSS, DB2, Windows XP/Server 2008, Power Shell, SQL Client tools, Crystal Reports 8.5/9/10/XI R2/2008,Power BI

Responsibilities:

• Designing and implementing ETL mechanism for business requirements that includes incremental, historical data loads and transformations using SSIS
• Analyzed Source System data and preparing low-level documentation.
• Used SSIS to extract, transform and load data from multiple input sources like SQL and flat files to target database.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules .
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Worked closely with team to get various requirements. Involved in design, implementation of Technical Specs, Design Documents and Approach Documents.
• Developed roles for users to access reports as per security limitations.
• Used SQL extensively in command objects of Crystal reports.
• Created ad-hoc reports.
• Good Knowledge about admin tasks related to users, groups, folders, and security using Crystal Management Console CMC.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Created subscriptions and tuned heavy custom reports for better performance in SSRS.
• Developed test cases, involved in unit testing and make sure that the accuracy of the functionality. Supported end users in UAT testing.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status .
• Experience in configuring and deploying reports onto SharePoint Server.

Confidential, Stamford, CT

SQL/SSIS/SSRS Developer

Technical Environment: SQL Server 08/2012, SSIS, SSRS, SSAS, MOSS, DB2, Windows XP/Server 2008, Power Shell, Crystal Reports 8.5/9/10/XI R2/2008, Power BI

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to warehouse databases, data mart databases.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Data Warehouse tables.
• Creating new DB objects / Updating existing DB objects as per customer enhancements.
• Used Email Notification package success or failure. If the package is success send the mail with package name, how many records inserted, updated and total records using Send Mail Task. If the package is failed it will send the mail package name and error description using On Error Event handlers in Send Mail task.
• Used Merge Statement for maintain the Inserts and updates if the table have less data.
• Used different transformations lookup, condition split, Derived Column, Data Conversion.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Created Stored Procedures for package Initialization and end package information to update the package log table.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Used REST APIs to push the data in order to create datasets, dashboards, add and delete rows.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPI’s.

Confidential, Atlanta, GA

BI Developer

Technical Environment: SQL Server 08/2012, SSIS, SSRS, SSAS, MOSS, DB2, Windows XP/Server 2008, Power Shell, SQL Client tools

Responsibilities:

• Worked closely with developers, end users in designing and creating the Data mart.
• Creating Database objects - Tables, Views, and Stored Procedures.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages and Wrote PowerShell scripts for automating SSIS deployment.
• Created automated solution using Windows PowerShell to manage the backup of the primary file server.
• Automated Power Query refresh using Power shell script and windows task scheduler and executing the scripts in SSIS package.
• Provided Logging, Error handling by Event Handler and Custom Logging for SSIS.
• Involved in gathering Business Requirements and System Specification from users and analysts.
• Developed Charts and Tabular reports in Excel and Web format using SSRS.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Designed, developed, also maintained and documented (KPIs), Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server 2007 and SQL Server Analytical Services.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Agent & Power Shell.

Confidential, Waukegan, Illinois

BI Developer

Technical Environment: SQL Server 08/2012, SSIS, SSRS, SSAS, MOSS, .Net, Silverlight, Windows XP/Server 2008

Responsibilities:

• Developed the SSIS ETL packages which will take the data from various sources like flat files, MS Access and such and will perform the appropriate transformations over the data and will load the data onto targeted SQL Server Data mart.
• Worked with Data conversions, Merge Join, lookup transformations, Oledb Command, Execute SQL Task, Script Task, Sequence containers and For Each Loop containers in the package development.
• Developed the packages to perform Exception handling, staging of data and database backups.
• Debugging and troubleshooting the technical issues while implementing the applications.
• Creating new DB objects / Updating existing DB objects as per customer requirements.
• Worked with Deploying the SSIS packages using SQL Server package deployment wizard to deploy the packages on the production server.
• Created complex Stored Procedures, Triggers, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Developed hierarchies, built relationships between attributes and deployed in SSAS.
• Implementing SSAS Cubes and writing MDX queries.
• Involved in data validation and data quality in the SSAS Cube development.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Agent & Power Shell.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Involved in version control using TFS, GIT.