SUMMARY:

• Over 8 years of experience in MSBI tools SSIS, SSRS, and SSAS and Database design, development and administration using My SQL Server 2016, 2014, 2012 and 2008 in Production, Test, Development environment
• 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
• Experience in creating interfaces using SSIS in MS SQL Server and its different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Configuration Manager, writing FUNCTIONS, TRIGGERS, CURSORS
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Experience in creating complex SSIS packages using appropriate control and data flow elements with SSIS Standards
• Good experience in developing various types of complex reports like reports using cascade parameters, drill down and drill through reports, matrix reports, sub reports, parameterized reports, Ad - Hoc and charts using SQL Server Reporting Services (SSRS) based on requirements
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging, Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations, OLEBD Command
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data
• Expert in generating Parameterized reports, Linked reports, Sub reports and filters, charts in SSRS 2008/2012
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Involved in the full development lifecycle from requirements gathering through development and supportusing Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes
• Tableau Server Management like Clustering, Load Balancing, User Management
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support
• A well-organized, goal-oriented, highly-motivated effective member/team leader with excellent analytical, troubleshooting, and problem solving skills
• Ability to handle multiple tasks, initiative and adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals
• Good ability to quickly grasp and master new concepts and technologies
• Extensive knowledge of Object Oriented Analysis and Design (OOAD)
• Worked on data sources such as Hive
• Working with DBA for creating HIVE tables
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player

TECHNICAL SKILLS:

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services, Power BI, SAP BI, HANA

Database: MS SQL Server 2014/2012/2008 R2/2005/ 2000, MS Access 2000, MySQL

ETL Tools: DTS, SSIS

ReportingTools: SQL Server Reporting Services (SSRS), SSAS, Tableau

Operating: Windows, Linux, IOS, Unix

MS Office Suite: Word, Power point, Outlook, Access

SQL, T: SQL, PL(SQL), ASP.Net, C#, Python

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. SQL / ETL/SSIS Developer

Responsibilities:

• Design tables and views structure for the application. Define DDL and accordingly build the table structure. Upload the table into related databases and upload it in respective project in GIT.
• Creating views, stored procedures, appropriate functions, to facilitate efficient data manipulation and data consistency.
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data modeling.
• Writing procedures and functions using dynamic SQL and wrote SQL queries using joins, sub queries and correlated sub queries. Writing new stored procedures and tune them so that they perform well.
• As data architect, Designed short term resolutions to achieve all goals and prepare data roadmap for management.
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Effectively worked on Data migration. Built command files for data migration, files to generate view and do bulk insert and bcp out, migrate data from legacy to the target databases.
• Rebuilding the indexes at regular intervals for better performance.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Refactoring Stored procedures and user defined functions for building online and offline reports using SSRS.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Developing Power Shell scripts to automate table creation, execute procedures.
• Perform SQL Server service pack and schedule SQL Agent Jobs.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Determined procedures to identify and collect all required data, validate process and recommend improvements to corporate data.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Developed Tableau workbooks from multiple data sources using Data Blending
• Interacted with the existing database developers and DBA to understand the existing schema
• Design and developed data visualizations (reports & dashboards) in tableauto support customer requirements
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Configured Oracle Golden Gate Software that is used for replication - Extracts, Replicates, Definition files, Macro files, Parameter files for each environment and Merge SP’s for each database.
• Setting up Service Broker Components - Messages, Queues, Services, Contracts, SP’s, Triggers.
• Coordinated with the management to discuss business needs and designed database solutions accordingly.
• Consistently met deadlines for database creation and implementation projects while working with software development and client service teams for further improving the product.

Environment: SQL Server 2016, 2014, 2012, Windows 2000 Server, Data Modeling, Data Architecture, Visual studio 2017, Visual Studio 2013 (For Reports), Oracle GGS, Service Broker, Tableau, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), Share Point, MS Access and Windows 2012 Server

Confidential, Redmond, WA

Sr SQL/ BI Developer

Responsibilities:

