SUMMARY

• Around 7+ Years of experience working as a SQL Developer/ Data Analyst in Various domain such as Banking, Health Care, Retail etc.
• Expertise in Software Development Life Cycle (SDLC) like Agile, Waterfall, RUP, Project Management methodologies.
• Highly capable in the utilization of T - SQL for creating complex put away systems, capacities, sees, triggers, cursors and question composing.
• Good hands-on working background with utilizing a wide range of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, and Dynamic-inquiries.
• Well versed in Normalization (1NF, 2NF and 3NF) and De-Normalization techniques in RDBMS
• Experience in Dimensional Modelling and Data Visualization using SSAS, Microsoft PowerBI, Power Pivot and Database design using RDBMS.
• Proficient in Data profiling, Data Validation and Database designing in Data warehouse, and furthermore designing concepts like OLAP, OLTP systems in Data warehouse designing.
• Having hands on involvement in developing conceptual, logical and physical data models as per enterprise standards
• Experience working with designing a canonical model and working on Ralph Kimball and Bill Inman approaches.
• Worked on developing and implementing functionalities like STAR and SNOWFLAKE schema modelling, Hierarchies partitions, Calculations, Aggregations, Dimensions usage and creating cubes in SSAS.
• Implemented slowly changing dimension (SCD) type I and type II in dimensional modelling as per requirements.
• Having great Exposure on Implementation of ETL and data modelling features in PowerBI.
• Expertise in Data transformation like Transpose, Pivot columns, Aggregate, Extract values, Conditional Column, Index Column using Microsoft PowerBI.
• Experience in designing reports using Visualizations as Scatter-Chart, Stacked-Column-Chart, Pie-Chart, Filled map, Shaped map in PowerBI Desktop and publishing to PowerBI services.
• Good Experience in creating New measures, New Tables, New columns using DAX queries In PowerBI Desktop.
• Implementing data refresh schedules, Dashboards, Content packs and sharing dashboards in PowerBI &Tableau services.
• Experience in MS SQL Server 2012/2008 R2 with MSBI stack SSIS, SSAS, SSRS.
• Experience in Designing SSIS Packages - for integrating data from heterogeneous sources (Excel, CSV, flat file, Text Format)
• Worked on SSIS, for ETL processing ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in data warehouse concepts and implementing incremental and full loads using SSIS.
• Experience in loading Dimension and Fact tables using SSIS.
• Expertise in implementing various transformations such as derived column, data conversion, conditional split, Lookup, Merge join, union all in SSIS.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations Experience in Cube designing in Business Intelligence Development Studio using SSAS.
• Experience in developing content and visually rich reports in SQL Server Reporting Services (SSRS) like tabular, matrix, list, chart, gauge, and map.
• Having Experience on drill down, drill through, sub reports, parameterized reports and expressions in SSRS.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in reporting server.
• Strong experience in working with Agile Scrum Development Methodologies and JIRA project management tool i.e. JIRA Administration, JIRA Reports/Dashboards.
• Knowledge on Teradata to solve complex business problems by data analysis on a large set of data.
• Knowledge in Coding Teradata SQL, Teradata Stored Procedures and Triggers.
• Excellent Communication and presentation skills.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R2, TERADATA, MS Access.

BI/ETL Tools: SQL Server DTS, Data Stage, SSIS, SSDT for Visual Studio 2012/2010/2008.

Reporting Tools: SSRS, Tableau, Power BI, Power Pivot.

Office Tools: MS Office Suite (Excel, Word, Power-point), Microsoft Visio, Erwin.

Testing tools: Quick Test Professional(QTP), HP ALM/Quality Centre, JIRA.

Operating systems: MS Windows10/8/7/XP, Linux, UNIX.

Reporting Tools: SSRS, Tableau, Power BI, Power Pivot.

Scripting Languages: C#

PROFESSIONAL EXPERIENCE

Confidential -Chicago, IL

Sr. Data Analyst/SQL Server Analyst

