SUMMARY

• Around 8 years of experience in analyzing, designing, and developing Client/Server, Data Warehousing/ Data Modeling /Business Intelligence (BI) Stack database applications using MS SQL Server 2016/14/12/08/05 , SQL Server Integration, and Reporting & Analysis Services. (SSIS, SSRS & SSAS),Azure Data Factory, Data Lake Store, Data Lake Analytics.
• Extensive Experience in database administration, design, development and business intelligence of cosmos Microsoft SQL Server 2016/2012/2008 R 2/2005/2000.
• In - depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
• Expert in creating SQL Queries, PL/SQL package, Functions, Stored Procedures, Triggers, Cursors, materialized views and customized views .
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Strong Knowledge on creating SSIS packages using control flow tasks like Execute SQL Task, FTP, For Loop, For-each-Loop, Execute Package task, etc. and data flow tasks like Derived column, Slowly Changing Dimension, Look up, Conditional Split, OLEDB command, etc.
• Highly Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV’S
• Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Extensively used Report Wizard, Report Builder and Report Manager for developing and deploying reports in SSRS.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports using SSRS.
• Strong experience in MS SQL Server with SQL Server Integration Services (SSIS)and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’S, OLAP charts and SSRS Reports with PPS.
• Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Trigger, Data Tier.
• Good Knowledge on Micro strategy reports, Development of Metrics, Attributes, Filters and various other Micro strategy components.
• Experience in handling Master Data Management (MDM) services and setting up the Master Data Services (MDS) to integrate and maintain various entities.
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, Oracle 9i/10g/11g, MySql, data warehouse, XML, PL/SQL, DB2

Databases: SQL Server 2014/2012/2008/2005/2000/7.0 , MS Access

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

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data

Data Modeling Tools: Erwin, Visio

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2013/2010/2007/2003

Operating Systems: Windows 2003/XP/Vista/8.0/8.1/10

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Owings Mills, MD

Sr. MSBI/SSIS/SSRS Developer

Responsibilities:

• Gathered end user’s requirements, Developed Logical Model, and implemented requirements using SQL server 2016.
• Created SQL scripts for initial and incremental loads into production of all the tables.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Interacting with Business Analysts and Developers in identifying the requirements, designing and implementing the Database Schema.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Expertise in constructing T-SQL and Oracle PL/SQL Tables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per the business rule.
• Created MDX queries to retrieve data from the cube and to display SSRS reports.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Interacted with various Businesses, Management and IT units and analyzed business & functional requirements.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Involved in gathering, understanding and validating the project specifications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub queries with JOINS to enhance the performance of Databases.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and managed Database(s) on SQL AZURE. Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked in Agile Environment and used JIRA for project management.
• Participated in the meetings between Business Users and Technical team to gather and discuss the business requirements and convert them into technical/functional requirements.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Environment: : SQL Server 2016/2014/2012 , Visual Studio2017, 2015,2013, Framework 4.5, C#.Net, XML, Entity Framework, Microsoft Office, Excel, Word, Windows server 2010, Business intelligence development studio, Tableau 10.4, SQL profiler, MS Visio-SQL, DTS, Data Analyzer.

Confidential, Irving, TX

Sr. MSBI/SSIS/SSRS Developer

Responsibilities:

• Performed fine tuning of stored procedures and SSIS packages.
• Created complex Stored Procedures, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Was involved in the Design of Data Modeling and Implementation of database design.
• Created SSIS Packages to load data from sources like Excel (.xls, .xlsx), Flat Files, .csv files.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards.
• Extensively used DAX functions like SUM, MIN, AVG, COUNTROWS, DISTINCTCOUNT, SWITCH, CALCULATE, CALULATETABLE, ALL, VALUES, SUMMARIZE, ADD COLUMNS, ROW in Power BI and Tabular reports.
• Created and managed database objects such as tables, views, indexes, stored procedures, user defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
• Created Ad-hoc reports with complex T-SQLqueries based on business requirement.
• Wrote complex T-SQL queries and stored procedures for the building reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports.
• Worked on to develop Report Structure with data definition, report layout and report definition language.
• Created various Complex Formula Reports to query the database for business Intelligence.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports.Creating SQL agent jobs after successful development of ETL packages and SQL codes.
• Experienced in creating nested Grouping, sorting columns and writing expressions per the business requirements.
• Distributed reports via SSRS in different formats to users on a weekly, monthly basis.

