SUMMARY

• Good understanding about healthcare industry and pharmaceutical fields. Worked with all the phases of System Development and Project Management Life Cycle from analysis of business requirements, designing the implementation strategy, Data Analysis, relational database design and architecture, business/technical liaising, workflow and quality assurance.
• Strategic planning of working in various domains - Healthcare, Digital Marketing and Insurance Industries.
• Comprehensive knowledge of software development methodologies (SDLC) such as Waterfall, AGILE SCRUM.
• Involved in determining project scope, requirements and maintaining project documentations
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires and brainstorming
• Expertise in creating Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Functional Requirements Specifications (FRS), Use Case Diagrams, Descriptive Use Case, Activity Diagrams, and Sequence Diagrams using UML modeling, Class diagrams in Power Designer, MS Visio.
• Experience in conducting GAP analysis, SWOT analysis, Cost benefit analysis and ROI analysis and developed Requirement Traceability Matrix using MS-Excel.
• Strong knowledge of Business Process Modeling assessing "As Is" & "To Be" scenarios and Business Re-Engineering (Re Design) research, & implementation methodologies, diagramming data & process mapping.
• Experience in Data Warehousing, OLAP, ETL and Business Intelligence. Developed Database ETL/API programs using SQL & PLSQL (Procedures, functions, triggers, Packages, Views and Materialized logs & Views).
• Experience in SQL tuning by analyzing data access paths including Explain Plan and using Database hints, indexes and partitions.
• Experienced in designing and developing various kinds of reports (Tabular, List, Matrix) using SQL Server Reporting Services (SSRS).
• Expertise in Tableau BI reporting tools &Tableau Dashboards Developments & Server Administration.
• Created dashboards and Scorecards like analytical and operational reports.
• Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven
• Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.
• Worked with clients on open receivables.
• Worked with customers and internal support team to triage and resolve conflicts.
• Build database queries and test cases for the testing team to test the reports.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2012, 2008, 2005, 2000, DB2, Azure SQL.

Database Tools: T-SQL, PL/SQL, DTS, OLTP, BCP, SSIS, OLAP.

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau.

Operating Systems: Windows XP/2008/2012, UNIX, Windows 9x.

BI Tools: SQL Server Analysis Services (SSAS).

Analytic Tools: R-Programming.

Methodologies : Waterfall, Agile, Spiral, RUP

Tools: MS Visio

EXPERIENCE:

Business Analyst

Confidential, Darien CT

Responsibilities:

• Served as a liaison between business users, technology development, production support, and business architect team to build a branch application.
• Identified business requirements and documented them meticulously, and translated them to functional requirements.
• Maintained the functional requirement document (FRD) with detailed specifications and worked with business users to find solutions that are cost effective and meet business needs.
• Created Use Cases, Process and Activity Flow Diagrams using MS Visio to derive a clear and common understanding among stakeholders.
• Collaborated with designers and stakeholders to finalize wireframes to provide to development and test teams.
• Documented test strategies and translated into test scripts to ensure proper test plans are employed.
• Facilitated user acceptance testing sessions with business users before release.
• Maintained and developed SQL queries, stored procedures, views, functions and reports using Microsoft SQL Server.
• Certified SAS Base Programmer.
• Created, managed, and delivered interactive web-based reports to support daily operations.
• Played a vital role in cleansing and validating the data.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Performed PL/SQL validation queries by cross testing the resulting data from the reports.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Building and publishing customized interactive reports and dashboards reports in the tableau server.
• Created SQL server configuration for SSIS packages. Used SSIS transformations to implement the slowly changing Transformation, to maintain Historical Data in Data Warehouse
• Developed Dashboards and Customer Service Reports to measure Critical Business Factors.
• Introduced Software Development Life Cycle and Agile Methodology to the organization with 2 week sprints, standups, planning and design meetings.
• Involved in Creating and Managing security rules for dashboards and views.
• Recommended and took lead on new ideas of implementation/developing of Web I reports involving responsibilities towards getting dashboard requirements, design, document, develop and test front end dashboards and reports.
• Implemented batch processing for approval using SSIS and later schedule them with SQL Server Agent.
• Worked with handling the Data warehouse audits and error handling with rejects records, total counts of records based on the update, delete and insert and Power pivot.
• Created package with different data sources and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and VLOOKUP.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2012, C#, Visual Basic 6, Excel.

Business Analyst/ BI Developer

Confidential 

Responsibilities:

• Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Identified business requirements and documented them meticulously, and translated them to functional requirements.
• Maintained the functional requirement document (FRD) with detailed specifications and worked with business users to find solutions that are cost effective and meet business needs.
• Created Use Cases, Process and Activity Flow Diagrams using MS Visio to derive a clear and common understanding among stakeholders.
• Collaborated with designers and stakeholders to finalize wireframes to provide to development and test teams.
• Documented test strategies and translated into test scripts to ensure proper test plans are employed.
• Facilitated user acceptance testing sessions with business users before release.
• Migration of DTS packages to SSIS packages and individually designed MS SQL Server 2008 database, coded stored procedures (T-SQL).
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Created package with different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience with writing T-SQL, PL/SQL code and working on Dashboard and crystal reports
• Worked with Quest SQL Compare table and the data compare between Dev to Test and Test to Prod environment.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008/2012.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Writing complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Monitoring execution plans to enhance the performance of the queries.
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time.
• Troubleshooting and Performance tuning using Quest Performance Analyzer to diagnose historic data as well as current ones.
• Designing, developing, implementing, and maintaining reporting frameworks.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Performed Tableau type conversion functions when connected to relational data sources.
• Merging data into a single server environment to have better control, consistency and security of data..
• Adept at rebuilding indexes on various tables.
• Adept at debugging stored procedures using SQL Server Profiler.
• Restored QA server from development periodically to test the queries on the QA server.
• Developed OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards.
• Built SSRS reports from various heterogeneous sources like SQL Server
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008/2012.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2012, C#, Visual Basic 6, BMC Control-M Workload Automation.