SUMMARY

• 7 years of IT experience in all the aspects of Software Development Life Cycle (SDLC) which includes Analysis, Design, Development, Testing of applications using Data Warehousing concepts and Business Intelligence tools.
• Strong working experience with MS SQL Server ( 2014/2012/2008 R2/2005/2000) and Visual Studio (2015/2010/2008/2005 ) to generate reports, design models, integration, developing custom utilities and applications using .NET.
• Extensive experience developing and implementing solutions using Microsoft SQL Server integration services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) for data warehousing and data marts.
• Experience in creating packages using SQL Server Integration Services (SSIS) for data Extraction from/Load to Flat Files, Excel File MS Access, DB2, Oracle etc., Creating and monitoring the batch jobs using SQL Server Agent.
• Expert in Creating Views, Complex Triggers, effective Functions and appropriate stored procedures to facilitate efficient data manipulation and data consistency.
• Very good experience in designing, development and deployment of SSIS packages.
• Designed SSIS Packages to Extract, Transform and Load data into Database, Archive data file from different legacy systems using SSMS on SQL Server 2005/2008/2012 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Experience in providing Logging, Error handling by using Event Handler, Precedence Constraints, Break Points and Custom Logging for SSIS Packages.
• Experience in MS SQL Reporting Services (SSRS). Generated tabular, matrix, drilldown, Drill through, summary Reports, sub reports, detailed reports, Parameterized and linked reports using SSRS.
• Developed several ad - hoc reports for one time purpose according to the customer requirement.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Experience in developing complex store procedures, required functions, creating indexes and indexed views for performance.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs by using, SQL Server Agent Job, and schedule SSIS Packages.
• Familiarity in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Very good exposure to Data Modeling including Dimensional Data Modeling, Star Join Schema/Snowflake Modeling, Dimensions and Fact tables, Physical & Logical Data Modeling, Visio.
• Experienced in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
• Delivered 24/7 support including scheduled and emergency night and weekend work.
• Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g/10g/9i/8i, DB2, Access

ETL Tools: SSIS, DTS

Reporting Tools: SSRS, SSAS, Crystal Reports, Tableau, Power BI

Languages: C, C++, C#, LINQ, Visual Basic

Web Servers: Microsoft IIS, SharePoint 2010/2007

Scripting Languages: JavaScript, JQuery, AJAX, HTML, XML, XSD, CSS, T-SQL, Powershell

Methodologies/Tools: UML, MS Visio

IDEs/CMS/Tools: MS Visual SourceSafe VSS, TFS, Visual Studio 2010/08/05/03

Operating Systems: Windows Server 2008/2003/2000 , Windows 7/XP

PROFESSIONAL EXPERIENCE

Confidential

MS BI Developer

Responsibilities:

• Understanding the Requirement Specifications and prepare Technical Design Documents.
• Interact with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created packages using the various control flow task such as data flow task, execute SQL task.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2012.
• Worked on creating complex T-SQL, Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Experience in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Performance Tuning, and Query Optimization.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.
• Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created database objects like tables, users, roles, stored procedures, triggers.
• Work with Tableau Server Admin to schedule extract refresh, upgrade desktop and server versions, actively participate in functional testing of the dashboards.
• Work on SQL queries - create, modify the queries to obtain a abstract set of data and connect to Tableau and create dashboards.
• Utilized advance features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Data migration from text files, csv, excel files to SQL server.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services
• Involved in automating SSIS Packages using SQL Server Agent Jobs. Created an ETL summary report which consists of the summary information for all the loading activities done each day and month.
• Performing Unit testing and internal QA for the developed application.
• Created and maintained the SSRS reports, design documents and other scrum status trackers available on SharePoint for the business users and the steering team.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2012, XHTML, XML, MS SQL Query Analyzer, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS) and ASP.NET, C#, T-SQL .

Confidential, Schaumberg, IL

MSBI Developer

Responsibilities:

• Involved in analysis, design, development, and enhancement of the data warehousing application.
• Installation and configuration of MS SQL Server.
• Created DTS packages for the data cleansing/transfer and transformation.
• Responsible for design and Normalization of the database tables.
• Modified the current stored procedures to meet current design.
• Created indexed views, and appropriate indexes to cut the complex query time.
• Provided day-to-day administration tasks like space and log management.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package.
• Design and implementation of Replication solution for SQL Server 2008R2.
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Performed Performance tune SQL statements, queries, triggers and stored procedures using SQL profiler.
• Created Bar Charts which is complied with data sets and added reference lines and forecasting.
• Created Crosstab reports to display underlying data based on various graphs and charts created for further data analysis.
• Created context filters to limit data sourced into tableau engine.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Developed SSIS packages using different types of Error Handling for various events.
• Involved in report creation using SQL Server Reporting Services (SSRS), and Excel spreadsheet as per the client Requirement and for the periodic analysis.
• Created Tabular and Matrix Reports Quarterly, Semi-Annually and annually by using SSRS.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Migration Assistant, SQL Server Profiler, SQL Server Management Studio and TFS.

Confidential, Tewksbury, MA

SQL Server BI Developer

Responsibilities:

• Analyze client requirements and translate them into technical requirements.
• Created various Tabular, Cross-tab, Matrix and Ad-hoc reports using SSRS.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Developed data access queries/programs using SQL Query to run in production on a regular basis.
• Created report snapshots to improve the performance of SSRS.
• Generated Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like Access, Excel.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa
• Created Stored Procedures, T-SQL, Triggers, Views and Functions for the database Application.
• Defined the report layout and identified Datasets for the report generation. Built drill down reports, and also parameterized reports using SSRS.
• Extensively used Report Builder and Report Manager in SSRS.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SSAS, SSRS, OLTP, Business Intelligence Development Studio, Visual Studio, SQL Server Profiler, SQL Server Management Studio, Excel, TFS, Windows XP.

Confidential

SQL Server SSRS Developer

Responsibilities:

• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Created calculated member for complex calculation in reports using Business Intelligence.
• Created matrix reports and table formatted reports.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Work closely with management and end-users to create and evaluate business requirements.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Managed off shore team in Report migration project.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Involved in Product Releases and support calls.
• Created Report Models for Business Users to create their own reports.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs didn’t interfere with each other.

Environment: SQL Server 2005/2008, Windows, T-SQL, SSRS, Share Point, BIDS.