SUMMARY

• Having all over 7 Years of professional experience working as a SQL Developer/Data Analyst in Various domainswell knowledge onData Mapping, Data Validation, and Requirement gathering in Data warehousing Environment.
• Experience in MS SQL Server 2012 with BIDS Business Intelligence in SSRS,SSIS
• Proficient in Software Development Life Cycle (SDLC) like Agile, Waterfall, RUP, Project Management methodologies.
• Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools SSIS, OLAP, OLTP and Data Warehouse Reports using Business Objects, Crystal Reports.
• 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 Dat)
• Experience in developing conceptual, logical and physical data models as per enterprise standards.
• Well versed in system analysis, Relational and Dimensional Modeling, Database design and implementing RDBMS specific features.
• Knowledge on Informatica dashboards and job schedules.
• Well versed inNormalization (1NF, 2NF and 3NF)and De normalizationtechniques for optimum performance in relational and dimensional database environments.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, cursors, tables, user profiles, relational database models and data integrity, SQL joins and query writing.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, breakpoints, Checkpoints, Transactions and package configurations.
• A good understanding of Extract, Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS).
• Worked on Reporting Services (SSRS) by Creating multiple reports like Drill Down, Drill through, parameterized, parameterized, and ad-hoc reporting.
• Experienced in development of content and visually rich reports in SQL Server Reporting Services (SSRS) like tabular, matrix, list, chart, gauge, and map.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views and Deploying and Processing SSAS objects.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Excellent Communication and presentation skills. Strong experience in working with Agile Scrum development methodologies and JIRA project management tool i.e. JIRA Administration, JIRA Reports/Dashboards
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.

TECHNICAL SKILLS

BI/ETL Tools: Informatica, Data Stage, Tableau, SQL Server DTS, SSIS, Visual Studio 2012

RDBMS/Data sources: Oracle, SQL Server, MySQL, PL/SQL

Databases: SQL Server 2012/2008R2, DB2, TERADATA, MS Access and MySQL,T-SQL.

Office Tools: MS Office Suite (Expertise in Excel, Word, Power-point), Microsoft Visio, Rational Rose.

Other Tools: JIRA, SVN, TOAD,HPQC

Scripting Languages: Shell Script,C#

Operating systems: MS Windows8/7/XP, Linux,UNIX

PROFESSIONAL EXPERIENCE

DA Analyst/BI Analyst

Responsibilities:

• Involved in gathering requirements from Business System Specialist and also involved in discussions with BSS for dashboard design.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Built ODS integrating the source systems for ad-hoc reporting and efficient to ad-hoc requests/issues.
• Used Erwin for reverse engineering to connect to existing database.
• Used ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Forward Engineer the physical data model and generated DDL script using Erwin.
• Usedfinancialtools to analyze credit transactions and assist in determining the optimum transaction mix to facilitate higher profits and/or decreased risk
• Developed Ad-Hoc and charts using SQL Server Reporting Services (SSRS) based on requirements
• Involved in documentation of Data Mapping & ETL specifications for development from source to target.
• Worked on T-SQL for developing complex stored procedures
• Assisting accountant teams to help prepare and maintain monthly budgets.
• Assisting ETL Team, BI team and end users to understand the data model

ETL Developer/BI Analyst

Responsibilities:

• Strong knowledge and experience with HIPAA EDI transactions such as 835, 837 (P, D, I) 834,820,270,271.
• Involved in the creation of EDI screens for the capture of data.
• Used Team Link to Report Jobs scheduling and running after test data set-up.
• Expertise in integrating disease management and case management services using SSIS.
• Performs data collection/analysis, and report preparation for practice quality (including Care Management /Risk Analysis) and process improvement activities.
• Monitored Health Reimbursement Arrangements (HRAs) or Flexible Spending Accounts (FSAs).
• Worked on Defectlogging and re-testingdefectsusing Team Link.
• Helped to analyze the data sets for data anomalies and also verified data quality content.
• Worked on producing data quality metrics.
• Cleaned and quality checked data to qualify for importing data into Act Database.
• Worked with exposure to Electronic Medical and Health Records (EMR & EHR).
• 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.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Interacted with DBA in creating the physical database design and QA team in their testing.

Sr. Data Analyst/BI Analyst

Responsibilities:

• Worked on Agile SDLC methodology while developing DBF to SQL ‘Data Reporting transformation’ project.
• 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 Crystal Reports, MS BIDS and Tableau to generate ad-hoc multi-dimensional and Cross functional reports based on daily, weekly and monthly sale.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Regular report generationon redeemed points ofsavings catcher Confidential pay App using SSRS.
• Incorporated savings and inventory reports.
• Automated whole report generation process.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Handled performance requirements for databases in OLTP and OLAP models.

Sr. Data Analyst/BI Analyst

Responsibilities:

• Involved in gathering requirements from Business System Specialist and also involved in discussions with BSS for dashboard design.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Analyzed mail orders for quarterly and generated reports using SSRS.
• Experience capturing requirements for web application development specifically in
• E-CommercePayment Transactions.
• Created complex sub queries basing on CTE, to savereceipts on customer’s device for Confidential pay application.
• Utilized Qwest tools (Toad 8.0, SQL Navigator)for database monitoring and tuning.
• 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 User Acceptance Testing (UAT).
• 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:

• Developed SQL queries for data-mining delimited text file or Excel file to SQL Server table columns and verify data transfer success.
• Supported internal and external customer needs using CRM.
• 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 WorkUnit.
• Evaluating credit risk of the prospective Member’s and created predictive tables on their debit paybacks.
• Data discovery, Aggregation and Transformation based on business use cases and requirement.
• Exported businessdatato Excel for further analysis utilizingSSRS.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Extracted data from client/server databases to transfer and load tables on the report databases using SSIS package SQL 2008 software.
• Prepared business use case understanding document by capturing the use case, basing on proposed solution and challenges.
• 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 presentation to clients to showcase key metrics/ trends, serve as a medium between the designer of the program and clients and enhance the program.
• Work with multiple data sources such as SQL, Access, flat data files, and database files to perform data transformations, hygiene and QA.

SQL Developer

Responsibilities:

• Experienced on creating reporting templates with parameters and automate the report delivery.
• Monitored Voice over IP, soft phones and telecommuter using EC500.
• Document Business Rules, Assumptions, Constraints, and Facts and suggest best possible ways for report automation and optimization.
• Written T-SQL scripts for reports automation, transform legacy static excel reports into dynamic and interactive reports.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• 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 Task - 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 meaningful summarized behavioral data trend presentations.
• Created Ad-hoc reports and dashboards for Sales, Inventory & Billing department via SSRS,SSAS

Data Analyst/ETL developer

Responsibilities:

• 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 EDDI portal same as SFTP and acknowledged the jobs scheduledand sent to vendor.
• Took Initiative for indexing of the tables in data warehouse.
• 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 the dimensions and fact tables using OLAP operations.
• Written scripts using JOINS, CTE, Stored procedures to pass the test cases while UAT testing.
• 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.
• Moved internal tables to external for the deployment environment using SQL Server.
• 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, and Facts and suggest best possible ways for report automation and optimization.
• Created Requirements and Wireframe design documentation for Qlikview projects using Agile Methodologies
• CreatedBRD, FRD, RTM for automation project.
• Leveraged QlikView Software applications to create web based dashboards allowing management and sales individuals to access.
• Conducted team meetings and JAD sessions.
• Written Test Cases and performed UAT testing.
• Developed and designed Wire frames and story board.
• Helped the 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.