PROFESSIONAL SUMMARY:

• 10 years of strong MS SQL Server BI Developer experience in Health Care, Finance, Retail and Insurance domains with expertise in MS SQL Server 2017/2016/ 2014/2012/2008/2005 suite of products like SSIS, SSRS and SSAS.
• Expert in planning, modeling, designing, developing, implementing, administering and maintaining Microsoft SQL Server, Visual Studio 2017,2015,2013,2012,2010 Microsoft Access, Oracle Databases.
• Highly proficient in the use of T - SQL and PL/SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Experience in Microsoft SharePoint, MS Project, MS Visio, ERwin 9.2, Data Modeling, Visual Basic Analysis (VBA), MS Office, ALM for QA testing and Software Development Life Cycle (SDLC).
• Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
• Extracted data using SSIS from OLTP (Tabular) to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Expertise in creatingdatabases, users, tables, triggers, views, stored procedures, functions, Packages, joins and indexes in database.
• Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Expertise in developing and extending MS SQL Server Analysis Services (SSAS) cubes, data mining models, deploying and processing SSAS objects.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS).
• Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger) with Strong understanding of OLAP and OLTP Concepts.
• Have basic knowledge on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

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: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica power center 9x,8x, Visual Studio 2010,2012,2013

Reporting Tools: SQL Server Reporting Services (2005/2008 R2,2012,2014,2016), Tableau, MS Access, MS Excel

Database: MS SQL Server 2014/2012/2008/2005, MS Access, Azure SQL, Oracle 11g,12c

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1Programming: T-SQL, PL/SQL, VB.Net, XML, HTML, C#, C, C++Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5. Unix, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, TriZetto Facet, Citrix, Diagnostic Manager, IBM WebSphere (One Run, CMU ), TWS, Service Now, Ultra Edit, One Note, MS Outlook, SOAP UI.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr. SQL Server Developer

Tools: and Technologies: MS SQL Server 2017,Visual Studio 2017, SQL Server Integration Services (SSIS), Data Warehouse, SQL Azure, Windows 10, MS Office,, C#, Data Modeling, Share Point, ERP, CRM software, Widows server 2012.

Responsibilities:

• Have an understanding of implementing data models, data design, data access and table maintenance; implementing data policies and procedures; developing and administering ETL processes using SSIS and other tools, interface management standards, and monitoring and alerting.
• Collaborate with other IT staff, vendors, partners and other stakeholders to design and develop data movement and electronic data interfaces utilizing best practices and the production of standard design patterns.
• Created Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server Management Studio.
• Worked with mappings to dynamically generate parameter files used by other mappings. Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Monitoredserver performanceusingSQL profiler,dead locks,blockingsand capturinglong running SQL queries,fine-tuningSQL objectsfor better results and efficient processing.
• Scheduled the Workflows to start running at specified date and time repetitively forever.
• Participated in unit testing to validate the data in the flat files that are generated by the ETL Process.
• Data analyticsandengineeringexperience in multipleAzureplatforms such asAzure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc.for sourcestream extraction, cleansing, consumption and publishingacross multiple user bases.
• Created User Defined Functions, Views to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Assist in the development of technology roadmaps to evolve the API estate in conjunction with internal and external solution providers.
• Work with Service Management teams to establish and monitor service level agreements, communication protocols withdatasuppliers anddata quality assurance policies.

Confidential, Wayne, NJ

Sr. SQL Server Developer

Tools: and Technologies: MS SQL Server 2016,Visual Studio 2015, SQL Server Integration Services (SSIS), Data Warehouse, Oracle 11g, PL/SQL, Unix, Windows 10, MS Office, MS Visio,C#, ERwin 9.2 Data Modeling, Share Point, Team Foundation Server (TFS), ERP, CRM software, Widows server 2012.

Responsibilities:

• Created Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server Management Studio and created indexes to the tables that have least updates to improve the query performance.
• Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary.
• Recommend new strategies and architecture to enhance efficiency of data systems. Plan, manage and track database and SQL procedures system changes.
• Designed developed the SSIS packages to extract, transform, load the data into Target.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked with mappings to dynamically generate parameter files used by other mappings. Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Documented the mappings used in ETL processes including the Unit testing and Technical document of the mappings for future .
• Scheduled the Workflows to start running at specified date and time repetitively forever.
• Participated in unit testing to validate the data in the flat files that are generated by the ETL Process.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the Tabular, OLAP and Operational data.
• Used Repository Manager to Import/Export Metadata and promote Incremental changes between the DEV/QA/PRD environments.
• Create the test cases and Test plan for each scenario, perform sanity checks in Dev/SIT and UAT boxes as need basis for Vendor domain.

Confidential, Jersey City, NJ

MSBI Data Warehouse Developer

Tools: and Technologies: MS SQL Server 2014,Visual Studio 2013, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau,SQL Server Analysis Services (SSAS), Data Warehouse, MS Office, MS Visio, ERwin 9.2 Data Modeling, Tibco Spot Fire Dashboard, Red Hat Linux, Putty, Java, Share point, XML, .NET framework, DMReader, Service Now, TriZetto, Citrix, Service Catalog.

Responsibilities:

• Worked with the Claim Search group, this group deals with claims and special investigative units on applications that effect the clients directly along with revenue generation.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors using SQL Server Management Studio. Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Implemented OLAP Cubes, Facts and Dimensions for providing summarized and aggregate views of large sets of data. Designed Cube partitioning and incremental synchronization for Tabular, OLAP, SSAS cubes.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, partitions, facts, dimension tables using MS Analysis Services.
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• UsedSSIS Packagesfor extracting, cleaning, transforming and loading data intodata warehouse.
• Experience in development ofextracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge Joins, Fuzzy Look Ups, Script task and Send Mail task etc.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.

Confidential, Rhode Island

Sr. SQL Server BI Developer

Tools: and Technologies: MS SQL Server 2014/2012,Visual Studio 2013,2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau,Microsoft SharePoint, MS Project, VBA, MS Office, ERwin 9.2 Data Modeling, ALM for QA testing and Software Development Life Cycle (SDLC)

Responsibilities:

• Assisted in Business Analysts to gather technical requirements.
• Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.
• Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Created many complex database code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Work with Service Management teams to establish and monitor service level agreements, communication protocols withdatasuppliers anddata quality assurance policies.
• Providedata qualityadvisory services to clients and to internal stakeholders. Recommend maintenance enhancements to data acquisition processes to improve accuracy of data warehouse data.
• Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.
• Provide technology options and recommendations to solve for business challenges, Strong knowledge of database and system performance monitoring. Ability to share and communicate ideas both written and verbally to staff at various levels within the organization in a clear and concise manner that is relevant to each level.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Have good business analytical and technical knowledge in Healthcare, Benefits and Provider Modules inFACETS.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Support Batch and Online processes involving development, enhancement and support ofT-SQL procedures, views, triggersandquery tuning.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created XMLPackage Configurations,Error Handling usingEvent Handlersfor On Error, On Warning, and On-Task Failed Event Types.

Confidential, Woodcliff, NJ

Data Warehouse Developer

Tools: and Technologies: MS SQL Server 2012, Informatica Power Center 9.1, Oracle 11/10g, SQL Visual studio 2010,SSIS, SSRS, SSAS, TOAD, Big Data, PL/SQL, Unix, Windows XP/7, ALM for QA testing, Microsoft SharePoint, MS Project and MS Office, ERwin 9.2 Data Modeling and Software Development Life Cycle (SDLC)

Responsibilities:

• Ensuring consistency and accuracy of quality data and Assisted in Business Analysts to gather technical requirements.
• Have good business analytical and technical knowledge in Healthcare, Benefits and Provider Modules inFACETS.
• Worked to write and modify Store procedure to implement business logic in facet extension and interface application.
• Used Execution Plan, SQL Profiler to trace the slow running queries and tried to Optimize SQL queries to improve performance and availability.
• Parsing design spec to simple ETL coding and mapping standards. Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Perform Informatica code migrations to different Informatica repositories. Designed and developed Informatica Mappings to load data from Source systems to ODS and then to the Data Warehouse to DataMart by creating the Dimension and Fact Tables.
• Creation of mappings with the transformations like Lookups, Joiner, Rank, Source Qualifier, Aggregate, Expression, Filter, Update Strategy, Normalizer, Router, Union, Sorter, Mapplets etc in the Informatica Designer for populating target table in efficient manner per the business need.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.

Confidential, Richmond, VA

MS SQL Server Developer

Tools: and Technologies: MS SQL Server 2008, SQL Server Reporting Services (SSRS), MS Access, FACETS, MS Excel, SSIS, BCP, T-SQL, Oracle Enterprise edition, Oracle Enterprise edition, Tableau Desktop, Power BI, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, C#.

Responsibilities:

• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server, for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Designed and implemented data access stored procedures and triggers for automating tasks. Perform standard QA-Testing of SSIS Packages.
• Have good business analytical and technical knowledge in Healthcare, Benefits and Provider Modules inFACETS.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the Tabular, OLAP, Operational data. Designed MDX queries to retrieve data from SSAS cubes.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Generated reports for end user requirements using SSRS developed reports on to the server for the end users.
• Experiencein Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery.
• Data migration (import & export - BCP) from Text to SQL server.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Confidential

Database developer

Tools: and Technologies: MS SQL Server 2005,SSIS,SSRS, Oracle 8i, MS Access, MS Excel, T-SQL,PL/SQL.

Responsibilities:

• Participated in documenting the existing operational systems. Involved in the requirements gathering for the warehouse. Presented the requirements and a Design document to the client.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Developed physical data models and created DDL scripts to create database schema and database objects
• Wrote user requirement documents based on functional specification.
• Performance tuning to optimize SQL queries using query analyzer.
• Responsible for the day to day IT requirements of the company such as user management, trouble shooting, help and advice.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Maintaining desktop applications, local area networks, IT security and telecommunications.
• Managing a team of over 30 administrative &technical staff. Responsible for hardware and software installation, maintenance and repair. Performing routine audits of systems and software.
• Developing &maintaining the company IT systems, software and databases. Recommending and implementing improvements and efficiencies.
• Reporting to the IT Director, Chief Executive. Having excellent time management, confidentiality &communication skills. Having strong IT, commercial, planning and budgeting skills. To evaluate, test, advise, train and support I.T. related projects.