SUMMARY

• 7 years of experience in Business Intelligence development methodologies, tools, and techniques, across various domains such as Healthcare, Finance, Medical products, Manufacturing and Transportation.
• Expert in Microsoft based business intelligence tools, such as Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services(SSRS), Microsoft SQL Servers Analysis Services (SSAS) using MS SQL Server 2012/2008/2008 R2/2005.
• Expertise in creating/modifying Tables, Views, Stored Procedures, Functions, indexes, CTEs and Triggers and in depth knowledge in query optimization & performance tuning.
• Expertise in creating complex queries such as all kinds of joins (Left join, Right join, Full join, Outer join) and sub queries.
• Extensive T - SQL experience in creating complex queries, like joins, functions, sub queries, CTEs for data manipulation using SQL server.
• Excellent understanding in database and data warehousing concepts (OLTP and OLAP).
• Full knowledge of data warehouse methodologies and data modeling knowledge, Dimensional Modeling, Star Schema/Snowflake Schema, Fact and Dimensional tables.
• Experienced in designing ETL packages, extracting, transforming and loading data from OLTP and various sources into staging area and Data Warehouse using SSIS.
• Experienced in data mapping implementation and design.
• Experienced in scripting, script task, script component, with SSIS, or SSRS.
• Experienced in Error and Event Handling by setting Precedence Constraints, Break Points, Check Points and Logging in SQL Server Integration Service (SSIS).
• Good understanding of Data Virtualization methodology and tools, such as Microsoft Reporting service, Tableau, Power View, and Qlikview.
• Excellent experience in creating appealing drill-down reports, drill-through reports, parameterized reports and adding features such as sub-reports, matrix, gauge and various charts in Reports using SQL Server 2005/2008/2008 R2/2012 Reporting Services (SSRS).
• Experience in Linked, Snapshot, Cached, Ad hoc reports for various product based on requirement in SSRS.
• Experience in creating OLAP Cubes and KPIs using SQL Server Analysis Services.
• Experience in calculating measures and dimension members using multi-dimensional expression (MDX), aggregations, and user-defined functions.
• Strong Excel background, Pivot tables, formulas, and macros(VBA).
• Database Administration experience.
• Good understanding of software development life cycle(SDLC) with expertise in requirement gathering, analysis, transforming them into technical design, creating BRD, FRD, SRS; Agile/Scrum environment
• Experience in design, development, testing, implement and maintenance of business applications using SQL Server SSIS, SSAS and SSRS.
• An enthusiastic and goal oriented team player with excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

• Microsoft SQL 2 /2000
• MS Visio
• Microsoft SQL Server Integration Services(SSIS)
• Microsoft SQL Server Reporting Services(SSRS)
• DTS
• Microsoft SQL Servers Analysis Services (SSAS)
• SharePoint 2010
• Report Builder 3.0
• MS Office
• Power BI Office 365
• Minitab 17
• Matlab
• Python
• Qlikview
• Tableau
• Crystal Reports
• SAS
• ERP
• Visual Basic
• Aspen Plus
• Excel
• Flat files
• Oracle
• DB2
• Access
• Microsoft Dynamic

PROFESSIONAL EXPERIENCE

Confidential, Chicago, Illinois

Business Intelligence/ ETL Developer

Responsibilities:

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Created new SSIS packages to extract, transform and load data from one database to another and from OLTP to OLAP using various tasks like execute SQL task, data flow task, and file system task; SSIS transformations like, conditional split, data conversion, aggregate, derived column, merge, script component, SCD(slowly changing dimensions) and so on.
• Created database objects like tables, indexes, views, user defined functions and stored procedure for data migration using SQL server.
• Filtered bad data using complex T-SQL statements, UDFs and implemented various constraint and triggers for data consistency.
• Created complex queries such as all kinds of joins (Left join, Right join, Full join, Outer join), CTEs, and sub queries using T-SQL.
• Created Stored Procedures and Triggers for data retrieval used in SSRS.
• Created or modified many ETL transformations such as, format revisions, look up, handing of null values, decoding fields, merging of data, character set conversion, deduplication and so on.
• Created various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views for data manipulation.
• Used common table expressions and temporary tables in various stored procedures; created various scalar functions and table valued functions
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in SQL Server 2012.
• Created different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Developed Reports for business end users using SSRS Report Manager, Report Builder tool, Tableau and Power BI.
• Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report and gave roles, user access with respect to security in Report Manager.
• Managed index statistic, Tables, Views and optimized queries by using execution plan for tuning database; Used SQL Profiler to collect the workload and updated clustered and non-clustered indexes.
• Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Created SSIS packages with Logging and Event Handling with Text File/SQL Server Log Providers under predefined events such as OnError, OnPreExecute, OnTaskFailed and OnPostExecute.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Production Environments.
• Supported troubleshooting with stored procedures, and SSIS packages as needed; properly documented ETL processes for future reference.
• Involved in creating different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services.
• Helped developing the T-SQL queries used in drill down reports in SSRS.
• Generated technical documents about database/data warehouse structures and functional specifications.
• Assisted in troubleshooting for the existing reports as needed.

Environment: Microsoft SQL Server Management Studio 2012/2014, MS Business Intelligence tools (SSIS, SSRS, SSAS), T-SQL, Oracle, Excel, Access, Flat file, Power BI, TFS/SVN, .Net, BCP, C#

