SUMMARY

• 8+ years of experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS in OLTP and OLAP (Data Warehousing) environments and T - SQL Programming using DDL, DML, DCL commands for various business applications.
• Good understanding of different Software Development Life Cycle (SDLC).
• Proficient in installing, configuring, managing, monitoring, and troubleshooting MS SQL Server 2016/2014/2012/2008/2008 R2/2005.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Generated sub reports, crosstab, conditional, drill down reports, drill through reports and parameterized reports using SSRS.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expert in Upgrading and Data migrating SQL 2012 SSIS packages to SQL 2014 and from SQL 2008 SSIS Packages to SQL 2012.
• Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers and Cursors for various business applications using T-SQL programming.
• Experience inRDBMSconcepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables andStored Procedures.
• Experience in migration of Data from one SQL Server Database to another SQL Server Database using import export function.
• Experience in developing, deploying packages and extracting data using SSIS of MS SQL from OLTP to OLAP.
• Excellent communication, interpersonal skills, good time management and fast learner abilities.

TECHNICAL SKILLS

Operating Systems: Windows XP/Vista/7/8/10

Databases: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016/2019 , MS Access, AZURE, Oracle

ETL Tools: SQL Server Integration Services (SSIS), Informatica Cloud (ICS), Informatica Intelligent Cloud Services (IICS), Informatica Cloud Real Time (ICRT), Talend

Database Tools: SQL Profiler, SQL Query Analyzer, Management studio, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe, Microsoft Excel (PivotTable), OLAP and OLTP, Redgate

Skills and Languages: Transact SQL (T-SQL), VB.Net, HTML/CSS, Toad, Oracle SQL Developer, TFS

DB Modeling Tools: Open System Architect (OSA)

Reporting Tools: SQL Server Reporting Services (SSRS), Grafana, Tableau, Power BI, Business Object

PROFESSIONAL EXPERIENCE

Confidential

AMS System Analysis

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Extracted data from Oracle source that can be used for different reports.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases like Oracle Database & SQL Database.
• Used SentryOne to Monitor SQL jobs and Database performance.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective.
• Participate in the design, implementation, execution and debugs manual test cases using a variety of testing techniques.
• Create test cases based on requirements.
• Uses data analysis skills and the ability to track a data element from source to transformation to target.
• Implements data models optimizing the data-mining performance function.
• Implements Extract Transform Load (ETL) solutions using BI best practices and methodologies; identifies root causes of issues with data quality and other related issues.
• Supports the development of new software or enhances existing software and integrates into new or modified systems and/or operational environments.
• Assist a reporting team optimizing the ETL process to ensure that business requirements are met.
• Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.
• Provide on-call production support on a rotating basis to ensure the timely and successfully deliverance of ETL data and reports.
• Created databases and schema objects including tables, indexes, stored procedures and functions as a part of the data migration initiative.
• Built SSIS packages and scheduled jobs to migrate data from Oracle source to cloud based Azure SQL instance using different tools like MS SQL, SSIS.
• Performed root cause analysis on failures, Resolved performance tuning related issues and queries.
• Created and maintained multiple tables, warehouses, databases and connections.
• Created different kinds of visualizations by using tableau dashboard that would be beneficial for business making decisions.
• Developing custom scripts, tools, and programs in the support of the POS, Infrastructure and stakeholder departments
• Optimizing and supporting the POS group’s day-to-day tasks by supplying process automation scripts and development of job specific tools.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

Confidential

Solution Developer\Support

Responsibilities:

• Creating and maintaining SSIS Packages and SQL Server Databases
• Writing ad hoc queries in Oracle and SQL server database
• Creating, modifying and maintaining Stored Procedures and views for handling business logic and functionality such as Email Alerts, Data Extracts build in Excel
• Researching, analyzing and troubleshooting issues in database applications and web application
• Developing software solutions by studying requirements analysis and information needs
• Studying systems flow, data usage, and work processes
• Debugging, testing, and deploying software solutions following the software development lifecycle
• Working with other departments, users, and IT Management to determine business needs
• Developing and maintaining key components of the software suite using various applications technologies as well as writing technical requirements and specifications for new products or services
• Worked on generating reports using SQL Server Integration service from oracle source and deliver the reports to different departments through Excel spreadsheet
• Implementing workflows as well as development of Business Intelligence per department standards and procedures
• Participating in product design reviews by providing creative and practical ideas and solutions in a teamwork environment
• Supporting various off-the-shelf applications including system interfaces
• Coordinating and leading projects from with some guidance from a Senior Solution Developer and/or Project Manager.
• Developing custom scripts, tools, and programs in the support of the POS, Infrastructure and stakeholder departments
• Optimizing and supporting the POS group’s day-to-day tasks by supplying process automation scripts and development of job specific tools.
• Developing custom solutions to routine IT problems in a very distributed environment
• Working on migrating of data from SQL server 2012 to SQL server 2014, SQL server Integration service from BIDS 2008 to SSIS 2015 and windows 2003 to window 8

Tools: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016/2019 , AZURE, OracleSQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), PowerShell, Windows Batch, Winscp scripting, SentryOne, Redgate

Confidential, CA

System Analyst

Responsibilities:

• Involved in gathering the requirements that were critical to the business process flow and using those requirements for the Business Requirements Document (BRD), for the implementation of the NPI in EDI X12 transactions as mandated by the Federal Regulation.
• Worked withETLTeam to design the mapping documents for source to data.
• Good understanding of data flow architecture, system integration, database behavior, and testing strategy
• Extensively use SQL queries for back-end testing and to query the Oracle Database for Data Validation and Data Integrity.
• Created the requirement documents to channel 270/271, 276/277 and 835/837 EDI transactions
• Worked on Business Requirement Documents, Test Plan, Test Strategy & Schedules. Very good in all the Documentation & Project life cycle Documentation.
• Daily Status reports to the Business owner, Project executives & Team.
• Making sure the aggressive timeline of the project is maintained.
• Analyzedtheexisting 820 reports andmodifiedthem based on the changes resulting fromthe Health Insurance Exchange (HIX)
• Conducting business validations, covering the following deliverables: FACETS Providers, Facets Claims and Facets Membership and Operational reports.
• Extensively studied the Rules & Policies that supported the Health Care Reform requirements.
• Facilitate UAT Testing by providing necessary support to the Business users.
• Performed Automated testing on various legacy COB/OPL (Other Party Liability) applications
• Analyze and make specific recommendations on improvements that can integrate into the business process.
• Performed Back-end Testing on data base tables using SQL Navigator and IBM data studio
• Develop Test plan for Healthcare reforms (HIX) and Care and Population Health Management programs.
• Tested Benefit Plans from enrollment standpoint and claim processing
• DocumentedXMLfile processing Use case, as well as identifiedXMLfile level processing errors.
• Organized and conducted meetings, briefings, demonstrations and wrote minutes of project meeting.

Confidential

Data Engineer/Analyst

Responsibilities:

• Development and enhancement of ETL packages extensively working in data Extraction, Transformation and Loading from source to target system using SQL Server Integration Services.
• Create SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and stored procedure
• Developed deployed and monitored SSIS packages
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB source, Flat files, excel Spreadsheet to SQL server 2008/2012
• Worked in Upgrading and Data migrating SQL 2008SSIS packages to SQL 2012.
• Development of varies SSIS packages, SSRS (reporting services), and stored procedures utilizing SQL server Data tools and SQL server 2008/2012
• Worked on different types of Actions like Drill Through action and Report action.
• Scheduled Reports Weekly and Monthly basis as per the Client Requirements.
• Maintained log information in Text file to tracking Errors and recording package execution status.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Performed unit testing and SQL performance tuning.
• Tuned SQL statements Using Indexes and stored procedures.

Confidential

Core Banking Systems Support Engineer

Responsibilities:

• Identified data source and data views for building the OLAP and OLTP cube in SSAS.
• Defined measures, dimensions, and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Analyzed the database schema structure of theOLTPdatabase and designed ETL processes.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling
• Extensively involved in the SSASstorage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSASand in adding calculations using MDX.
• Worked on generating reports using SQL Server Reporting Services and Excel spreadsheet.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Created Parameterized, matrix and drill down reports using SSRS 2008.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures, and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving, and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.
• Deployed the generated reports created using SSRS 2008 on to the server.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.