SUMMARY

• Experienced MS BI Developer, specializing in designing, development, implementation and maintenance of Database and BI Applications using MS SQL Server 2012/R2/2008/2005 and MS BI Stack (SSIS, SSAS, and SSRS) and Tableau.
• Over 8 Years of experience in IT as SQL BI Developer, involved in requirement gathering, analysis, configuration, deployment and administration of Enterprise database applications.
• Experienced in all the stages of Software Development Life Cycle and in the migration and up - gradation of databases.
• Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design Best Practices.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Examined and improved the performance of stored procedures and Complex T-SQL queries by using tools like SQL Server Profiler and analyzing the execution plan.
• Responsible for Database consistency checks using DBCC utilities, Performance Tuning and Query Optimization.
• Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Created package configurations to provide an easy solution to migrating packages from different business environments like development to testing or testing to production.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading Parameterized, Conditional, Table, Matrix, Chart, Ad-hoc and Sub Reports.
• Experience in Power BI Tools like Power View, Power Pivot.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management using tableau.
• Design, develop and Optimize datasets for reporting services and SharePoint.
• Trouble Shooting, Performance tuning and resolving issues within Tableau reports and dashboards.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS

DBMS/ RDBMS / MULTIDIMENSIONAL DATABASES: SQL SERVER 2005/2008/2008- R2/2012

DATA MODELING: ER DIAGRAMS/NORMALIZATION / FORWARD AND REVERSE ENGINEERING / DESIGN STRATEGY, ERWIN, MS VISIO

BUSINESS INTELLIGENCE TOOLS/TECHNIQUES: SQL Server Management Studio, T-SQL / OLTP/OLAP SSIS, SSAS, SSRS, BIDS/SSDT, SharePoint, Tableau

PROGRAMMING LANGUAGES: T-SQL, ASP.Net, Java

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

BI/ Tableau Developer

Responsibilities:

• Involved in JAD sessions with Project Managers, Developers, Design Architects, and Design Modelers to solve deadlocks in the projects and to discuss the feasibility of a new idea being incorporated as a module.
• Transform the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
• Designing standards for database table, Column, Procedures and Views.
• Dramatically Increased Query Performance and enhanced response time for statistical reporting by more than 35% after Monitoring, Tuning and optimizing Indexes using Performance Monitor, SQL Profiler and Index tuning wizards (DTA).
• Written dynamic SQL batches to perform the bulk operation in OLTP environment.
• Designed Mappings between Sources to Operational Staging Targets, Using Star Schema, and designed logic for incremental load using slow changing dimension and Check sum.
• Designed SSIS Packages to transfer data between servers, load data into databases and archive data files from various heterogeneous sources like SQL Server OLTP, Flat Files, Excel and CSV into SQL Server 2012.
• Created SSIS packages to load data into Data Warehouse using various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Used SSIS to implement the Slowly Changing the Master Package has to be scheduled which will in turn fire the other packages.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Implemented Master/Child Packages so only gathered requirements and coordinated with the business to assure satisfactory data content, quality, data integrity and receipt of desired information.
• Created charts (Pie, Column, line, Histogram, dual axis charts) and dashboard using Tableau. Monitored the performance of the reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently using tableau.
• Generated context filters and data source filters while handling huge volume of data using tableau.
• Built dashboards for measures with forecast, trend line and reference lines using tableau.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis using tableau.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Involved in Report generation using SSRS and Excel services, Power BI and deployed them on SharePoint Server.
• Used Power View and created various analytical reports andDashboards tohelp managers to identify critical KPIs and facilitate strategic planning in the organization.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Generated different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.

Environment: Microsoft SQL Server 2012, SSIS, SSAS, SSRS, SSDT, Erwin, T-SQL, Tableau, SharePoint, Power Pivot, Power View, TFS.

Confidential, Philadelphia, PA

SSRS/ Tableau Developer

Responsibilities:

• Conducted JAD sessions with different Auditors, Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.
• Used ER-Win tool for dimensional modeling (Star schema). Forward Engineered Data Model of Staging Database to SQL 2008R2 Server.
• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Wrote complex stored procedures for Data Profiling, Backup the databases as well as handling the index fragmentation.
• Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.
• Created database objects like Stored Procedures, UDFs, Triggers, Indexes and Views using TSQL in both OLTP and Relational data warehouse in support of ETL.
• Used proper indexing strategies including covering indexes, indexed views and index defragmentation.
• Created views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.
• Designed Mappings between Sources to Operational Staging Targets, Using Star Schema, and Implemented logic for incremental load using slow changing dimension and Check sum.
• Developed SSIS packages to extract, transform and load data from multiple input sources like flat files, excel with multiple sheets, Production SQL Servers into SQL Server 2008R2 Staging Database.
• Deployed various types of SSIS Transforms in packages including slowly changing dimension, aggregate, fuzzy lookup, conditional split, row count, derived column, script component, etc. and handled erroneous output using event handlers.
• Created Stored Procedures for Reporting on Audit Information and Error Information during each ETL Process.
• Implemented the Master Child Package Model for easier maintenance and better performance of the ETL strategy. Used C# in Script Task and Script Component in SSIS for Data Extraction and transformation.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Built dashboards for measures with forecast, trend line and reference lines using tableau.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (8.x) reports.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.
• Rendered data from a report to several file formats likes PDF, Image and Excel according to the needs of management.
• Deployed different type of report on Share Point 2010 and used dashboard.
• Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.
• Restore databases in case of failure or whenever required by applying full database backup, differential and transactional log backup as required.