Confidential, Northbridge, California

Data Warehouse/ Business Intelligence/MS SQL Server Developer

Responsibilities:

• Worked with business analysts and Sr. engineers in analyzing business requirements.
• Generated technical documents about database/data warehouse structures and functional specifications.
• Designed and developed SSIS (ETL) packages for loading data from Oracle, Flat and Access files to SQL Server Database.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Understood OLAP processing for changing/maintaining Warehousing, Optimizing Dimensions, and Hierarchies.
• Generating reports, managing inventory and operations, with Microsoft Dynamic
• Applied various transformations like conditional split, look up, fuzzy lookup, fuzzy group, derived column, merge, multicast, sort, union all and so on.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer
• Scheduled jobs to call the packages and Stored Procedures using SQL Server Agent.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed reports out of the consolidated data warehouse for the business users using MS SQL Server Business Intelligence Development Studio.
• Created different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Developed Reports for business end users using Report Builder tool and SSRS Report Manager.
• Utilized Tableau and Qlikview to generate appealing visual reports, including maps, charts, histogram, bubbles, and dashboard.
• Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report and gave roles, user access with respect to security in Report Manager.
• Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.
• Conducted and monitored database management by usingSQLProfiler, Database Engine Tuning Advisor and Index Tuning Wizard.
• Created complex queries such as all kinds of joins (Left join, Right join, Full join, Outer join), CTEs, and sub queries using T-SQL.
• Created Stored Procedures and Triggers for data retrieval used in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Involved in creation of performancepoint dashboards; Published dashboards to SharePoint
• Supported troubleshooting with BI tools, systems, and software; performance-tune these applications as necessary.
• Involved in training the End users on how to use the tool.

Environment: Microsoft SQL server Management Studio 2008R2/2012, MS Business Intelligence tools (SSIS, SSRS, SSAS), SharePoint 2010, Visual Studio 2010, Report Builder, Matlab, PowerPivot, Qlikview, Tableau, Oracle, Flat File, Access

Confidential -Bloomington, Minnesota

Business Intelligence/ETL Specialist

Responsibilities:

• Built Business Intelligence reporting solutions using Microsoft SQL server data tools.
• Applied business intelligence to initialize the reporting system, prepared technical document with business analysts.
• Designed SSIS package to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Generated daily, weekly and monthly reports for the managers and scheduled report execution and delivery, and tracked reporting history using SSRS.
• Generated periodic reports, such as matrix, drill-down reports, pie charts, drill- through reports, parameters, gauge, filter, maps, sub-reports using SSRS.
• Extensively worked on Drill-down, Drill-through, Parameterized reports and Pivot table using SSRS.

Environment: Microsoft SQL server 2008 R2, MS Business Intelligence tools (SSIS, SSRS, SSAS), BCP,T-SQL, Excel, Oracle, ERP tools, Access

Confidential -Charlotte, North Carolina

Business Intelligence/ Data warehouse Developer

Responsibilities:

• Designed ER-Diagrams and mapped the data into database objects and performed normalization of database in OLTP.
• Created database objects like tables, triggers, indexes, views, user defined functions and stored procedure for data migration.
• Applied various data transformations like SCD(slowly changing dimension), conditional Split, derived column, script component, merge, merge join, multicast OLE DB command and data conversion in SSIS.
• Worked as a DBA for creating database objects like Views, Store Procedure, Triggers, Functions, etc. using SQL server to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform data migration from the OLTP system, to SQL server, to OLAP.
• Enabled data viewers, error configurations, SSIS logging, auditing tasks for error handling the SSIS packages.
• Worked on data flow tuning and optimization.
• Designed, deployed and maintained of various SSRS Reports with SQL Server 2008 R2, such as Matrix report, ad hoc, maps, drill through reports and so on
• Create data driven subscription using SSRS.
• Created dynamic SSIS packages with, Variables, Parameters and Expressions.
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.

Environment: Microsoft SQL server 2005/2008R2, MS Business Intelligence tools (SSIS, SSRS, SSAS), T-SQL, Oracle, SAS.

Confidential, Houston, Texas

Business Intelligence Developer /Business Analyst

Responsibilities:

• Used Agile Methodology and participated in Scrum meetings, Developed Business requirement (BRD), Functional requirement (FRD) documents, kept track of changes in BRD, FRD documents.
• Created Stored Procedures, Triggers, Views, Added/Modified tables for data Load Transformation Extraction and Manipulation.
• Filtered bad data using complex T-SQL statements, UDFs and implemented various constraint and triggers for data consistency.
• Supported SQL server administration tasks, including, backups, disaster recovery, database maintenance, user authorizations, database creation.
• Involved in migration of DTS packages to SSIS by using update wizard and package migration wizard.
• Developed ER diagrams for the health science databases.
• Coordinated with front end developer to put in the business rules.
• Wrote Stored Procedure to check some of the rules at the backend at the time of entering data.
• Uses statistical tools to to prepare the Design of Experiments documents.

Environment: Microsoft SQL server 2000/2005, MS Business Intelligence tools (SSIS, SSRS), T-SQL, BCP, Minitab, Matlab, DTS