SUMMARY

• Microsoft Certified Business Intelligence Developer with 7 years of work experience in developing Business Intelligence applications and enterprise Data Warehouses at various phases of SDLC.
• Have in depth knowledge of design, development and the implementation of applications in the Business Intelligence and Client / Server technologies
• Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
• Good working knowledge in database debugging and tuning using the Query Analyzer, SQL Profiler, and SQL Server Debugger
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.
• Good experience to integrate multiple data sources including but not limited to multiple RDBMS(SQL Server, DB2, Oracle), flat files (csv, excel, and xml)
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
• Well versed with the knowledge of RDBMS, data warehousing me.e. OLTP & OLAP systems.
• Highly experienced with the Full Life Cycle and Methodology for implementing OLAP (Online Analytical Processing) data warehouses (star and snow flake schemas) and business intelligence reporting systems.
• Good knowledge in designing OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing).
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Experience in Normalization and De - normalization
• Thorough understanding of Kimball/Inman strategies, key performance indicators (KPI) Reports, and data mining structures
• Well-organized, goal-oriented, highly motivated TEMPeffective team member with excellent analytical, troubleshooting, and problem solving skills.
• Can quickly adapt into given role and deliver results early

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL 2014,2012,2008R2

ETL: SQL Server Integration Services(SSIS),SQL Server Import/Export wizard

Report Tools: SQL Server Reporting Services (SSRS), Power View, Tableau

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL,C#, Python

Operating System’s: Windows server 2008/2003/XP/Vista, Windows 7/8/10

BI Tools: SQL Server Management Studio (SSMS), Data Tools (previously BIDS)

Office Tools: MS Word, PowerPoint, Excel, Access

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Responsibilities:

• Query tuning based on query execution plans, statistics, and profiling
• Worked on developing tables, indexes, views, creating complex stored procedures, triggers, functions.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Used different type of transformations for cleaning the data from different sources into company format.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, DataMart databases.
• Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
• Involved in building a data-warehouse with Dimensions and Fact Tables based on the Business requirements.
• Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.
• Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modelling, and Snow flake modeling for fact and Dimension tables.
• Experience in creating time dimensions within SSAS and within SSMS

Environment: MS SQL Server 2008R2, Integration Services (SSIS), Analysis Services (SSAS)

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Responsibilities:

• Interacted with users extensively in gathering the requirements and analyzing the needs of the end users
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Create various Stored Procedures to validate the data from the source and update/insert the records into target tables.
• Analyzed the existing application programs and tuned SQL queries using execution plan, query analyzer, SQL Profiler and database engine tuning advisor.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, and created indexes.
• Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and ForEach Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Improved the performance of SSIS packages by implementing parallel execution, removing unnecessary sorting and using optimized queries
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in Integration Services
• Created master and child packages, package configurations and logging.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Subreports
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Rendered reports in different formats to be executed automatically on weekly /monthly basis & managed subscriptions.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.
• Involved in building a data-warehouse with Dimensions and Fact Tables based on the Business requirements.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.
• Developed complex SSAS cubes with fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created aggregations, user defined hierarchy for the cubes and KPIs as well as Calculated members

Environment: MS SQL Server 2008R2/2012, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS)

Confidential, Richardson, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Gathering the requirements, Creation/review of Business, Functional requirement Documents for business systems, experience in database design process and data modeling process.
• Involved in writing various DB objects like user defined functions, views, usage of indexes for accomplishing various tasks.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Implemented complex SQL queries using joins, sub queries and correlated sub queries.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Analyzed Queries and boost the performance necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
• Gathered business requirements, definition and design of data source and data flows.
• Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Used different type of transformations for cleaning the data from different sources into company format.
• Used SSISto create ETL packages to validate, extract, transform and load data to data warehouse databases, DataMart databases.
• Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.
• Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.
• Designed complex packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.
• Designed and implemented trending reports.
• Created Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Developed complex Stored Procedures and views to generate various Drill-down/Drill-through reports.
• Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.
• Created SSRSreports with complex calculation fields.
• Created report snapshots and cache for better performance.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server 2012, Reporting services (SSRS), Integration Services (SSIS)

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Responsibilities:

• Responsible for creating database objects like table, views, stored procedures, and triggers.
• Coordinated with DBA in creating and managing Tables, Indexes, Triggers, DB links and Privileges.
• Created user defined data types and added them to model database for future purpose.
• Establishing referential integrity, data consistency, and indexing and data cleanup procedures to maintain high quality data that can be used for reporting.
• Supported efficient data insertion, manipulation and retrieval using various joins, indexed views, stored procedures and functions.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Implemented data conversion from text file intoSQLserver tables.
• Used SSIS transformation multicast transformation to load data into multiple target tables simultaneously
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• CreatedSSISpackages to capture the incremental changes for the data warehouse.
• DevelopedSSISpackages using foreach loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and executeSQLtask to insert transaction log data into theSQLtable.
• ConfiguredSQLmail agent for sending automatic emails when aSSISpackages is failed or succeed.
• Organized Error and Event Handling by using Precedence Constraints, Break Points, Logging.
• Designed Business Requirements Documents, Functional Specifications by conducting process interviews
• Designed and develop Dashboards and Reports using SSRS.
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports
• Designed reports using table filters, single value parameters, multi value parameters, Dynamic, dependent parameters and cascading parameters.
• Configured and administered report manager, created item level securities, group permissions in SQL Server Reporting Services.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed and developed databases with the best practices of data modeling and data normalization.
• Worked on dimensional data modeling using star and snowflake schemas for fact and dimension tables.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created, Process, Partitioned the cubes using SSAS.
• Worked in teams on software development and best practices for developing BI applications.
• Follow Agile Methodology to keep track of projects and maintaining schedule by conducting daily scrums and bi-weekly sprints

Environment: MS SQL Server 2005/2008R2/2012, Reporting services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS)