SUMMARY:

• Over 8+ years of extensive experience in IT industry as SQL Server database development with Business Intelligence Tools 2017/2016/2014/2012/2008 R2 (SSRS, SSIS, SSAS).
• Experience in Fine Tuning SQL queries and T - SQL and PL\SQL queries & improving the performance of the Database using SQL Profiler.
• Experience in Database Development and Data modeling such as Creation of Tables, Stored Procedures, Views, Functions, Triggers (DDL and DML), indexes, and user defined functions.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like Constraints (Primary key, Foreign Key, Unique, Default).
• Experienced in creating SSIS packages (.dtsx) involving ETL process, extracting data from various sources (flat files, excel files, legacy systems, OLEDB) and loading for data warehousing using SQL server integration services.
• Up gradation of SQL server versions and applying patches and hot fixes.
• Expert in creating Calculated Measures and Dimension Members using Multi-Dimensional Expression (MDX), SSAS, Mathematical Formulas, and User-defined functions.
• Experience in performance tuning in SSIS using row transformations, block and unblock transformations.
• Experienced in creating, migrating, deploying complex SSIS packages with complicated transformations like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc using SQL Server Integration Services (SSIS)
• Excellent report creation skills using Microsoft SQL Server Reporting Services (SSRS).
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members using Microsoft Analysis Services (SSAS).
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor, SQL profiler, Extended events and handling them by implementing better Query Execution plans.
• Experienced in all agile roles as a former Developer, Technical Lead, Product/ Project /Program manager/Scrum Master, Agile Coach.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Hands on experience in developing QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2012/2008R 2/2008/2005/2000, Oracle 11g/10g/9i Microsoft Access, SharePoint 2013/2010/2007, Oracle SQL Server 9i/10g/11g

Programming Languages: T-SQL, PL/SQL, HTML, DHTML, XML, VB.NET, C#.Net

IDE Tools: Visual Studio .Net 2010/2008/2005 Framework Microsoft .Net Framework 4.0/3.5/3.0

Data Modeling: Erwin, MS Visio 2010/2007/2005

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

Reporting Tools: SQL Server Reporting Services (SSRS) 2008R2\2008\2005, Crystal ReportsBusiness Objects, Cognos.

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence

Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), performance point server 2007.

Configuration Management Tools: JIRA, Team Foundation Server (TFS) 2012/ 2010/2008/2005

Third party tools: Tidal, Avaya, and windows Application server

Operating System: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows NT, Windows XP Professional /Standard

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Sql Developer/SSRS/SSIS

Responsibilities:

• Developed SQL Packages, Procedures and Functions in accordance with Business Requirements for loading data into database tables.
• Created SSIS packages for processing fact and dimension tables with complex transforms and also configured and deployed SSIS packages to import and export data.
• Participated in database logical design to fit new business requirement and implemented new design into SQL Server 2016.
• Worked with the files which contain the corporate actions for each business day for those financial products.
• Understanding the Customer Account Hierarchy with the business team and implementing better strategies for maintenance on back end.
• Gathered Business requirement for the AUM workflow System to support the private Equity side of business. Worked as a lead developer for the automated workflow process using SSIS packages which implemented Business Rules to validate data, integration with Dashboard to track the status of submission, implementation of business approval process via File system process and successful loading of data to Data warehouse.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Created the database structures with all the required tables along with the constraints and referential integrity in development and testing environment.
• Ran the DDL and DML scripts for the creation and alteration of the tables in DEV and TEST environment.
• Wrote complex queries to extract the data from source and used transformation like Insert Update, Database Lookup, Merge Join, Execute SQL Task etc. to perform the ETL task.
• Validated the data mapping and data type from source to destination to ensure the data quality and smooth ETL process.
• Created complex stored procedures for the adhoc reports as well as the weekly and monthly report.
• Generated drill down and drill through reports from data warehouse using SQL Server Reporting Services (SSRS).
• Involved in the database optimization by creating indexes on the fields used on the reports and partitioning the tables for expediting the execution of the queries.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created and maintained database, tables, user logins, views, indexes, and constraints to implement business rules and also created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server and for Application Developers.
• Wrote tech spec document for all the activities involved to complete the process successfully.

Environment: MS SQL Server 2014/2016, Erwin, DB2, Visual Studio 2013/2018, MS SQL Integration Services, MS SQL Reporting Services 2008, MS Excel, Windows Server 2007, MS Excel.

