SUMMARY:

• 8 years of experience in all the phases of Software Development Life Cycle (SDLC) especially in Analysis, Design, Coding, Testing, Deployment and Maintenance.
• Expert communicator (written, verbal and presentation) involved in high level interaction and influence with variety of audiences (Senior Executives, Clients PMs, SME).
• Experience analyzing and documenting project scope documents and SOWs, project plan, project/ requirement change request forms, BRD, FRD, SDD, requirement traceability matrix, use cases/sequence diagrams, UML, wireframes/mockups, end user documentation and BPM notations.
• Experience in MSBI projects with extensive usage of ETL using SQL Server Integration Services (SSIS) & Reporting tools like SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
• In - depth knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN and P.
• Proficient in creating complex Stored Procedures, Views, Functions, Triggers, Cursors, Tables, Indexes, Common Table Expressions (CTE) etc.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in Installation, Configuration, Development, Deployment and Troubleshooting Reporting services using SSRS across various environments.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Good experience in developing Drill Down, Drill Through, Cascading, Multi Valued Parameterized reports, table, matrix, charts, sub reports using SSRS.
• Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports.
• Experience in writing MDX queries using SQL Server Analysis Services (SSAS).
• Good knowledge in optimizing queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, Database Engine Tuning Advisor, SQL Performance Monitor and Execution Plan.
• Experience working with agile methodology, waterfall models.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2014/ 2012/ 2008 R2/ 2008/ 2005, Oracle

Tools: SSMS, BIDS, Microsoft Visual Studio, MS Office, MS Project, SnagIt, SharePointControl M

Programming Languages: T-SQL, PL/SQL, MS SQL, MDX, HTML, XML, C#.NETADO.NET, ASP.NET

Business Modeling Tools: Rational Rose, MS Visio

Tools: Rational Requisite Pro

BI Tools: SSIS, SSAS, SSRS, Crystal Reports, Report ManagerReport Builder, Power Pivot, Power View in MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, CA

MSBI Developer/ Data Analyst/ Business Analyst

Responsibilities:

• Involved in defining scope of the project along with vision statement.
• Coordinated and tracked project communications and maintained project schedules and milestones.
• Researched and evaluated current processes/policies and presented findings and recommendations to team.
• Ensured enhanced processes and services are technically, operationally, and legally supported by analyzing and compiling business requirements solidifying successful implementation.
• Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
• Accumulated customer requirements from various end users through surveys, interviews, focus meetings and analyzed the requirements.
• Conducted Joint Application Development (JAD) sessions throughout SDLC between stakeholders and the MiSiS team.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Worked directly with clients/ subject matter experts (SMEs) in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands on analysis and coordinating with the other teams.
• Created technical documents for various reports, interfaces and for few UI related complex stored procedures.
• Created functional, technical and system requirement documents for MiSiS.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams in Rational Rose.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the requirement and managed them using Rational Requisite Pro.
• Performed manual front-end testing to check all functionalities of different modules.
• Initially the project followed Agile methodology. Currently it is following a new process introduced by Microsoft called BSR (Build Stabilize and Release).
• Creating Database objects - Tables, Views, Functions, CTEs and developing complex stored procedures for implementing application functionality at the database side for performance improvement.
• Creating complex SQL queries for data fix scripts as part of Data Cleansing activity.
• Query tuning and optimization of SQL queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Experience in Code Optimization, analyzing execution plan and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures, transactions and index analysis, identification of grey areas/ bottlenecks.
• Creating SQL Agent Jobs to schedule SSIS package and configuring SQL Mail Agent to send alerts for successful or unsuccessful completion of scheduled jobs.
• Migrated all jobs from SQL agent to Control M for better job scheduling and tracking.
• Created SSIS packages to load data into Staging database and Data Warehouse using heterogeneous sources like Oracle, Flat file, CSV, MS Access, Excel and SQL.
• Analyzed, Developed/ Modifying ETL packages to enable the integration aspects and migration of legacy data from different sources such as CSV, Excel, Flat file, Oracle, MS Access, MS SQL server to MISIS database to enable Confidential to use legacy data for MiSiS application and reporting.
• Extensively used various SSIS objects such as Dataflow Components, Control Flow Elements, Connection Managers, Runtime Events, Log Providers etc.
• Generated packages using different Transformations like Lookups, Aggregate, Derived Column, Merge Join, Fuzzy Lookup, Pivot, Unpivot, Conditional Split, Union All, Multicast, Data Conversion, Script component and control flow components like Sequence Container, For Loop, For Each Loop, Execute SQL Task, Script task, Send Mail Task, File System Task, Bulk Insert Task etc.
• Created complex packages using Break Points, Check Points, Logging, Transactions and Package configurations in SSIS.
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Deployed SSIS Packages to various environments and used Package configuration to export various package properties to make package environment independent.
• Developed complex stored procedures as per project requirement for enrolling students and withdrawing students from schools (Next Year Enrollment and No-Show process).
• Reduced the run time of complex stored procedures, one of the best would be from 15 hours to 18 minutes.
• Configured the report viewing security for various users at various levels using Report Manager.
• Created ad-hoc queries/stored procedures from SQL Server databases for custom reporting needs.
• Extracted, compiled and tracked data, and analyzed data to generate reports.
• Created different type of SSRS reports including Tabular forms, Cross-Tab, Conditional, Adhoc, Matrix, Drill down, Drill through, Summary, Cascade, Multivalued Parameterized report, Charts and Sub Reports.
• Improved performance of report by creating cache and snapshot.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Created SSAS cubes (dimensions, perspectives, hierarchies, measures groups).
• Created SSIS packages and used Analysis Services processing task to update/process the cube with current data.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Organized project tasks, managed team workflow and project scheduling using Team Foundation Server.
• Maintained database authentication modes, creating of users, roles, configuring permissions and assigning roles to users.
• Responsible for meeting deadlines with quality development and resolved production support issues.