Responsibilities:

• Involved in JAD sessions, Sprint meetings and daily scrum calls.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Developed and maintaining the design document by updating it according to each phase of project.
• Created SQL objects like Tables, Functions, Stored procedures, Views, Indexes etc.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Setup MSSQL and performedDBAfunctions
• Performed Forward Engineering process on the physical data model and generated DDL script using Erwin.
• Good Exposure in batch wise processing of data and creating reusable SSIS packages using expressions and project parameters.
• Created batch files that execute the ETL scripts which invokes SSIS packages.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Implemented Custom logging in SSIS, configuring environment variables.
• Extracted data from various sources like EXCEL, OLEDB etc., cleansed and transformed to required format, later loaded to data marts.
• Worked on data validation using VLOOKUP functions and table formulas in MS EXCEL
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results.
• Used financial tools to analyze credit transactions and assist in determining the optimum transaction mix to facilitate higher profits and/or decreased risk
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008 R2/2012 Analysis Services (SSAS) and Reporting service (SSRS)
• Created reports in Performance Point using cubes for Analysis Purposes of the Organization.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Developed Ad-Hoc report model and charts using SQL Server Reporting Services (SSRS) based on requirements
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• ProvidedDBAsupport for multiple applications in development, test, and production environments
• Written testcases and performed unit testing in SIT
• Tracked tickets and resolved on time by interacting with defect manager and testing team.

Environment: MS Excel, T-SQL, Erwin, MSSQL Server2008R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET C#-V.3.5

Confidential -Rochester, MN

Sr. Data Analyst/ SQL Server Analyst

Responsibilities:

• Strong knowledge and experience with HIPAA EDI transactions such as (835,837,834,820,270,271).
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Responsible for physical/logical data modeling: metadata documentation; user documentation; and production specs.
• Wrote complex SQL Scripts and used the Excel and CSV, JSON, XML files to load data into the maintenance table.
• Created, maintained different types of SQL server objects like Tables, stored procedures, functions, views, triggers etc. with the help of business requirements.
• Created dashboards on Power BI service and shared with business users.
• Used PowerBI visuals like Stacked column chart, Area chart, Clustered column chart.
• Created various reports like Bar-graph, Pie-chart, Maps (Tree Map, Filled maps) on Power BI reports for data visualization.
• Worked on multiple Data sets in PowerBI dashboards.
• Involved in the creation of EDI screens for the capture of data.
• Auditing ofFacets, Medicare and Medicare Secondary Payor examiners at least 47claimsper week when applicable.
• Implemented PowerBI scheduling to refresh report data by using gateways.
• Maintaining and updating audit guidelines to reflect any changes to theFacetsclaimsprocessing system and procedures.
• Performs data collection/analysis, and report preparation for practice quality (including Care Management /Risk Analysis) and process improvement activities.
• Using PowerBI Desktop connected to various sources like EXCEL, Flat files, Web and SQL server database for designing report.
• Worked on assigned defects and delivered quality code.
• Performed integration testing to see the test cases are passed in SIT environment.

Environment: MSSQL Server2008R2/2012, T-SQL, Microsoft PowerBI, DAX,Splunk, MS Excel

Confidential -Bentonville, AR.

Sr. Data Analyst/ SQL Server Analyst

Responsibilities:

• Worked with Sales and Marketing teams to gather Reporting/Dashboard requirements.
• Manage supply chain management processes, future forecasting, back orders, percent sales, KPI, net profit/loss, dead stock, inventory status.
• Design BI Sales and Inventory Ad-hoc reports for Wal-Mart.
• Worked on Tableau to generate reports and dashboards based on daily, weekly and monthly sale.
• Connected to multiple databases from tableau server and generated reports in graphs, pie charts, maps and other visuals.
• Reported performance and resource utilization metrics on databases.
• Involved in documentation of existing process and preparing play book specification for the new requirements.
• Using Tableau Desktop connected to various sources like EXCEL, Flat files, Web and SQL server database for designing report.
• Created visualizations using custom hierarchies, groups and merged data from multiple sources using the data blending technique with in theTableauworkbook.
• Worked with marketing team for specifications in data
• Regular report generation on redeemed points of savings catcher Confidential pay App using Tableau 8.1
• Used LOD functions like fixed, Include and Exclude to determine User login frequency inTableau.
• Incorporated savings and inventory reports and, automated whole report generation process
• Developed Star and Snowflake schemas dimension modeling.
• Implemented Tableau scheduling to refresh report data by using gateways.
• Handled performance requirements for databases and reports.

