SUMMARY

• Over 8 Years of extensive experience in Microsoft SQL Server and Business Intelligence applications (MSBI, Power BI). Expert in using Microsoft BI studio products like SSIS, SSRS and SSAS.
• Strong working experience in data analysis, design and development of databases for business applications in a data warehouse environments.
• Hands on experience in data Extraction Transformation Loading (ETL) using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Well versed in creating multiple kinds of Power BI reports and dashboards. Experienced in connecting multiple data sources inPower BIto implement working reports.
• In - depth knowledge in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, relational database models, data dictionaries and data integrity.
• Highly proficient in creating OLAP structures from OLTP databases and also well versed in developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experienced in Data Modeling logical modeling, Entity relationship diagram ERD development /normalization and physical database schema design using CA Erwin data modeler.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Expert in creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SSRS based on Relational and OLAP databases.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Efficient in creating, maintaining and scheduling various reports inPower BIlike Tabular Reports.
• Extensively createdPower BIVisualizations and Dashboards as per the requirements.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.
• Ability to gather and understand business requirements and translate into IT solutions with the use of Cognos and SSRS.
• Working experience in OLAP Data warehouse, Model, Design, Implementation and technical management.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Experience in Performance Tuning and Query Optimization.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C, C++

Scripting: HTML, DHTML, JavaScript, Shell Scripting

Databases/ RDMS: MS SQL Server 2005/2008/2012/2014/2016 , Oracle 9i/10g/11g, Sybase, MS Access

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

Reporting Tools: SSRS, SSAS, Power BI (Power Query, Power Pivot, Power View, Power Map), Crystal Reports, Tableau

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Business Objects, XML, Visual Source Safe Visual Studio Team Foundation Server (TFS)

Data Modeling: MS Visio, ERWIN 4.1

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Sr.SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
• Interaction with a variety of internal and external users to develop technical designs and reviews with the rest of the project team as appropriate.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and technical specifications.
• Querying, creating stored procedures, triggers, views, functions and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Implemented Complex Logging in SSIS Packages.
• 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.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Made changes to the existing Power BIDashboard on a regular basis as per requests from Business.
• Converted DTS packages in SQL Server 2008 to SQL Server 2016 using Integration Services (SSIS).
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users.
• Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2016 as assigned.
• Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2016.
• Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2016.
• Having knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.

Environment: MS SQL Server 2016/2008 Visual Studio2012/2010, Windows 7, SSIS, SSRS, Report Builder 3.0, SQL Profiler, SQL Server Agent, Google Analytics, MS Excel, Power Pivot.

Confidential, Richardson, TX

SQL SSIS/SSRS Developer

Responsibilities:

• Successfully suggested and implemented the disaster recovery and High availability solution like Clustering and Mirroring
• Installed SQL Server 2012,2008R2 and 2008 on Production, Development and UAT boxes
• Successfully Implemented the Data Optimization techniques by reviewing the database designs and identifying the areas of improvisation there in implementing partitioning and using Resource Governor to better Share the resources between the Multiple application connecting to SQL server
• Actively taken part in Data Modeling for various initial client setups and designing a set prototype for the Database Structure
• Automated various jobs and effectively taken part in maintaining the security on the server.
• Automated the Monthly and weekly claims and eligibility data processing for various client using SSIS advance functionalities
• Create the Generic Procs for the various business requirements to process the Provider Loading.
• Created the user defined function for various business needs
• Create the Different Reports using SSRS advance technologies
• Created indexed generic views to facilitate easy user interface implementation, security, and triggers on them to facilitate consistent data entry into the database.
• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the legacy database.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Wrote standard & complex SQL Queries to perform data validation and graph validation to make sure test results matched back to expected resultsbased on business requirements.
• Involved in creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• ResolvedDeadlock&BlockingLock Issues by setting Trace Flags like T1204 and T1205
• CreatedLinked Serversbetween SQL Servers and other Heterogeneous environment
• Has done Extensive Performance Tuning by using advance techniques provided by latest SQL server editions.
• Used Different Performance Counters to setup Perfmon Traces to monitor the performance of the production servers and setups alerts based on the performance.
• Debugging troubleshooting with database performance and tuning issues.

Environment: Windows 2008 Advance Server, Windows 2003 Advance Servers, Windows 2000 Server, SQL Server 2008r2,SQL Server 2012.,SAP.

Confidential - Pittsburgh, PA

Sr. SQL SSIS/SSRS Developer

Responsibilities:

• Collaborated in gathering system specification requirements for the project.
• Collaborated in creation/review of functional requirement specifications and supporting documents during data modeling process.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Redesigned indexes to speed up query performance and utilized database engine tuning advisor for further suggestions.
• Created Triggers to enforce user defined integrity as per the business logic.
• Created tables, views, stored procedures, functions, CTEs and indexes in support of various databases and ETL applications.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created staging database to perform various ETL data messaging operations such as data profiling, data cleansing and data verification.
• Designed the end-to-end ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings utilizing SSIS to transform and load the data from various source systems such as Oracle, Excel and Flat files into the SQL 2014 Server target staging database.
• Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Identified slowly changing transformation, to maintain historical data in data warehouse.
• Implemented Master/Child packages so only the master package needs to be scheduled which will in turn trigger the execution of other packages.
• Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
• Configured data source and data source views, dimensions, cubes, measures, partitions, KPIs and MDX Queries utilizing SQL Server Analysis Services.
• Managed very large reports that return a large volume of records and optimized their performance utilizing techniques such as cascading parameters and filters.
• Designed several scorecards and dashboards utilizing Power Pivot and Tableau to display information needs by other departments and upper management.
• Designed and implemented parameterized reports, Drill down reports for Bank Mortgage Loan organization.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2014, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL server Profiler, Microsoft Visual Studio 2012, Power BI, Team Foundation Server(TFS), Tableau, Share Point.

Confidential, Union, NJ

SQL BI Developer

Responsibilities:

• Designed and Architected the data center migration involving 50+ Server with total of 100TB+Data
• Worked with Very Large Databases highest being the 5TB+ with thousands of transactions.
• Installed SQL Server 2008 on all the boxes.
• Effectively Designed the high availability solutions with highly mission critical data demanding 24/7 uptime with 6 node SQL server clusters.
• Came up with Detailed Migration plan for the SQL Server covering all the minor details to major details for the smooth Data Centre Migration.
• Worked with different teams to successfully bring the whole environment up and running, which involves many application and web server including the Solar Servers and Vertica Servers which represents complete S&P Ratings and Express Feed Environment.
• Optimal Capacity planning for Servers with the latest software and maximum possible hardware capability for the boxes to handle tons of transaction in a highly replicated environment.
• Effectively Designed backup Strategies for the Servers hosting around 20 to 25TB each with individual databases ranging from 1TB to 5TB., using native backup compression and lite speed.
• Effectively Designed Maintenance Plans and custom processes to update the statistics of the very large tables and index maintenance process.
• Implemented Resource Governor pools to reduce the blocking process.
• Worked heavily with transactional replication with different methods of pushing the data to subscriber and synchronizing.
• Actively supported huge and very demanding production environment solving day to day issue with great sense of responsibility.
• Effectively Worked with network teams to transfer more than 100TB+ Data across different data center using 100Gbps dedicated pipe between two different data centers.

Environment: - ER Studio 8.0.3, Microsoft SQL 2008/2012/2014 Server, Microsoft SQL Management Studio, Microsoft SQL 2008/2012 Integration Services, Microsoft SQL 2008/2012 Reporting Services, MS SQL Server, Windows 2003/2008, MS Access, Erwin.

Confidential

SQL SSIS/SSRS Developer

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC) and developed use Case diagrams, Object Diagrams, Class Diagrams, and Sequence diagrams to represent the detail design phase using Rational Rose.
• Implement high availability through database mirroring and Merge Replication.
• Performed Import / Export using DTS
• Propping up the new schema changes and additional new features on Development, Staging/QA and Production servers.
• Configured Log Shipping between Primary and Secondary servers.
• Created database, tables, Indexes and views.
• Created linked server between SQL servers.
• Dropped and recreated the indexes on tables for performance improvements.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Developed web based ASP.NET internet applications
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Created Stored Procedures and triggers to perform automated rules, updating to related tables.
• Discussions with Product team for new features.

Environment: Microsoft SQL Server 2008, Windows XP, ASP.NET, Rational Rose.

Confidential

SQL BI Developer

Responsibilities:

• Actively participated in gathering business requirements and system specification from business users and business analyst.
• Used Microsoft SQL server 2008, SQL server management studio and BIDS and participated in designing a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse at the center to do better analysis.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Used complex T-SQL queries for data extraction. Applied various business logic to scrub/clean/validate/ convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, stored procedures and ad-hoc queries.
• Design SSIS package to load data in to DW along with dimensions & facts with the use of slowly changing dimension and maintain the historical data too.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run.
• Designed the usage summary, performance, Audit/Log, Job Status and detailed reports for ETL users in SSRS.
• Created parameterized, drill-down and drill-through for sales module for business users in SSRS 2008.

Environment: MS SQL Server 2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.