• Assemble and convert user requirements into standard reporting solution and customize specific user requests when necessary
• Provides consulting support for Business partners by researching, identifying and resolving complex technical problems
• Write, maintain and update technical documentation
• Designed and deployed various different professional reports with SSRS tools, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Set up Advanced functions, dashboard, Drill-Trough/Drill-Down, KPI/Indicators in reports
• Generated various reports with drill-downs, calculated members, drop-downs from the cubes by connecting to Analysis server from SSRS
• Created mappings using Informatica power center from various source to multiple targets
• Develop and implement extracting the data from multiple sources, transforming as per the technical specifications using Informatica to load data warehouse and data marts
• Configure report server and deploy reports on web server
• Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements
• Manage and maintain stored procedures and standard reports. Build reports from Analysis Services cube using MDX query designer
• Develop SQL queries, stored procedures, and functions. Investigate and optimize reporting system performance by optimizing queries, and using report cache and snapshot
• Involved in Creation, Development and Deployment of SSIS packages to import sales data into SQL database from various data sources such as Oracle and flat text files
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security
• Worked on Tableau migration and scheduling
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server
• Developed application using OOAD and 3-Tier architecture
• Design data model for historical database using Hive
• Importing and exporting data into HDFS and Hive

Environment: MS SQL Server2005/ 2008, SQL Server Intégration Services (SSIS), SQL Server Reporting Services (SSRS), Share Point, Visual Safe Source, VB Script, FTP, SFTP, MS Access and Windows 2008 Server, Tableau

Confidential, Denver, CO

MS SQL Developer / BI Developer (SSMS/SSIS/SSRS/SSAS)

Responsibilities:

• Created Database Tables, Views, and Functions and developed procedures for implementing application functionality at the database side for performance improvement
• Wrote complex SQL queries using all kinds of joins, sub queries to retrieve data from the database
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Extensively worked on error handling at different levels of SSIS packages like control flow level and data flow level.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all.
• Deployed the created SSIS packages in Development and Testing environments
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Involved in Installation, configuration and setting of Database servers for various test and development environments including SSRS Installation configuration and administration
• Used Rally - Agile development software to report bugs and to track the status of User Stories and participated in Scrum calls every day
• Interacted with end users and customers and act as functional analyst /development member with various cross functional teams
• Gather requirements and design of data warehouse and data mart entities
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables

Environment: MS SQL Server 2008/2012, Confidential Visual Studio 2010, SSIS, SSRS, SSMS, MS Excel, T-SQL.

Confidential, Billerica, MA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Worked on different levels of ETL Loads like Extract Data from Source System into data warehouse.
• Used FTP control flow task to access data on the FTP server and moved data into new folders in the client file system.
• Used Data profiling task to check the validity of text files, loaded them into staging database, applied data constraints and then finally loaded in to production.
• Successfully deployed SSIS package into production environment using package configurations to export various package properties which indeed make the package environment independent
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, text, CSV files.
• Created data source views from SQL Server data sources.
• Created aggregations based on year to improve the query performance and optimizing the storage
• 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
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles

Environment: MS SQL Server 2008/2012, SSIS/SSRS 2008/2012, T-SQL, Visual Studio 2008/2010, .NET Framework, SQL Server Profiler, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).

Confidential, Baltimore, MD

SQL Server Developer

Responsibilities:

• Worked on creating Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency
• Written SQL Scripts to do the Data Profiling like clarify the structure, content, relationships and derivation rules of the data
• Designed partitioning strategies and storage modes for optimal performance in SSIS and SSAS
• Written integrated Stored Procedures to generate the Reports
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation
• Various clustered/non-clustered indexes, triggers, check constraints and functions
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS
• Created SSIS package to get data from different sources, consolidate and merge into one single source
• Worked on SQL Server Reporting Services to generate different types of reports for various subsystems
• Created many ad-hoc reports using SSRS for business users as per requirement
• Developed various drill down and drill through reports which involved complex chart based reports
• Scheduled Jobs to call SSIS packages and Stored Procedures using SQL Agent
• Worked on writing the stored procedures to create the balance reports
• Migrated existing DTS packages to SSIS Packages using SQL Server Integration Services (SSIS)

Environment: SQL Server 2008/2005/2000, MySQL, Visual Studio, MS Access, MS Excel, MS office 2007, T-SQL, PL/SQL, MDX.