PROFESSIONAL SUMMARY:

• Around 7+ Years of experience working as a SQL Developer /Data Analyst in Various domains such as Banking, Health Care, Retail etc.
• Proficient in Data profiling, Data Validation and Database designing in Data warehousing.
• Expertise in Software Development Life Cycle (SDLC) like Agile, Waterfall, RUP, Project Management methodologies.
• Experience in MS SQL Server 2012/2008 R2 with MSBI stack SSIS, SSAS, SSRS.
• Well versed inNormalization (1NF, 2NF and 3NF) and De - normalizationtechniques in RDBMS
• Highly proficient in the use of T-SQL for developing complex stored procedures, functions, views, triggers, cursors and query writing.
• Experience in designing reports using Visualizations in PowerBI Desktop and publishing to PowerBI/Tableau service.
• Implementing data refresh schedules, Dashboards, Content packs and sharing dashboards in PowerBI /Tableau service.
• Having good knowledge on Implementation of ETL and data modeling features in PowerBI/Tableau.
• Having knowledge on OLAP, OLTP systems in Data warehouse.
• 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.
• Experience in Dimensional Modeling and Data Visualization using SSAS, Microsoft PowerBI, Power Pivot and Database design using RDBMS.
• Having hands on experience in developing conceptual, logical and physical data models as per enterprise standards
• Worked on developing and implementing functionalities like STAR and SNOWFLAKE schema modeling, Hierarchies partitions, Calculations, Aggregations, Dimensions usage and creating cubes in SSAS.
• Experience in developing content and visually rich reports in SQL Server Reporting Services (SSRS) like tabular, matrix, list, chart, gauge, and map.
• Having knowledge 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 Teradatato solve complex business problems bydataanalysis on a large set ofdata.
• Knowledge in CodingTeradataSQL,TeradataStored 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 Center, JIRA.

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

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

Scripting Languages: C#

PROFESSIONAL EXPERIENCE:

Sr. Data Analyst/BI 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.
• 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.
• 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
• Written several queries and sub-queries for data validation using JOINS, WHERE clauses and retravel commands in SSMS.
• Usedfinancialtools to analyze credit transactions and assist in determining the optimum transaction mix to facilitate higher profits and/or decreased risk
• 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.
• Written testcases and performed unit testing in SIT
• Tracked tickets and resolved on time by interacting with defect manager and testing team.

Sr. Data Analyst/BI Analyst

Responsibilities:

• Strong knowledge and experience with HIPAA EDI transactions such as 835, 837 (P, D, I) 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.
• 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.
• 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.

Sr. Data Analyst/BI 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.
• Worked with marketing team for specifications in data
• Regular report generation on redeemed points of savings catcher Confidential pay App using Tableau 8.1
• Incorporated savings and inventory reports and, automated whole report generation process
• Developed Star and Snowflake schemas dimension modeling.
• Handled performance requirements for databases and reports.
• 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.

SQL Developer/ETL Developer

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.
• 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.
• Queried the raw data in Access to prepare reports in Excel for Data presentation to clients to showcase key metrics/ trends.

SQL 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.
• 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.

Data Analyst/ETL developer.

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.
• Involved in the performance tuning using SQL queries.
• 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 theprogress of alldefectsuncovered duringtesting.
• Physical Migration of the Developed reports onto the DevelopmentSSRSserver
• 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.

Jr. Data Analyst.

Responsibilities:

• Developed, maintained and supported on-line automated systems for web reports tools using ASP.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.
• Conducted logical data model walkthroughs and validation.
• Documented Business Rules, Assumptions, Constraints, Facts and suggest best possible ways for report automation and optimization.
• Created reports in web application using crystal reports.
• Prepared FRD, RTM for automation project.
• Conducted team meetings and JAD sessions.
• Written Test Cases and performed UAT testing.
• 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.