Environment: Microsoft SQL Server 2008R2, BIDS, SSIS, SSRS, T-SQL, SharePoint, tableau, C#.Net Applications, SQL Profiler, Database Tuning Advisor, TFS

Confidential, Georgia, NA

ETL/Tableau Report Developer

Responsibilities:

• Used Agile, Scrum methodology in the SDLC for the implementation of the project.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created database documentation for table and column dictionaries and other reference materials
• Wrote T-SQL queries, stored procedures, UDFs and optimized their performance in support windows, web and front end applications.
• Involved in the design of data marts using star schema and Kimball Methodology.
• Interacted with the business users for ETL application enhancements by conducting JAD sessions as well as User Acceptance Testing to sample BI applications
• Involved in creating Source-to-Target mapping documents that provide details on transferring data from the Logical Data Model to the Physical Data Model
• Used Oracle OLTP databases as one of the main sources for ETL processing.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS in staging database from MS Access and excel.
• Implemented SSIS Packages to perform ETL Operations from multiple data sources including excel and text files.
• Implemented various types of SSIS Transformations in Packages including Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.
• Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
• Involved in Full and daily Incremental loads into Staging and ODS areas, troubleshooting process issues and errors using SQL Server Integration Services (SSIS) 2008 R2.
• Involved in debugging of packages with help of Breakpoints, Event Handlers and Loggings.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs
• Representing data using the Cross Tabs, Scatter Plots, Geographic Maps, Pie Charts and Bar Charts, Heat Maps, Tree Maps in Tableau.
• Created delivery extensions as per the recipient’s requirement and deliver the reports using SSRS subscriptions.
• Improved the performance of reports by optimizing data sets, enabling report caching and snapshots.
• Deployed and managed the SSRS reports to Report and SharePoint Server for the end users and involved in enhancements and modifications.

Environment: MS SQL Server 2008R2, SQL, SSIS, SSRS, BIDS, Flat Files, Oracle, Tableau, TFS, DTA, SQL Profiler

Confidential, New York, NY

BI/Report Developer

Responsibilities:

• Actively involved in gathering system specification requirements for the project.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Extensively used System as well as User-Defined functions to enhance the functionality of T-SQL code.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Performed data extractions from multiple heterogeneous sources like Oracle, Excel files for ETL processes
• Designed and developed database objects such as Tables, Triggers, and Indexes using T-SQL
• Optimized complex queries and stored procedures using SQL Profiler
• Produced valuable documentation throughout the project assignment to facilitate easy take-overs and for future reference
• Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from various heterogeneous sources such as SQL Server, Excel, and CSV etc. on to SQL server.
• Created complex SSIS packages (master-child) with properties like package configurations, SSIS loggings as well as custom loggings (using event handlers).
• Involved in the creation of several cube objects like KPI’s, perspectives, and calculated members that were eventually used in the BI application for reporting purpose.
• Generated and partitioned the cubes and selected appropriate storage modes for the cubes that are used as sources for my reports
• Generated reports using relational databases, relational data warehouse, and OLAP cubes.
• Created ad-hoc reports, and complex enterprise reports (drill down, and drill through reports, parameterized reports, cascading report) using SQL Server Reporting Services and report manager. Created linked reports using report builder.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Formatted the reports by applying parameters, and assigned parameter defaults and data types and extended reports.
• Involved in report execution based on caching and snapshot and managed delivery of reports by creating standard subscriptions and data-driven subscriptions.
• Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server (TFS).

Environment: Microsoft SQL Server 2008/R2, BIDS, SSIS, SSAS, SSRS, CA Erwin, Windows Server, Excel, DTA, SQL Profiler

Confidential, Los Angeles

SQL Developer

Responsibilities:

• Gathered requirements from the client, Perform Gap Analysis, Facilitate JAD Sessions.
• Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
• Designed standards for database table, Column, Procedures and Views.
• Used Erwin tool extensively and performed the logical and physical data modeling
• Help database architecture to modify physical and logical data model for new add tables.
• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Utilized the Dynamic SQL for user customizable queries to be interacted with SQL Server.
• Responsible for analyzing various dimensions and facts that could be included in Data Warehouse design using best suited Star-Schema and created logical and physical model of DW in design software like ER-Win.
• Analyzed and identified sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
• Testing the Data Completeness by verifying all the data loaded in to the destination with source data.
• Created different kinds of SSRS reports such as Drill Down, Drill Through, cascaded Parameterized, Linked, Ad-Hoc, Sub-Reports for in depth business analysis.
• Deployed reports to the Report server in Native Mode and implemented Report delivery using Subscription in SSRS

Environment: Microsoft SQL Server 2008/2005, BIDS, SSIS, SSRS, SQL Profiler, DTA. Erwin, Windows Server