SUMMARY:

• Over 8 years of experience in Microsoft Database Technologies that includes experience in Database Design and Development of SQL Server 2000/2005/2012/2014/2016 for Financial, Retail and Healthcare Domains.
• Extensive experience in Database Design, Data Modeling, T - SQL Development, Developing and Implementing ETL Packages using SSIS and Complex Reports using SSRS.
• Experience in writing Efficient T-SQL queries, Sub-queries, Dynamic queries, Stored Procedures, User Defined Functions, Database Triggers and Exception Handlers.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Administering SSIS packages such as Scheduling package execution, backing up and Restoring packages, Monitoring Integration Services Performance and activity, and implementing Security considerations for SSIS Packages.
• Expertise in OLTP/OLAP system study, Good experience building Star schema and Snowflake schema depending on the business data requirements.
• Experience in Deploying and Monitoring Analysis services.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Administering, Managing and Troubleshooting Reporting services.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Expertise in assistance with HIPAA (Health Insurance Portability and Accountability Act) and HEDIS (Healthcare Effectiveness Data and Information Set) to protect patient's privacy expectations under the policies and procedures.
• Extensive knowledge in Tuning SQL queries, T/SQL queries and improving the performance of the Database.
• Experience in implementing different types of Replication models like Snapshot, Merge, Transactional and Peer to Peer.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008/2005, ORACLE, MS Access, DB2.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, 10 BI tools (Report Studio, Analysis Studio, Query Studio,) .

ETLTools: DTS, SQL Server Integration Services (SSIS).

Reporting Tools: SQL Server Reporting services (SSRS), Power BI, Informatica

RDBMS: SQL Server 2005/2008R2/2012, Oracle 11g/10/9i.

Programming: T-SQL, PL/SQL, Dynamic SQL, MDX, C# .NET, XML, Java.

Operating Systems: Windows 7/Vista/XP/2008/2003, Windows 9x, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

SQL/SSIS/SSRS/SSAS Developer

Roles and Responsibilities:

• Among a team of developers that successfully completed a complex data conversion project that was designed to migrate millions of records to a new system (QNXT).
• Responsible for fixing hundreds of critical defects addressed during data conversion.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts.
• Created and modified tables, views and indexes; PL/SQL stored procedures, functions and triggers according to business requirement.
• Executed SQL conversion pre-validation and post-validation scripts to avoid data loss.
• Created business reports by joining multiple tables from multiples database using complex SQL queries.
• Responsible for debugging, troubleshooting, and tuning PL/SQL stored procedures and functions and Complex SQL.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created checkpoints, configuration files in SSIS packages and Deployed SSIS packages with minimal changes using XML configuration file.
• Developed several sales, marketing, finance reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI’s.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Coordination of Control-M development team.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Performed data profiling in the source systems that are required for RML System.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Detailed knowledge of Health Edge's, other transaction system (Facets, QNXT, etc.).
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.
• Experienced in maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, Excel pivot tables).
• Used DAX expressions in MS Power BI Desktop.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.

Environment: Microsoft SQL Server 2016/2014 Enterprise Edition, MS Access, ETL Packages(SSIS), QNXT, SSRS, SQL Server Analysis Services(SSAS), .Net, VB.Net, Visual Studio, Team Foundation Server (TFS), Power BI, T-SQL, Business Objects XIR2, ER Studio 8.0.3.

MS SQL Server Developer/SSIS/SSRS/SSAS

Roles and Responsibilities:

• Created complex Stored Procedures and Functions to support the front-end application.
• Created database triggers to implement business requirements.
• Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using Explain Plan.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Server
• Created SSIS package to load multilevel XML data into SQL SERVER database.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Designed SSIS packages to export and import data from SQL Server to MS Access, text files and Excel files.
• Used SSIS transformation for Data Cleansing to remove unnecessary data.
• Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc.
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports in SSRS.
• Created report models for ad-hoc reports using SSRS 2012.
• Designed and created Report templates, bar graphs, pie charts based on the financial data.
• Generated periodic reports based on the statistical analysis of the data using SSRS 2012.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and also generated reports using Crystal Reports.
• Building BI capabilities in an organization, with specialized capabilities including Business Intelligence(BI).
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports .
• Use business tools to target and select optimal populations for chart review; partnership with Nurse ChartReveiw Coordinator as well as Chart Review Coordinator.
• SME for regulatory rate release notes and summaries - lead on reviewing and applying risk adjustment changes specific to Annual Rate Notices and interim rate bulletins from state and federal regulatory agencies.
• Used to resolve on-going maintenance issues and bug fixes ; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.

