SUMMARY:

• Have around 7+ years of industry experience as Business Analyst with solid understanding of Business Requirement Gathering, Business Process flow, Business Process Modeling, and Data Analysis/Data Modeling/SSISETL/SSRS/SSAS.
• Extensive experience in business process engineering and Software Development Life Cycle (SDLC) including analysis, design, development, testing, implementation and supporting of software application.
• Experience in MS SQL Server 2012/2008R2/2008/2005, Database Migration, Database Administration, Physical/Logical Design, T - SQL, Performance-Tuning, Troubleshooting, Backups and Restore of databases
• Business Requirements Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers. Gathered user and business requirements through interviews, surveys and prototyping, System Requirements Specifications (SRS), System Design Specifications, functional specifications, non-functional specifications and defining project plans.
• Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.
• Experienced in modeling both OLTP/OLAP systems using Hybrid Kimball and Inmon methodologies.
• Hands on SQL experience in TSQL 2005, 2008, 2008R2, 2012 database and analysis, design and development for various BI solutions and Business Analyst and Network Engineer.
• Creation of jobs sequences and job schedules to automate the ETL process by extracting the data from flat files, Oracle and Teradata into Data Warehouse.
• Extensive experience creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Functions, Triggers and Cursors onMicrosoftSQLServer2005/2008/R2.
• Developed SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating/deploying Reporting Services (SSRS), Data Transformation Services (DTS) and MS SQL Server Integration Services (SSIS) packages.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Tabular, Top N, Summary, Sub reports, Charts and Graphs and formatting those using SSRS 2005/2008.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Services (DTS), SQL Server Integration Services (SSIS) 2005/2008, Bulk Insert/ BCP utility.

PROFESSIONAL EXPERIENCE:

Confidential - Memphis, TN

Business System Analyst

• Assisted project managers and technical leads through design and implementation by identifying, analyzing, redesigning and documenting all phases of SDLC.
• Performed Business Analysis by Analytical operations and technical skills, to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems.
• Successfully worked with domestic multiple Data Centers; Shelby, Foothill Ranch, Center Pointe and North American Distribution Center teams.
• As an Agile business analyst, I have produced polished user stories and acceptance criteria. Prepared user interface design documents, user training guides, storyboards, wireframes and mock - ups.
• Strong business analytic and user interface design skills in an agile development environment
• Agile experience includes; leading sprints through sprint planning and development, creation and prioritization of the product backlog, as well as user story and acceptance criteria development (Versionone). Experienced in leading sprint review and sprint retrospective sessions.
• Involved in the analytical operations; analyzing data and its mapping and developed the queries for Cognos Reporting.
• Worked on Cognos 8 xs, Cognos 10 into Cognos 11 Components Report Studio, Query Studio and Analysis Studio.
• Performed demonstrations of new application functionality for Subject Matter Experts (SME) at daily stand-up with Scrum Master. Responsible for conducting training and creating training materials for all Record Managers. Managed and created end-user and operational process documentation.
• Managed and created feedback forms during UAT (User Acceptance Testing).
• Participated in UAT test cases execution with QA team.

Environment: Scrum-Agile Environment; VersionOne, MS SQL Server 2012, Cognos 8.4/Cognos 10.1(Report Studio, Query Studio), MS Office: Excel, Visio Basic Application and PowerPoint, Word, MS Access

Confidential, TN

Sr. Data Analyst

Responsibilities:

• Assisted project managers and technical leads through design and implementation by identifying, analyzing, redesigning and documenting all phases of SDLC.
• Performed Business Analysis by Analytical operations and technical skills, to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems.
• Involved in monthly aggregation process.
• Presented the Dashboards and detailed ESQI reports to Business users and cross functional teams.
• Developing complex SQI Consolidated, Product Reliability and RMC Reports multi-functional levels for different OpCo’s, summary functionality in main reports providing detailed drill down through on Demand Sub-reports by number proofing.
• Manual data inclusions, data exclusions, data corrections in EDW, pipe-deliminated the data and support tracker for the different metrics. In converting the auto generated ESQI Reports under PRR
• Database sources like SAS and Tera Data SQL Assistant to load data to Enterprise Data warehouse.
• Presented the Dashboards and detailed ESQI reports to Business users and cross functional teams.
• Developed complex SQI Consolidated, Product Reliability and RMC Reports multi-functional levels for different OpCo’s, summary functionality in main reports providing detailed drill down through on Demand Sub-reports by number proofing.
• Worked extensively in migrating data from various sources such as MS Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SQL Server SSIS 2008/2014.
• Upgraded SSIS packages from 20 version and also created indexes on tables if needed.
• Used SSIS transformations such as, For-Each Loop Container, Sequence Container, Expressions, Execute SQL task.
• Updating about 25 columns in each table by implementing complex queries, stored procedures as required by the business logic.
• Created logical and physical model for analytical databases.
• Identifying Multiple Dimensions and Fact tables.
• Work with IT to understand the root cause and define solutions to issues.

Environment: SAS, Teradata, MS SQL Server 2014/2012/2008 , SSIS, SSRS, SnagIT, MS Office: Excel, Visio Basic Application and PowerPoint, Word, MS Access

Confidential, Harrisburg

Sr. UAT Tester

Responsibilities:

• Assisted project managers and technical leads through design and implementation by identifying, analyzing, redesigning and documenting all phases of SDLC.
• Built relationship with Product owner and other stake holders to facilitate team's interaction and coached them in creation and maintenance of product backlog on this new Instant Answer insurance product to improve rate adequacy.
• Managed actor stories, created use cases and sequenced stories using appropriate tools.
• Designed and developed Use Cases, Entity Relationship Diagrams, Activity Diagrams, Sequence Diagrams and End to End Scenarios using UML. Created ETL specifications for data mapping.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Facilitated sprint planning, review, retrospective and daily scrum meetings, documented acceptance criteria, definition of done.
• Involved in State Unemployment Insurance Benefits
• Documented the unemployment benefits for eligible workers to meet their eligibility criteria under the State law like Unemployment insurance plans payments, benefits, temporary financial assistance to meet the requirements of State law
• Documented the Eligibility criteria for unemployment insurance, and their benefit amounts and the length of time by the State law under which unemployment insurance claims are established.
• Worked on benefit funding issues on taxes and filing a claim procedure and gave the appropriate output to the customers without any delay in their claiming process based on the client norms and eligibility criteria.
• Facilitated JAD sessions and created reports for budgeting finance and project Management.
• Presented the process improvement recommendations to executives, received appreciation, and implemented the optimized service process flows.
• Analyzed the sources and targets, transforming the data, mapping the data and populating the data into targets systems

Environment: Agile with Scrum, Requisite Pro, MS SQL Server, SharePoint, MS Visio, MS Office Suite, MS SQL Server, JIRA, HP ALM, ETL Tools

Confidential, Phoenix, AZ

Sr. Data Analyst

Responsibilities:

• Collaborating with business analysts and software development team for identifying and converting business goals into data requirements.
• Acquired data from different sources systems and maintained the database systems.
• Imported, sorted, cleaned, and transformed data according to business objectives by interpreting trends and patters in the complex data sets used SSRS/POWER BI for reporting analysis.
• Analyze query and manipulate data according to defined business rules and procedures.
• Performed root cause analysis for data quality errors and make recommendations for long-term solutions.
• Ensured data accuracy across application interfaces by documenting ETL(SSIS/SSRS) job process flow and communicating necessary application recovery procedures to team members and members of interfacing IT staffs.
• Improved correct data submissions by firms through expert ability to detect cause of bad data submissions.
• Ensured all the missing data of the required elements is captured by reviews.
• Served as a software tester to improve the usability, integrity and reliability of the company’s new database system. Designed the data sourcing and data flows for data quality analysis.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles. Developed complex T-SQL code for the application.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Used the ETL DataStage Designer and SQL Server Management Studio to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Checking Database Health by using DBCC Commands.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Generated reports using Global Variables Expressions and Functions using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard.
• Responsible for monitoring and tuning SSRS Report Performance.
• Documented problem resolution procedures, reducing future problem-solving time and contributing to staff knowledge base.

Environment: MS SQL Server 2012/2008/R2, SSIS 2008, SSRS 2008, T-SQL, OLAP Service, Visual Studio 2010,XML, HTML, SQL Server Profiler, Team Foundation Server, Toad Data Modeller, UNIX Shell Scripting, Quality Center.

Confidential, Raleigh, NC

Sr. Data Analyst

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files.
• Run the test cases written for integration and functional testing after the deployment of the databases on the DEVRSA environment.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
• Created store procedures, views, and tables and generated TSQL script for application.
• Used Visual Team Foundation server for version control, source control and reporting.
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
• Involved in code review, writing Unit test case, and creating a platform to run and validate these Test cases.
• Experience in analyzing test results and submitting the bugs using Bug Tracking Tool Quality Centre (QC) & Team Foundation Server (TFS).
• Master deployment tools. Utilize team tools for change management. Advocate for architecture and design concepts that can enhance performance and reduce maintenance costs.
• Mentor or act as subject matter expert in assigned technologies (e.g.: Octopus, Azure, etc.).
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS). Implemented Event Handlers and Error Handling in SSIS packages. Mining models and deploying and processing SSAS objects.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Advanced extensible reporting skills using SQL Server 2012/2014 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012/2014. Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements. Defined Key Performance Indicator metrics to create scorecards.
• Involved in designing Web based ASP.NET applications.
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes. Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.