Environment: Microsoft SQL Server Management Studio 2014/2012/2008 R2, Control M, Microsoft Visual Studio 2013/2012/2010, SSRS, SSAS, SSIS, BIDS, T- SQL, MDX, MS Office Tools, Rational Requisite, Rational Rose, UML, TFS, SharePoint

Confidential, CA

MSBI Developer/ Data Analyst/ Business Analyst

Responsibilities:

• Interacted with subject matter experts, business users, program directors extensively in gathering the requirements and translated them into specifications.
• Conducted Joint Application Development (JAD) sessions with the end users to discuss and resolve open issues.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL to extract, filter and validate data.
• Defined and documented complete and clear detailed functional specifications and business requirements using the SDLC methodology.
• Prepared Business Requirements Document (BRD) and used Requisite Pro to manage, analyze, and convert business requirement into functional requirements.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams in Rational Rose.
• Used MS Word, MS Excel, MS Access, MS Project, MS Visio for documentation and analysis reports among other project management and reporting tools.
• Created database objects - Tables, Views, Functions and developed complex stored procedures.
• Created and modified T-SQL Stored Procedures/Triggers for validating the integrity.
• Performed query plans and verified every query is using appropriate useful indexes.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Understanding the report design Requirements and Constraints.
• Migrated data from heterogeneous data sources and legacy system to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Developed and maintained ETL jobs for the Data Warehouse using SQL Server Agent.
• Deployed the created SSIS packages in Development and Testing environments.
• Developed tabular, matrix, chart, Drill-down, parameterized and cascading reports (SSRS).
• Developed Custom/Conditional formatting reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Promoted RDLs to Reporting Service Server (SSRS).
• Created Adhoc reports and data exploration using Power View.
• Scheduled Backups and performed restore operations for test data.

Environment: MS SQL Server Management Studio 2012, Query Analyzer, SQL Profiler, MS Visio, MS Project, Index Tuning Wizard, TFS, SSIS, SSRS

Confidential

MSBI Developer

Responsibilities:

• Gained in-depth knowledge with requirements gathering, analysis, design, development, change management, deployment and user training.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Created Tables, Stored procedures and defined functions, created SQL scripts for tuning and scheduling.
• Designed Star schema (identification of facts and dimensions) and Snowflake schema.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Performing Replication (snapshot and transactional).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Generated periodic reports based on the statistical analysis of the data and various operational, drill-through and drill-down reports using SSRS.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining user group roles and granting the privileges to users and Groups and maintaining security up to date.

Environment: SQL Server 2008/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, T-SQL, MDX, XML, MS Excel and MS Access

Confidential

SQL Developer

Responsibilities:

• Developed many Stored Procedures, Functions, ad hoc queries, Common Table Expressions (CTEs) to facilitate efficient data manipulation and data consistency using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Tested the stored procedures performance and its path of execution by using SQL profiler.
• Assisted senior MS SQL developer in debugging complex scripts.
• Performed Unit, System Testing and created several Test Cases to validate the data.
• Effectively analyzed the business needs to translate the needs into deliverables.

Environment: MS SQL Server 2005, T-SQL, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS Excel and MS Access