Environment: MSSQL Server2012, MS Excel,T-SQL,Tableau8.1

Confidential -Bentonville, AR.

Sr. Data Analyst/ SQL Server Analyst

Responsibilities:

• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Experienced in Creating reports, Jobs, Alerts and scheduling and monitoringSSISpackages using SQL server agent.
• Expertise in creating dynamic tasks using script task and precedence constraints with AND/OR gate operations.
• Well versed in using SSIS various tasks like Data-Flow Task, Execute-SQL task, File system task etc.
• Worked on Sequence container for multiple and parallel package execution in SSIS control flow.
• Analyzed mail orders for quarterly and generated reports using SSRS.
• Developed Monitored and deployed SSIS packages.
• Used complex T-SQL queries and advanced window functions like Rank, Row number to get the desired results in SSRS.
• Created complex sub queries to save receipts on customer’s device for Confidential pay application.
• Wrote severalT-SQL Queries for Ad HocDataPull request.
• Streamlined billing and operations processes to increase payment efficiency.
• Worked on T-SQL for developing complex stored procedures to retrieve data fast to the end user.
• Monitored team's ticket queue for compliance and appropriate prioritization using JIRA tracking tool.
• Facilitated in developing testing procedures, test cases and system Integration testing (SIT).
• Experienced in writing stored procedures and CTEqueries to solve issues in day-to-day activity and recurring issues to avoid manual effort
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.

Environment: MSSQL Server2012, MS Excel,T-SQL,SSIS,SSRS,JIRA.

Confidential, NYC

Data Analyst/ SQL Server Analyst

Responsibilities:

• Prepared business use case understanding document by capturing the use case, basing on proposed solution and challenges.
• Worked on Data discovery, Aggregation and Transformation based on business use cases and requirement.
• Work with multiple data sources such as SQL, Access, flat data files, and database files to perform data transformations basing on business requirements.
• Enhanced Physical designing of existing database design.
• Data Migration -mapping the data from transformed data to destination systems.
• Data verification is done on transformed data migration process
• To improve data quality, automated and manual data cleaning is performed in Data Migration
• Converted and compared Teradata scripts to MSSQL Scripts.
• Maintained and updated Design document as per requirement for every phase of project.
• Created User defined variables like read only and read-write variables using Execute-package task in SSIS.
• Configured process failure or success acknowledgments via automatic mails to respective people using SSIS-Send Mail Task.
• Managed Connection managers, Parameters and Event Handlers In SSIS-package Explorer component.
• Developed SQL queries for data-mining delimited text file or Excel file to SQL Server table columns and verify data transfer success.
• Used CTE and inline calculation to instead sub-query-involved user-defined functions
• Built more than 30 production formatted reports with a series of automation process by using SQL/TSQL, SSRS, Agent Jobs, and Work Unit
• Evaluating credit risk of the prospective Member’s and created predictive tables on their debit paybacks.
• Exported businessdatato Excel for further analysis utilizingSSRS.
• Carried out SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database.
• Performed SQL server logs and security operations as DBA.
• ProvidedDBAsupport for multiple applications in development, test, and production environments
• Queried the raw data in Access to prepare reports in Excel for Data presentation to clients to showcase key metrics/ trends.

Environment: MSSQL Server2012, MS Excel,T-SQL,SSIS,SSRS,Teradata.