Environment: MS SQL Server 2014, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, ETL, Microsoft Visio 2003, MS Visual Studio 2012, Composite Studio 6.1, Oracle 11g, Team Foundation Server (TFS).

Confidential, Dallas, Texas

SQL Server Developer/ DBA, SSRS/ SSIS/ SSAS Developer

Roles and Responsibilities:

• Written stored procedures to populate final database tables from staging tables and clean inaccurate data.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots.
• Created and maintained versions of SQL Scripts for Tables, Indexes, Constraints, and Views etc. for the entire project.
• Performed data transfers using BCP and BULK INSERT utilities.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
• Providing solutions to improve the existing processes and production support for various batch processes and also Created the schedule for newly incorporated batch programs and processes.
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Worked with the Program Architect and Technical Architect in design sessions to develop high-level solutions Architecture for SQL Server Reporting Services solution.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula Writing/editing in reports, Report Administration and performance tuning of reports.
• Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: Windows Server XP/NT2008, SQL SERVER 2012/2008, Microsoft Reporting Services, Toad, T-SQL, Oracle 10g, Visual Source Safe (VSS), WIN NT, Erwin and SQL Server Integration Services.

MS SQL Server Developer/SSIS/SSRS

Roles and Responsibilities:

• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses Column Mapping, Data dictionary and Metadata.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created and formatted the report layout for end users.
• Deployment of the developed reports on to the server for the end users.
• Identified query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, (SSRS) 2008
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Monitored Performance with SQL Profiler, Perfmon and using a monitoring tool called DB Artisan.

Environment: MS SQL Server 2012, SSIS, SSRS, T-SQL, Windows, DB Artisan.

SQL Server/SSIS/SSRS Developer

Roles and Responsibilities:

• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created and formatted the report layout for end users.
• Deployment of the developed reports on to the server for the end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, data types.
• Modified the current stored procedures using Visual Source Safe 6.0 to meet current design.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Worked with Metadata Definitions, Import and Export of Data stage jobs using Data Stage Manager.
• Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
• Created custom stored procedures and function to support various new operations.
• Coordinate with offshore team, provide work guide lines, review and provide feedbacks on the design documents and code.
• Migrated VB 6.0 to VB.NET. As the existing modules functionality are developed using VB 6.0.

Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows, VB.NET, Visual Source Safe (VSS).

SQL Server Developer

Roles and Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Created tables, indexes and constraints and various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Created Temp tables in stored procedure for different applications.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Developed and maintained relational databases.
• Developed Reports to generate daily, monthly, quarterly, yearly reports using Crystal Reports.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Scheduled jobs and alerted using SQL Server Agent.
• Collaborated with end users and other related departments to meet the client's expectations and business requirements. Resolved end user reporting problems through collaboration with IT.
• Maintained the physical database by monitoring performance, integrity, and optimized SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.

Environment: Windows XP, SQL Developer, MS-SQL 2008 R2, MS Access, MS Excel.

Jr. SQL Server Developer

Roles and Responsibilities:

• Installed and configured SQL Server 2005 with latest service packs.
• Writing and debugging T-SQL, stored procedures, views and user defined functions.
• Data migration (import & export - BCP) from text to SQL Server.
• Error handling using Try-Catch Block.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, triggers and maintained referential integrity.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created DTS package to get data from different sources, consolidate and merge into one single source.
• Created variety of reports for business to provide them with critical information about business status.
• Actively involved in Normalization & De-normalization of database.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
• Developed administrative tasks of SQL server of performing daily backups and recovery procedures.
• Prepared daily and weekly status reports and collaborated with other team members.

Environment: SQL Server 2008, MS Access, Query Analyzer, Visual Basic 6.0, SQL Developer edition, MS Project.