SUMMARY:

• Over 8 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2015/2017 and 2018 in Production, QA and Development Environments.
• Strong experience with T - SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in upgrading SQL Server 2008/2008 R2/2012/2014 to SQL Server 2016 and data migration among versions.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS) and SSAS (analysis services).
• Expert in Extracting, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005, 2008 R2/2012 Reporting Services (SSRS), SQL Server 2005,2008 R2/2012 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services and SQL Server Integration Services (SSIS) (2005/2008 R2 and 2012).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
• Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Working experience of designing Ad-hoc reports for higher managers using report model, providing them flexibility to create reports using drag and drop functionality.
• Developed Cubes using SQL server Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Experience in working with Database setup, partitions and maintenance.
• Worked on Jira and infra tickets daily which include updating SQL queries/reports.
• Strong knowledge on claim management process, well versed with Medicaid and Medicare services, HL7 message validation, ICD9, Electronic Health Records and Electronic Medical Records.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Experience in managing large data sets on MS Excel 2016.
• Provided application security support for SQL applications with ADO.NET
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Worked with Business Analysts, Web development team, and users on database solutions.
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
• Excellent communication skills, bridging Client Interaction and Team player.
• Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little training.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2016/2014/2012/2008 ), MS Access, MS Excel, Crystal Reports, Business Objects 4.0

Database: MS SQL Server 2016/2014/2012/2008 R2/2008, MS Access, Oracle 9i/8i

TSQL, PL: SQL, C

Web Technologies: HTML, DHTML, XML and CSS

Operating Systems: Windows (10/8/7/Vista/XP), Windows 2015/2012/2008 Server

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE:

Confidential, Austin TX

Senior MSBI Developer / SQL Developer

Responsibilities:

• Identifying the bottleneck for the process which are taking long time.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Worked on Data Consolidation/Migration Project building.
• Performed successful installation and configuration of SQL Server 2017.
• Created Temporary tables with Temporary variables using Transact SQL (T-SQL).
• Created Dim and Fact tables and multidimensional Cubes.
• Created Reports, Dashboards using SSRS, Excel.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Developed User Defined Functions, store procedure. Responsible for error handling in stored procedure, indexes to generate the distinct data based on the type of the customer base, wrote T-SQL queries.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
• Developed highly optimized stored procedures, functions, and database views to implement the business logics and created clustered and non-clustered indexes.
• Worked on analysis of the data and develop plan based on the ETL specifications.
• Designed and Implemented plan for the moving data to various destinations.
• Created mappings and worcrkflows as per the business requirement.
• Fine-tuned queries to make the reports run faster, worked on query run time analytics.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Experience in creating time dimensions within SSAS and within SSMS
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.

Environment: SQL Server 2016/2017, Visual studio 2015, SQL Server Integration Services (SSIS), Analysis Services (SSAS), Microsoft Visual studio 2013, Excel, VBA, C#.

Confidential, Clearfield, UT

Sr. SQL BI Developer

Responsibilities:

• Worked on Data Consolidation/Migration Project building.
• Worked on Performance Reports of employees in Power BI which was a pilot technology to the company and have been key in helping them introduce the technology.
• Worked on group atlas travel project which was one of the critical and new domains of AAA.
• Have worked from the scratch of the project and built the application based on all the business rules with direct meetings with the clients.
• Worked on cascaded reports with multiple parameters and cube source.
• Wrote complex T-SQL queries, stored procedures to build specific logics.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Implemented advanced features and tools such as script task, lookup, derived columns, condition split, union all, copy column, data conversion as per the business requirements.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created Dimension tables, Fact tables and designed cubes using SSAS.
• Responsible for implementation of data viewer grids, SSIS Logging, error configurations for error handling the SSIS packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both Development and Production environments.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed and maintained complex canned reports using SQL Server 2013 Reporting Services (SSRS).
• Worked on group atlas travel project which was one of the critical and new domains of AAA. Have worked from the scratch of the project and built the application based on all the business rules with direct meetings with the clients.
• Developed reports using SSRS on statistical data during migration of data.
• Created analysis and design documents for implementing the client specific requirements.
• Prepared all the documentation for all the projects.
• Generated reports in excel files using SSIS for business reviews
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Work with different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports.
• Responsible of processing claims data.
• Worked on scheduling the reports as required using normal and data driven subscriptions.

