SUMMARY

• More than 6+ years of experience in Software Analysis, Design, Development, Testing and Implementation of Business Intelligence/Data Warehouse Solutions using Microsoft SQL Server 2012/2008 R2/2008/2005
• Experience in all phases of the Software Development Life Cycle (SDLC).
• Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
• Designed Data Mapping documents, DDL scripts, Data dictionary and Meta data of the models and maintained them. Created Error and Performance reports on SSIS Packages.
• Highly proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Modifying the existing the Dynamic Sql Stored Procedures to point to the EDW environment and applying the data model changes.
• Experience in SSIS\SSRS\SSAS.Wide experience in building static, dynamic and interactive reports using BIDS and Report Builder.
• Experienced with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
• Experienced in migrating data from one SQL Server version to another.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in implementing high availability and disaster recovery technologies such log shipping, mirroring, Replication (snapshot, transactional, merge), Always ON and failover clustering.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
• Designed and coded application components in an agile environment utilizing a test driven development approach, also created and maintained project tasks and schedules.
• Flexible to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, MS Visio, Oracle SQL Developer modeler

ETL Tools: SQL 2012/2008 R2 /2008 Integration Services (SSIS)

Databases: MS SQL Server 2012/2008 R2/2008,MySQL

BI & Reporting Tools: Analysis Services / Reporting Services, Power BI

Operating Systems: windows server 2012/2014,Windows 10/7/Microsoft Vista

Language/Web technology: C#, ASP.Net, HTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Radnor, PA

SQL/BI Developer

Responsibilities:

• Worked with business to gather requirements and create technical documentation for implementation
• Supported both transactional and OLAP applications
• Worked on creating different financial reports for finance and enterprise teams using SSRS and Power BI.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)
• 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 MS SQL Server 2008/2012.
• Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance, used SQL Profiler, and Query Analyzer to debug, troubleshoot, monitor, and measure SQL statements and stored procedures
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Web Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• 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 and various transformations
• Worked on in report writing using SQL Server Reporting Services like Sub-Reports, Drilldown-Reports, Summary Reports, Parameterized Reports Cascading parameter report, Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Experience in making DAX queries in Power BI desktop.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Experience in connecting to different data sources, importing data and transforming data for Business Intelligence.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Experience in implementing row level security on data and worked on security layer models in Power BI.
• Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
• Experience in integrating Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Also, one must be experienced in developing custom visuals for Power BI.

Environment: SQL Server 2014/2016, BIDS, Visual Studio and data tools 2017, Microsoft Azure, SSIS, SSRS, SSAS, Windows Server 2014, Tableau, Power BI, Navision, Oracle, AWS

Confidential, Franklin Lakes, NJ

SSIS, SSRS /Power BI Developer

Responsibilities:

• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created tables, views, stored procedures and indexes in support of various databases and ETL applications.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• 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.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS
• Implemented event handlers, logging and error redirection in SSIS to debug SSIS packages.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Actively involved in gathering system specification requirements for the project.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Used various integrity constraints for data integrity like Referential integrity using primary key and foreign key relationships.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships, aggregation KPIS’s for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Created several reports using SSRS like drill through, drill down, linked, parametrized and sub reports and cubes along with its deployment on reporting server with various security measures
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Assess the risks and recommend/ install service packs or hot fixes when needed.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries or optimized the stored procedures that generate them.

Environment: Microsoft SQL Server 2012,2008R2, SSIS,SSRS, Cognos, SQL Profiler, SharePoint 2010, JIRA,TFS, XML, XSLT, XSD, Microsoft visual Studio 2010,SSAS, Power Pivot, Power View

Confidential, Silver Spring, MD

SQL/ETL Developer

Responsibilities:

• Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and excel.
• Tuned and monitored the performance of T-SQL queries and SSIS packages.
• Implemented SSIS Packages to perform ETL Operations from multiple data sources including excel and text files.
• Was responsible for detecting errors in ETL Operation and rectify them.
• Implemented various types of SSIS Transformations in Packages including Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.
• Actively involved in gathering system specification requirements for the project.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
• Worked in conjunction with the data warehouse architect on the development of logical data models.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Extensively used System as well as User-Defined functions to enhance the functionality of my T-SQL code.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the query execution time.
• Created several reports using SSRS like drill through, drill down, linked, parametrized and sub reports and cubes along with its deployment on reporting server with various security measures
• Written basic VB.Net scripts to implement Type 1 and Type 2 Slowly Changing Dimensions for Incremental load.
• Involved in the design of data marts using star schema and Kimball Methodology.
• Generated and partitioned the cubes and selected appropriate storage modes for the cubes that are used as sources for my reports
• Developed SSRS Reports like drill through, drill down, linked, sub reports and parameterized reports.
• 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 Database Lifecycle Management Products (redgate) like SQL developer suit and SQL source control

Environment: Microsoft SQL Server 2008, SSIS, SSAS, SSRS, Erwin, T-SQL, TFS.