SUMMARY

• 10+ yearsin Information Technology with Expertise in Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Exposure in overallSDLCincluding requirementgathering, development, testing, debugging, deployment, documentation, production supportand Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Strong T - SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Experienced in SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Expertise in implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages.
• Experience in implementing Transactions, Logging, Error files to SSIS Packages.
• Worked on performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS).
• Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security.
• Expertise in developing and extending SSAS cubes, Dimensions, Data source views, SSAS- data mining models including deploying and processing of SSAS objects.
• Experience using SQL Server Analysis Services (SSAS) in building OLAP Cubes, defining Referenced Relationships and creating Hierarchies in SSAS
• Created/ Used MDX queries for accessing Cubes and used the data in SSRS reports.
• Used SSAS Cubes for creating reports in SSRS and Customized SSAS cubes according the Clients requirement.
• Experience in deploying created reports in various sources like Share points, Reporting servers.
• Good understanding of Data Warehouse Design aspects like Kimball model, Star-schema, snow flake schema.
• Performed daily tasks including backup and restore usingtools likeSQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experienced in visualization tools like PowerBI
• Created reports using different data sources in PowerBI
• Created interactive dashboards using PowerBI
• Experience in using DAX in PowerBI
• Experience working in Waterfall and Agile development methodologies.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Good experience with partitioned schemas, partitioned tables and indexes, creating File groups using SQL Server 2005/2008/2012.
• Experience in creating maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
• Knowledge on .net framework in various projects.
• Experienced in using C# and VB.NET scripts for various tasks in SSIS.
• Experience with versioning tools like Microsoft Team Foundation Server(TFS),Visual Source Safe (VSS) for version controlling of the Application.
• Excellent business, analytical, user interaction, presentation skills coupled with excellent written, interpersonal and verbal communication skills.

TECHNICAL SKILLS

Languages: Transact SQL, PL/SQL, C, Visual Basic 6.0, VB.Net, C#, .NET ASP.NET, HTML5, CSS3,JavaScript,SOAP

Databases: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MS Access, Oracle 11g

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Tableau 9.0,PowerBI

ETL Tools: DTS, SSIS,Informatica

Data Modeling Tools: Erwin, Visio

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2012 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, MS office,JIRA,TFS

PROFESSIONAL EXPERIENCE

Confidential, East Hanover, NJ

Team Lead (SSIS, SSRS, SSAS)

Responsibilities:

• Designed and developed new SSIS Packages (ETL) for RElinx reporting
• Gathered business requirements and documented the changes for future reference.
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures
• Created ETL packages to validate, extract, transform and load, data from various data warehouses to databases/data marts.
• Implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages.
• Designed DataMart’s for various new Analysis projects using Kimbal methodology.
• Optimizing and troubleshoot T-SQL queries, created functions, Store procedures and triggers according to the business needs.
• Worked for Data Architecture team for maintaining the integrity of the SQL Server Database most of the responsibilities were to monitor database activities and security audit, new Database Backup Scheduling and disaster recovery management.
• Monitoring the scheduled ETL Jobs of multiple internal team and address the failures for continuity.
• Responsible for creating subscriptions using data driven subscriptions on weekly and monthly basis.
• Created various reportsd like parameterized,drillthrough and cascading parameter reports
• Working on new change requests on ssrs reports.
• Prepared weekly status reports
• Logging and addressing problems in the internal ticketing system regarding SQL Database. making team in various meetings with the stack holder and documented the business use cases for future reference.

Environment: MS SQL Server 2016, MSBI, Visual studio, Oracle,PowerBI,VB Script, XML, SQL Profiler, Agile Methodology,Team Foundation Server, JIRA

Confidential, East Hanover, NJ

Team Lead (SSIS, SSRS, SSAS)

Responsibilities:

• Designed various SSIS packages for load the data into Data Warehouse from different sources like flat files, excel documents,LiNX DB.
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures
• Managed Package Configurations in SQL Server along with environment variable configuration to efficiently deploy Unit Tested Packages from Test/Development Environment to Production Environment.
• Designed logical data model for a data Warehouse that accumulates and share the data among various internal team.
• Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables, Error handling during the ETL process and scheduling the SSIS Packages using SQL jobs.
• Created various Tabular, drill down, Cross Tab type Operational level reports for various teams in financial and cyber security teams using SSRS.
• Created datasets using stored procedures and reports using multi value parameters
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created Various Executive level management reports using SSRS, Power View Information Risk Management team.
• Configured master data service manager in sql server 2012 as per clients requirement.
• Created and managed schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
• Optimized the performance of various SQL stored procedures using SQL profiler to improve the latency of reports pushed daily to management.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Designed and implemented dimensional Star-Schema Data Marts (Ralph Kimball methodology).
• Maintained various databases and Documented Data recovery senarios for future purpose.
• Coordinated with off-shore team for sharing the support responsibilities on scheduled SSIS packages.
• Creating Cube and deploying the cube
• Granting permissions to the users to the ssas cubes
• Processing the SSAS cubes once data load is completed.
• Working on the enhancements and automation of the process.
• Creates excel reports using PowerBI to connect Ssas cubes datasource and display data