Confidential, Coppell, TX

MSBI Developer/SSRS/SSIS

Responsibilities:

• Analyzing the business requirements and building logical and physical data models.
• Creating high level design of the ETL process.
• Implementing RDBMS concepts and good understanding of database schemas.
• Experience in creating and managing stored procedures, indexes, views, UDF’s, Database Constraints to meet business requirements and policies.
• Involved in improvement of optimized query performance by creating Indexes and implementing SSDS operations.
• Experience in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV, XML file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and Data Mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Designed the packages extensively to implement in multiple environments easily using configuration
• Automated various processes by scheduling the packages using SSMS Scheduler and third party tools.
• Experience in Handling Transactional systems for performing various automated processes.
• Experience in extracting the data from SQL Server and using XML and present it to the end user in XML format.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, CrossTab Reports, Mailing Label Reports and Ad hoc reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Experience in writing Excel macro’s using VBA and delivering Excel reports to the Business analysts.
• Responsible for unit testing, Smoke Testing and creating design documents and uploading it to share point server.
• Excellent verbal and communicational skills include interacting with users for requirement gathering and problem-solving skills.

Environment: MS-SQL Server 2012/ 2008 R2/2008 Enterprise Manager, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, MS Visual Studio 2010\2008, SharePoint Server 2010, MS Visio 2010, MS-Office 2010, XML, Windows Server 2008, TFS 2010 .

Confidential, MI

SQL / MSBI Developer

Responsibilities:

• Involved as a team member for requirement analysis in design phase of the Project.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Experience in handling Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Experience in extracting huge data from SSAS cubes to perform various business operations.
• Experience in working with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Experience in working with different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc.
• Deployed different SSIS packages on development and test environments.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
• Involved in development and deployment of the Cube.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Linked Reports and Ad hoc reports using SSRS.
• Created Reports and integrated reports into ASP.Net Application.
• Scheduled reports to run daily, weekly and monthly based on the requirement Report Manager.
• Defined Report Layouts for formatting the report design as per the need.
• Generated test data and tested new database consistency with existing databases.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Knowledge in integration of SQL code into SAP application.
• Responsible for unit testing, SDET and creating design documents and uploading it to share point server.

Environment: Visual Studio 2010/2008, MS-SQL Server 2008R2/2008 Enterprise Manager, TOAD, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, MS Access, MS Visio 2007, SharePoint Server 2010, XML, MS Excel, C#.Net, Visual source safe, Windows Server 2008,TFS 2008.

Confidential, Houston, TX

SQL Server Developer/DBA

Responsibilities:

• Extensively involved in understanding the requirement provided by the client and analyzing the functional specification and discussing issues with business analysts.
• Working knowledge of various kinds of records (patient records, insurance data, lab records, medical records, Medicare records, Medic Aid records), and implementing rules using HIP AA constrains.
• Worked on writing T-SQL code for complex stored procedures to extract all the claims data based on the diagnosis code, member eligibility for plans.
• Worked on designing stored procedure for extracting the providers associated to NPI, SPI, DEI, TIN data provided by CMS for non-contracted providers as a part of Medicare PQRI program for finance department to generate checks.
• Also created claims detail report as a part of Medicare PQRI program to support any queries received from providers needing further explanation on bonus checks for customer service department.
• Generated Drilldown, Drill trough Cascaded, Ad-hoc reports using SSRS 2008.
• Created reports with Drop Down menus and multi-select variables as parameters which are passed to store d procedure to populate the report accordingly.
• Worked with SSIS for creating ETL jobs in migration of data from one database to other.
• Created different SSIS Packages for performing various automated tasks using controls and components elements of SSIS Package.
• Experience in Scheduling the SSIS packages for automatic process of extract transform and load (ETL).
• Worked on performance issues of the T-SQL queries and stored procedures which were early executing for more than 1 hour.
• Responsible for Unit testing of the reports before moving them for validation by the Business Analysts.
• Responsible for cleansing up database for maintenance work.

Environment: Visual Studio , SQL Server 2008/2005 Enterprise Edition, SharePoint Server, Microsoft Business intelligence development studio(MSBI) SSIS, SSRS, SSAS, Crystal reports 10, Oracle, Share Point Services, VB.net, and Windows Server 2003.