Confidential - Chicago, IL

SQL Server Developer

Responsibilities:

• Involved in various stages like development, system analysis and design.
• Created levels of Data Flow Diagram using Microsoft Office Visio.
• Designed and developed Entity-relationship Diagram and Data Dictionary up-to-date after any alterations were made to the metadata and data in each table.
• Created SQL Agent jobs to run SSIS packages.
• Written T-SQL scripts for reports automation, transform static excel reports into dynamic and interactive reports.
• Experienced on creating reporting templates with parameters and automate the report delivery.
• Created summarized behavioral data trend presentations.
• Identified the Test Cases to be automated and generated the automated scripts usingQTP.
• Reduced procedure cache usage by enabling the optimization for ad hoc workloads.
• Troubleshooting performance issues and fine-tuning queries and stored procedures using SQL Profiler and Execution Plan.
• Bill Simplification Process - Dramatically simplified customer invoices into a single summary bill and optional detail support, tailored to each customer.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Worked towards finding trends and patterns within the reports by analyzing SQL datasets and accordingly suggest best possible modification on carrier plan which leads towards cost optimization.
• Created Ad-hoc reports for Sales, Inventory & Billing department via SSRS.

Environment: MSSQL Server2012, MS Excel, T-SQL,SSRS.

Confidential

Data Analyst/ SQL Server Analyst

Responsibilities:

• Experienced in writing Functional Requirement Specifications (FRS) and Technical Specification Document.
• Played key role in System Development Life Cycle Process consisting of Design and Gap Analysis.
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Worked on Enterprise Data warehouse and upstream products of the organization.
• Worked on Data Migration phases like Design, Extract, Transform and load the data to new systems.
• Involved in the performance tuning using SQL queries.
• Migrated data and checked data validation through data audits
• Created Data-storage migration space to move physical data block from one to another disks for visualization purpose
• Built Physical and conceptual models basing on dimensional modeling techniques to build proper EDW.
• Worked with various ETL tools for the generation of data marts for reporting purpose.
• Monitored the survey information from the vendor is updated on time to the database.
• Developed predictive tables for Health risk assessment HRA module using JOINS and T-SQL queries.
• Analyzed database requirements from the users in terms of loading dimensions and fact tables using SSIS Packages.
• Helped with building ICD-9 to ICD-10 crosswalk map by grouping thousands of codes and ranges in Clinical, Benefits, Financial, Medical policy waves.
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using SSIS.
• Performed all TRACK database tasks, including setting up team members, ensuring that data was entered correctly, and tracking the progress of all defects uncovered during testing.
• Physical Migration of the Developed reports onto the Development SSRS server
• Prepared Test plans which includes various test strategies, test schedules and test deliverables.
• Used JIRA dashboard to check ticketing issues and resolve the bugs raised in the environment.
• Written complex SQL queries for querying data against different data bases for data verification process.

Environment: MSSQL Server2012, MS Excel, T-SQL,SSIS,SSRS.

Confidential

Jr. Data Analyst

Responsibilities:

• Involved in preparing Business requirement document(BRD).
• Prepared Functional Requirement Document (FRD), Requirement Traceability Matrix (RTM) for automation project.
• Participated in team meetings and JAD sessions.
• Developed, maintained and supported on-line automated systems for web reports tools using ADO.NET, C# from user interface (UI) to connect to Business logic layer.
• Written scripts in the native database SQL for data extraction which includes all transformation and JOIN rules.
• Modeled a database to store customer demographic and other data.
• Developed wireframes and worked on user interface development using some tags in HTML, CSS, AngularJS
• Conducted logical data model walkthroughs and validation.
• Written Test Cases and performed UAT testing.
• Documented Business Rules, Assumptions, Constraints, Facts and suggest best possible ways for report automation and optimization.
• Worked with DBA in creating the physical database design and QA team in their testing.
• Involved in comprehensive testing of the system to check it satisfies functional specifications.