Environment: Team Foundation Serve, SQL Server 2008/2005, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008.

Confidential, Irving, TX

SQL Server Developer/SSRS/SSIS/Data Analyst

Responsibilities:

• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Created complete documentation for the daily build process, daily loads and reports.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Designed dynamic SSIS Packages for Landing-Pad to transfer data between servers, load data from FTP, flat files, access and oracle into database, and archived data file from different DBMS.
• Involved in daily loads (Full & Incremental), Data Conversions into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
• Implemented SCD2 (Slowly changing Dimensions) by using different dataflow tasks in SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Used SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Used Cozy rock third party tool to generate Hash keys, to insert and update data in to data warehouse.
• Developed complex queries for generating drill down and drill through reports and worked with Parameters for parameterized and cascading parameterized reports in SSRS.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Designed and implemented stylish report layouts and various Report models on Views (due to security issues), deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Uploaded reports on to the report manager and organized them into folders.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Created reports which generate multiple named tabs in excel and created data driven and standard subscriptions for different users using Report Manager. Managed permissions in the Report manger through Role based security. Used Transparent Data Encryption (TDE) to encrypt sensitive data.
• Daily builds, merging, branching source code to different environments using Visual Studio Team System.
• Every day SCRUM meetings and two week sprint.

Environment: Windows Sever 2005/2008/R2, MS SQL Server 2008/R2, SSIS 2008, SSRS 2008, T-SQL, OLAP Service, HTML,SQL Server Profiler, Team Foundation Server, Toad Data Modeller.

Confidential, Houston-TX

Scrum Master/Agile Coach/Business Analyst

Responsibilities:

• Facilitated meetings, including creation of agendas and recording of action items from meetings, received, consolidated, and produced status reports for business constituents and steering committee, etc. using MS Word & PowerPoint in the JAD Session with SMEs and researched on the process flow application.
• Involved in both functional and technical team during analysis, design, development, testing and implementation. Configured candidate profiles and setup sections for languages, licenses & certifications
• Configured non-candidate profiles for competency clusters and use them to define job profiles and job codes Coached teams in organizational to help adopted Agile Scrum and Kanban practices and ensure execution and delivery to committed sprint work.
• Conducted 2-day Agile chartering workshop sessions for teams and educate them from ground zero to begin as new Scrum team where they received relevant agile training, as well as a user story writing workshop to kick off their projects
• Coached teams on story estimation and ensure sprint commitments are being met; help Product owner in breaking down user stories and writing acceptance criteria and on Artifacts such as Product Backlog, Spring Backlog, Sprint Burndown, and Release Burndown.
• Explained and practiced scrum ceremonies, grooming, sprint planning, sprint review, and sprint retrospective, daily stand-ups, etc.
• Established effective communication for the department with consistency across development and business management. Presentations, recommendations and updates provided regularly to the Director office.
• Ensured the development team is practicing the core Agile principles of collaboration, prioritization, team accountability, ownership and visibility.
• Created and maintained release burn downs, velocity projections and project forecasts in order to create project visibility and enable timely project adjustments.
• Publicizing the team's progress and successes to make sure they are highly visible to product owner/stakeholders. Complete management reporting (i.e. headcount reporting, employee satisfaction survey results) organize and track confidential employee information, forms and agreements relating to Human Resources. Developed reports from the data pulled from a large database and summarized for reporting purposes.

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), Windows XP/2000, Salesforce CRM 2011, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio, MS Word, MS Excel, MS Access, MS Outlook.

Confidential

SQL Server Developer /SSRS/SSIS (BA)

Responsibilities:

• Identifying and make recommendations for enhancements to the business issues and process challenges for the organization
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Created complete documentation for the daily build process, daily loads and reports.
• Conducted training sessions for end users on how to use adhoc reports using Report builder 2.0.
• Created logical and physical database design, data structures and maintained it by using Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked on Power Pivot to generate Ad-Hoc Reports based on end user requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using SSRS and Performance Point Server, and published them Via Microsoft Office Share point Server (MOSS).
• Performed Full and Differential backup with simple and bulk-logged recovery models.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results

Environment: SQL Server 2005/2008 MS VISIO, Windows Enterprise Server 2003,XML,Oracle 9i, SFTP, SSRS,SSIS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Visual Studio Team System 2008, SharePoint, LINQ.