Environment: MS SQL Server 2012/2014, SSAS, SSIS, SSRS, Oracle,Visual studio 2010,Sharepoint 2012,, C#, XML, SQL Profiler, ERWIN, Agile Methodology, Team Foundation Server

Confidential, CA

MSBI Developer

Responsibilities:

• Involved in gathering Requirements from the Business and worked as a part of Data Modeling Process.
• Continues Interaction with the business for the Data delivery and Data quality.
• Performed ETL (SSIS) from various data sources like Data warehouse, Oracle, Excel, CSV, Text files and various client servers.
• Created adhoc reports to users in SSRS by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Monitored space usage, and adjust database as needed.
• Monitored/created backup operations, and schedules manual backups as needed.
• Developed various Stored Procedures and implemented different business logics, Filters to pull required data from sources.
• Rebuilding indexes for the migrated tables and improved the table retrieving process by performance tuning.
• Designed SSIS packages for implementing CDC and SCD in the various internal projects.
• Maintain SQL Server Login administration, Backups and recovery plans.
• Develop/Deploy SSIS packages in SQL Server 2008/R2.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Maintained Database performance/tuning by using various optimizing tools such as Performance Monitor, SQL Profiler and Other Red Gate Tools.
• Performed various deployments and releases using REDGATE tools.
• Immensely worked on Stored Procedures, Functions, Index’s and monitoring the Performance of all the Databases.
• Established and enforced all database standards.
• Work with OPS to resolve production issues.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in system analysis, design, development, testing and implementation of projects using Software Development Life Cycle (SDLC).
• Created SSAS Multidimensional Cubes for analysis.
• Every third to fourth week, be on-call and support any database related issue (24x7).

Environment: MS SQL Server 2008/R2,Visual studio, C#, XML,HTML,CSS,Javacript, SQL Profiler, ERWIN, Version One, Agile Methodology.

Confidential, Redmond,Washington

BI Developer

Responsibilities:

• Developed various T-SQL queries, Stored Procedures for data retrieval, maintenance and testing.
• Developed various SSIS packages for managing current and historical data using various transformations.
• Developed complex SSRS reports involving Sub Reports.
• Design and implemented a Customer relationship management database (CRM).
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Automated the Batch Processing and Version Validation.
• Involved in migrating ssis packages from .
• Coordinated with platform hosting vendor(s) DBAs to ensure proper support maintenance, and tuning of various databases.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Monitored space usage, and adjust database as needed.
• Monitored backup operations, and schedules manual backups as needed.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data Sources like Excel Spreadsheets, Flat File etc. and vice versa.
• Used various control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task etc. and different data flow tasks.
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T-SQL and Visual Basic (VB) scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints Integral part of the Warehouse team for the Design, Development and functioning of cube.
• Developed the performance of the server and creating new reporting jobs according the clients need.
• Used reverse engineering technique to gain knowledge on the existing data ware model.
• Developed MDX queries to extract data from Cubes to create reports.
• Worked in Production environment and resolved the tickets in time to deliver the requirements.
• Directed resource/capacity planning for systems/databases by monitoring databases, checkpoints, and back-ups.

Environment: MS SQL Server 2008R2/DENALI, SSIS, SSAS, MDS, EXCEL, Visual Studio, TFS.

Confidential, New York

BI Developer

Responsibilities:

• Developed various reports like drilldown,subreports and tabular reports.
• Created stored procedures to fetch data, insert data and update data in database.
• Analysis and redesign whole system for performance improvement and for enhancing the existing features.
• Implementing various change requests.
• Responsible for creating subscriptions using data driven subscriptions on weekly and monthly basis.
• Created various reportsd like parameterized,drillthrough and cascading parameter reports
• Working on change requests on ssrs reports.

Environment: MS SQL Server 2008/R2,Visual studio, C#, XML,HTML,CSS,Javascript, SQL Profiler, ERWIN, Version One, Agile Methodology.

Confidential

BI Developer

Responsibilities:

• Developed various reports like drilldown,subreports and tabular reports.
• Implemented UI design using HTML,Javascript and css
• Created stored procedures to fetch data, insert data and update data in database.
• Analysis and redesign whole system for performance improvement and for enhancing the existing features.
• Implementing various change requests.
• Created webservices using SOAP protocol

Environment: MS SQL Server 2008,Visual studio, C#, XML, SQL Profiler, ERWIN, Javascript,HTML and CSS