Environment: Microsoft SQL Server 2016/2014/2012 , SQL Server Integration Services(SSIS), Visual Studio, BIDS, SQL Data tools, Oracle SQL Developer, Power BI, Erwin, Service Now, MS Team Foundation Server(TFS)

Confidential, Cincinnati, OH

MSBI/SSIS/SSRS Developer

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing
• Defined check constraints, rules, indexes and views In T-SQL based on business requirements.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases
• Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL
• Developed Using T- SQL complex Stored Procedures, Triggers, User Defined Functions based on the requirement
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases.
• Monitored time taking queries with Performance Tuning to reduce the execution time
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text file and CSV files
• Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation.
• Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Designed andDeployed different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Responsible for creating and maintaining the documentation for implementation and for future changes.
• Used different transformations (Derived Column, Data Conversion, Condition Split, Lookup transformation, multicast, and script component transformation) under Data Flow Task while pulling and loading data from one source to another source to makes the data clean and consistent.
• Formatted the report layout for the requirement of the end users.
• Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.
• Created Subscriptions for the users to deliver the reports in a timely manner.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Created subscriptions to provide a Daily/Monthly/Quarterly basis reports.
• Strong communication & Management skills with Excellent Role playing capabilities.

Environment: MS SQL Server 2008/2008R2/2014, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Migration Assistant, SQL Server, SQL Server, TFS, Windows XP.

Confidential, Santa Clara, CA

MSBI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Worked with Product Development Team to architect Database Design and strategy.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Generated SSRS Reports using Stored Procedures, direct SQL, MDX, DAX Scripts for the various Drill-through reports, parameterized reports and linked reports using SSRS.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Understanding the OLAP processing for changing and maintaining the data warehouse.
• Designed and optimized dynamic SQL batches to perform bulk operations in the OLTP environment.
• Designed and developed efficient SSIS packages for processing fact and dimension tables.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Monitored performance with SQL Profiler and Windows System Monitor.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Web Services) and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS).
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance.
• Modified T-SQL Stored Procedure, Triggers for validating the integrity.
• Implemented slowly changing dimension transformation to maintain the historical data in data warehouse.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join.
• Created effective User Defined Function, Stored Procedure, Triggers, Transactions to facilitate data consistency and efficient data manipulation.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

Environment: : MS SQL Server 2008/2010/2012 , SQL Server Integration Services (SSIS) 2010, SQL Server Reporting Services (SSRS) 2010, SQL Profiler, Database Engine Tuning Advisor, Tableau 7.0, MS Office, Windows 7.

Confidential

SQL Developer

Responsibilities:

• Gathered requirements and created requirement specification documents for all reports.
• Developed documentation to reflect current design ETL processes.
• Database Design, Optimization of queries and Database, Performance Tuning using Index Wizard, SQL Profiler and Query Analyzer. Installed SQL Server Desktop Database and Standard Database.
• Created Stored Procedures, User Defined Functions, and Triggers to work consistently with the dynamic databases.
• Investigating and fixing the root cause of the problems that are encountered on in production environments on day to day basis.
• Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Developed backup and recovery plans based on OLTP load and server down time.
• Created T-SQL queries used in PIVOT/UPIVOT, CTE.
• Created Linked Servers and send data across multiple Servers.
• Created Functions and Stored Procedures and Views.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.
• Involved in analyzing business requirements and design documents.
• Involved in interacting with business people on daily basis for better understanding and implementation.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)