PROFESSIONAL SUMMARY:

• Over8+years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2012/2008 with various business domains like Financial, Banking, and Insurance Sector
• Experience in MS SQL Server 2016/2012/2008 with Business Intelligence in SQL Server Reporting Service and SQL Server Integration Service
• Experience in designing Logical and Physical Modeling using ERWIN Tool and ER Studio.
• Experience in High Level Design of ETL - DTS Packages&SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Involved in migration of reports from SQL 2000 to SQL 2012/2016 and migration with DTS to SSIS.
• Proficient in OLTP, OLAP and Data warehousing Design concepts
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 12C/11g/10g/9i/8x, SQL Server 2016/2, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL
• Experience in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2016/2012/2008
• Experience in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS
• Responsiblefor taking information from all new clientsand starting new client files.
• Assisted in doing monthly HIPPA audits for clientsand presenting theresults to theclientsand company management
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2008/2012/2016 Analysis Services Business Intelligence (SSAS, SSRS).
• Experience in advanced reporting skills using SQL Server reporting services (SSRS).
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
• Experienced in developing Win Forms using C#, web-based applications.
• Expertise in N-tier architectures, Object oriented programming (OOP) especially C#, PHP, Java, java script and Model View Controller (MVC) frameworks for developing the web applications.
• Experience in PowerShell for DevOps in Windows-based systems.
• Expertise in Integration and automation of source control applications like GIT. Experience of build technologies like Jenkins, GIT, NuGet, TFS.
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes
• Experience in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, Also created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS:

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

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica Power Center 9.1/8.6/8.5/8.1/7.1

Reporting Tools: SQL Server Reporting Services ( 2016/2012/2008 ),OFM(Oil Field Management)

Database: MS SQL Server 2016/2, MS Access, Oracle 11g/10g/9i/8i, MySQL, PostgreSql,EFT File Server,HIPPA.

TSQL, PL: SQL, C, LINUX(Shell Scripting)

Web Technologies: HTML, DHTML

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Adobe Photoshop, Abode Flash, Mac Office Suite, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

MS SQL Server Developer/SSAS/SSIS/ETL/OFM

Responsibilities:

• Involved in Planning, Designing and implementation of data warehouse requirements and Objects.
• Collaborate with and department leaders to design, build, andpackages using SQL Server, SSIS
• Performed source/target analysis of data structures & content.
• Re engineering the existing SQL server SSIS Packages
• Created new Data warehouse objects and loading historical data.
• Implemented Data Scrubbing operations and improve data quality and system stability.
• Created processes that will validate data accuracy and consistency
• Used different SSIS transformations such as Conditional Split, Derived Column, Data Conversion, Join, CDC, SCD and expressions for Case statements were used for Data Scrubbing, before loading the data into the Data warehouse.
• Script component implemented to extract xml data from files stored in the tables.
• C# is used to developed command line tool (Customized BCP) for validation of various types of(Fixed width, csv, tab delimited) input files and filter the data and write into specified tables.
• Developed package to get data from different sources consolidate and merge into one single source.
• Working with OFM(Oil Field manager). Monitor and survey performance with advanced production views.
• Forecast production with powerful decline and type curve analysis.
• Analyze any asset and share results using standards.
• View, relate, and analyze reservoir and production data with comprehensive tools, including interactive base maps with production trends, bubble plots, and diagnostic plots.
• Production volumes, operations data, and field event history (via the Avocet production operations software platform)
• Project economic evaluations and forecasts (via the OFM software plug-in for Peep petroleum economic evaluation and decline analysis)
• Use a library of off-the-shelf workflow templates to guide analyses from shale production to water flooding.
• Exercising Software development experience in reporting development status and presenting innovative ideas to the management during Project Design meetings.
• Analyzing various system requirements, data flow charts, design and development of various modules of web applications.
• Created package configuration using environment variables.
• Good knowledge of relational database management systems and Data Modeling
• Modified existing stored procedures. Writing complex T-SQL queries.
• Proficiency in SQL including Joins, Alters, Sub queries, Pivots, Loops, Cases, and data transformation functions.
• Strong Performance tuning skills of SSIS packages and SQL queries
• Analysis of root cause for data issues
• Testing every created and modified database objects thoroughly.
• Worked in Agile SDLC process, attending Sprint scoping calls, daily standup meetings
• Self-motivated and having good communication skills.