Environment: SQL Server 2012/2016, Visual studio 2015, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), MDX, ASP.Net, Redgate, MS Office 2010, Performance Point Server 2007, Excel, VBA, C#.

Confidential, Milwaukee, WI

Sr. SQL Server/SSIS Developer

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their business efficiency and troubleshooted various performance issues.
• Designed Contract Retention database using SQL Server 2008 technology
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Worked in Agile Scrum Methodology with daily stand up meetings.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension transformations.
• Developed and implemented SSIS 2008 ETL processes to load data from source files to target table
• Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated and worked with Script Task to perform a custom code.
• Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient.
• Develop Procedure and Function using SQL*Server database to migrate data to Oracle database.
• Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity data
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.
• Created additional ad-hoc reports using MS Access for Operations Director.
• Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.

Environment: SQL Server 2014, Visual studio 2013, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Mart, ETL, C#, IIS, VB.Net, Erwin

Confidential, Milwaukee, WI

Sr. SQL Server/SSIS SSRS Developer

Responsibilities:

• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Actively participated in Investors Data related meetings with users, team lead and technical manager to fully understand the requirements of the system.
• Worked on security master which enriches data from Bloomberg and cleanses the data and run the
• Securities data thru workflow and approval process and replicates the data to various systems in the firm.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different
• Databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL
• Queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Worked on programmatically connecting to all the FTP servers to download the files and load into database on daily basis.
• Experience in downloading files from curl scripts and save them into database using C# loaders.
• Worked on scheduling Email trigger jobs to raise an alert to download the files when an email attachment triggers the mail box.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Involved in design, implementation of SQL Server 2012 in Dev, test and prod environment.
• Imported and created relation between different data sources and between multiple tables using Pivot table.
• Performed DB backup, restore and other data base maintenance work.
• Generated power reports in Excel 2013 for the users to as per user requirements along with BA.
• Extensive experience in Active Batch V9 scheduler. Installed the tool and moved all the scheduled jobs from Prism to Active Batch.
• Scheduled and maintained routine jobs, tasks, and alerts using Active Batch. For instance, an alert would be sent to the entire Investor team, if any mismatch in the pricing entry by the trading.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.
• Created Database objects including Tables, Views, Stored Procedures and User Defined Functions.
• Created Schemas, indexes, Triggers (after and instead of triggers).
• Extensively involved in writing database scripts.
• Worked on HL7 inbound and outbound interfaces. Define data specifications and map out data crosswalks. Understanding of interface messages and triggers such as A01 (Inpatient), A02 (Transfer), A03 (Discharge), A04 (Outpatient), A05 (PreAdmit), A08 (Update), A17, Merge messages, appointments, and other types of HL7 messages; ORM, ORU, DFT, MDM, MFNetc.

Environment: SQL Server 2014, SQL Server Management Studio (SSMS), Microsoft Visual Studio 2013, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), Active Batch v9, ERWIN 8 Data Modeling tool, XML Schema, FTP, BIDS, Visual Studio2010, IIS, VB.Net, Erwin, MS Excel.

Confidential, Newark, NJ

SQL Server Developer

Responsibilities:

• Worked as SQL Server Analyst / ETL Analyst using SQL Server 2008 R2/2012 for this Project.
• Source Controlling using IBM Rational Clear Case.
• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server .
• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Experience in working with Medicare and Medicaid insurance data, Medicare parts A, B, C and D. Insurance pricing, Insurance Claim Adjudication.
• Executed stored procedures using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2005, MS Visio 2007, TortoiseSVN.

Confidential

SQL Server Developer

Responsibilities:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler extract, Transform and Load source data into respective target tables to build the required data marts.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Designed SSAS cube to hold summary data for Target dashboards.
• Developed Cube with Star Schema.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition, MS Access, ETL Packages (SSRS, SSIS), Great Plains, PL/SQL, C#, VB.Net, ASP.NET, .Net 3.5 SP1, SP2 & 3.0, HTML, IIS, Visual Studio 2008 & 2005, Visual Source Safe, T-SQL, Oracle 10G, scripting, VSS, TFS.