PROFESSIONAL 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 noledge 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 teh requirements.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using Power BI.
• Ability to gather and understand business requirements and translate into IT solutions wif teh 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

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS), Microsoft Performance Point Server

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Sr.SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Communicating wif business users to deliver reports and other user interfaces dat drive business value and efficiently and effectively leverage teh use of data.
• Interaction wif a variety of internal and external users to develop technical designs and reviews wif teh rest of teh 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 teh 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 teh automated processes for teh activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces & used wif Database Tuning Advisor (DTA) for optimum performance of queries.
• Made changes to teh 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 teh 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 teh reports in SSRS for various levels of users in teh company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2016.
• Generated Reports using Global Variables, Expressions and Functions for teh reports. Identified and worked wif Parameters for parameterized reports in SSRS 2016.
• Having noledge 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 teh 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 teh Data Optimization techniques by reviewing teh database designs and identifying teh areas of improvisation their in implementing partitioning and using Resource Governor to better Share teh resources between teh Multiple application connecting to SQL server
• Actively taken part in Data Modeling for various initial client setups and designing a set prototype for teh Database Structure
• Automated various jobs and effectively taken part in maintaining teh security on teh server.
• Automated teh Monthly and weekly claims and eligibility data processing for various client using SSIS advance functionalities
• Create teh Generic Procs for teh various business requirements to process teh Provider Loading.
• Created teh user defined function for various business needs
• Create teh 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 teh database.
• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh legacy database.
• Converted various SQL statements into stored procedures theirby reducing teh 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 teh 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
• TEMPHas done Extensive Performance Tuning by using advance techniques provided by latest SQL server editions.
• Used Different Performance Counters to setup Perfmon Traces to monitor teh performance of teh production servers and setups alerts based on teh performance.
• Debugging troubleshooting wif database performance and tuning issues.
• Tuning SQL Queries Coordinating wif team members
• On Call 24*7 Production Support

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

Confidential, PA

Sr. SQL SSIS/SSRS Developer

Responsibilities/ Roles:

• Collaborated in gathering system specification requirements for teh project.
• Collaborated in creation/review of functional requirement specifications and supporting documents during data modeling process.
• Created complex stored procedures wif 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 teh 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 teh 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 teh end-to-end ETL process involving teh access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings utilizing SSIS to transform and load teh data from various source systems such as Oracle, Excel and Flat files into teh 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 teh data into teh Data warehouse.
• Identified slowly changing transformation, to maintain historical data in data warehouse.
• Implemented Master/Child packages so only teh master package needs to be scheduled which will in turn trigger teh 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 dat 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 teh reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Generated periodic reports based on teh statistical analysis of teh 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 teh data center migration involving 50+ Server wif total of 100TB+Data
• Worked wif Very Large Databases highest being teh 5TB+ wif thousands of transactions.
• Installed SQL Server 2008 on all teh boxes.
• Effectively Designed teh high availability solutions wif highly mission critical data demanding 24/7 uptime wif 6 node SQL server clusters.
• Came up wif Detailed Migration plan for teh SQL Server covering all teh minor details to major details for teh smooth Data Centre Migration.
• Worked wif different teams to successfully bring teh whole environment up and running, which involves many application and web server including teh Solar Servers and Vertica Servers which represents complete S&P Ratings and Express Feed Environment.
• Optimal Capacity planning for Servers wif teh latest software and maximum possible hardware capability for teh boxes to handle tons of transaction in a highly replicated environment.
• Effectively Designed backup Strategies for teh Servers hosting around 20 to 25TB each wif individual databases ranging from 1TB to 5TB., using native backup compression and lite speed.
• Effectively Designed Maintenance Plans and custom processes to update teh statistics of teh very large tables and index maintenance process.
• Implemented Resource Governor pools to reduce teh blocking process.
• Worked heavily wif transactional replication wif different methods of pushing teh data to subscriber and synchronizing.
• Actively supported huge and very demanding production environment solving day to day issue wif great sense of responsibility.
• Effectively Worked wif 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 teh detail design phase using Rational Rose.
• Implement high availability through database mirroring and Merge Replication.
• Performed Import / Export using DTS
• Propping up teh 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 teh 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 wif 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 teh information from OLTP to Staging and Staging to Enterprise data warehouse at teh 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 teh 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 wif dimensions & facts wif teh use of slowly changing dimension and maintain teh 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 teh analysis cube in SSAS after DW run.
• Designed teh 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.