Environment: SQL Server 2012, 2016, Azure Devops, T-SQL, MS Excel, Visual Studio2015,2017, VB.net, C#, MS SSIS, SQL Server Report Builder 2016,TFS, VSTS, Agile, OFM

Confidential

Data Visualization Specialist, Boise, ID

Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
• Developed different types of tabular reports, matrix reports, charts and graphs reports that aggregate data using SQL Server Reporting Services.
• Responsible for setting up subscriptions of the reports via SQL Reports Distribution (SQL-RD)
• Embedded the reports on to application using MS Report Viewer in Visual Studio 2010.
• SQL query optimization in SSRS by designing required indexes partitions after analysis using SQL profiler and examining execution plans in SQL server Management studio.
• Planned the complete backup (with suitable recovery model) of various Databases.
• Created Clustered and Non- Clustered Indexes on tables for performance optimization of complex stored procedures.
• Implemented MVC4 architecture using C# .NET, VB.Net, HTML 5 and Razor view engine for Capital Credit Module.
• Developed custom controls, user controls and ASPX pages in C#.Net for client side credit display.
• Implemented Microsoft enterprise library and Error handling mechanism.
• Developed Web Application Security Model using Windows authentication model as well as Forms authentication, configured Web.Config files using ASP.Net, Web API server.
• Involved in maintenance and enhancements of an application using Microsoft .NET Framework 3.5, VB.Net, ASP.NET, LINQ, WCF, AJAX, JavaScript, jQuery, XML, WPF, WEB SERVICES.
• Developed web applications using MVC with AngularJS, Java Spring, Node, Go, .NET Core, Angular, REST, microservices, AWS/Cloud infrastructure.
• Implemented an SQL injection attack on a website via the URL to find vulnerabilities in the website.
• Used Sqlmap as a penetration testing testing tool and modify database.
• Responsible for the implementation and documentation in a group of 3.
• Wrote database triggers for automatic updating, auditing, of the tables.
• Deployed SSIS packages across development, test and production environments using project deployment model
• Improved the performance of the slow running queries by using performance tuning.
• Created SSIS Packages by using different kinds of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).
• Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs. Also to trigger emails about the failure using Email task.
• Worked in creating stored procedures, views, materialized Views.
• Used task factory components and transformation like Update batch transformation, Null Handler Transformation, Surrogate Key Transformation, Advanced Email and SMS Task in SSIS packages
• Experience in managing and automating Control flow, Data flow and Events using Microsoft .NET framework for SSIS packages.
• Developed report specifications, created and modified reports using Tableau
• Worked in creating Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
• Experienced in agile environments
• Trained teammates in using JIRA/Confluence.
• Experienced customizing JIRA projects with various schemas, complex workflows, screen schemes, permission schemes, and notification scheme

Environment: SQL Server 2016, SQL Services Integration Services 2016, Visual Studio 2015, SQL Server Reporting Services 2016, SQL Server Management Studio, Tableau and Excel,HTML, Struts, JDBC, WebLogic

Confidential, Denver, Co

Sr. MS SQL Server Developer/SSRS/SSAS/SSIS/ETL

Responsibilities:

• Involved in Planning, Designing and implementation of data warehouse requirements and Objects.
• Collaborate with and department leaders to design, build, and customize reports, packages using SQL Server, SSRS, and SSIS
• Performed source/target analysis of data structures & content.
• Map source data to AZURE, ODS, or target databases
• Re engineering the existing SQL server SSIS Packages
• Created new Data warehouse objects and loading historical data.
• Implemented Data Scrubbing operations and improve data quality and system stability.
• Created processes that will validate data accuracy and consistency
• Used different SSIS transformations such as Conditional Split, Derived Column, Data Conversion, Join, CDC, SCD and expressions for Case statements were used for Data Scrubbing, before loading the data into the Data warehouse.
• Script component implemented to extract xml data from files stored in the tables.
• C# is used to developed command line tool (Customized BCP) for validation of various types of(Fixed width, csv, tab delimited) input files and filter the data and write into specified tables.
• Developed package to get data from different sources consolidate and merge into one single source.
• Developing modern user interfaces and creates enhancements to optimize user experience using Web API, HTML, CSS and j-Query.
• Exercising Software development experience in reporting development status and presenting innovative ideas to the management during Project Design meetings.
• Analyzing various system requirements, data flow charts, design and development of various modules of web applications.
• Worked on Automating Web Applications test using Selenium web driver using Selenium.
• Created package configuration using environment variables.
• Creation and Edit the existing BI Reports.
• Created and modified procedures for AZURE PDW.
• Good knowledge of relational database management systems and Data Modeling
• Modified existing stored procedures. Writing complex T-SQL queries.
• Proficiency in SQL including Joins, Alters, Sub queries, Pivots, Loops, Cases, and data transformation functions.
• Strong Performance tuning skills of SSIS packages and SQL queries
• Analysis of root cause for data issues
• Testing every created and modified database objects thoroughly.
• Worked in Agile SDLC process, attending Sprint scoping calls, daily standup meetings
• Self-motivated and having good communication skills.

Environment: SQL Server 2012, 2016, Azure PDW, T-SQL, MS Excel, Visual Studio, VB.net, C#, MS SSIS, MS Reporting Services (SSRS), SQL Server Report Builder 2016,TFS, Agile.

Confidential, Atlanta, GA

Sr. MS SQL Server Developer/SSRS/SSAS/SSIS/ETL

Responsibilities:

• Designed a complex SSIS package for importing data from SQL Server 2012
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling and different methods of logging in SSIS.
• Implemented data views and control tools for guaranteed data transformation using SSIS.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Successfully deployed SSIS packages with defined security
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• Developed logical database and converted into physical database using Erwin
• Proficiently created Reports based on the requirements using SSRS 2008
• Involved to write complex T-SQL queries and Stored Procedures for generating reports
• Defined parameters for parameterized Reports using SSRS
• Worked with Report Server and configured to SQL Server 2008
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008
• Created Batch files to run the script in development and production environment
• Developed, Deployed and processed OLAP cube using SSAS. Also implemented Incremental cube processing
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization
• Responsible to monitor performance and optimize SQL queries for maximizing efficiency
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system
• Used stored procedures, created new stored procedures and triggers, modified existing ones, and tuned them such that they perform well
• Tuned SQL queries using execution plans for better performance

Environment: MS SQL Server 2016/2012/2008 , SSAS 2012, SSIS 2012,SSRS 2012, T-SQL Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1

Confidential, Franklin, TN

SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in SSAS.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).
• Created packages in SSIS with error handling.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Excel spreadsheet and flat files into SQL server 2008 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.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in testing QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits with proper ICD - 9 and ICD - 10 and HCPCS/CPT codes.
• Involved in uploading and processing of EDI 278, 276 claims in Portal.
• Prepared sample EDI test sets for files like 276/77, 278,837 and followed HIPAA implementation guide in preparing them.
• Also used BizTalk server as middle ware server to see responses for X 12 files like 835.
• Worked on denied claims for justifications like why the claims got denied and paid zero to the providers to find out the issues.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Building UAT and Test environments using Production backups.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used indexes to enhance the performance of individual queries and enhance the stored Procedures.

Environment: SQL Server 2008, MS Excel 2010, QNXT,SSAS, MS SQL Server Reporting Services, MS SQL Server Analysis Services, Erwin,HIPPA,Informatica Power Center 9.1.0, Oracle 11g

Confidential, San Ramon, CA

SQL Server / BI Developer

Responsibilities:

• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages
• Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Query Analyzer, SQL Server Profiler, Erwin 7.3/MS Visio 2007

Confidential

SQL Server / SSIS /SSRS Developer

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for the purpose of application development
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.