PROFESSIONAL SUMMARY:

• Over 8 + years of IT Experience in D Confidential Analysis, Business Analysis, Development, Business Intelligence, Testing, Compliance, administration, support and migration ofMicrosoft SQL Server d Confidential base.
• Expertise in all phases of Software Development Life Cycle (SDLC) including analysis, physical and logical design, resource planning, code development, testing, validation, implementation and maintenance.
• Expertise in working with executives, managers, and business stakeholders to determine their business requirements and processes.
• Experience in Requirement gathering, Functional, Technical specifications, System analysis, Design, Development, Testing and Implementation of client/server and web - based applications.
• Experienced in Technical writing to create Business Requirement Documents (BRD), Functional Specification Document (FSD) and use cases specifications.
• Good Knowledge on process modelling using UML (Use cases, Sequence Diagrams, Activity Diagrams, etc.)
• Excellent Team player to work with multiple teams at same time like with testers (QA), developers, and other team members in validation and testing of complex scenarios and maintenance of quality standards of the projects.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
• ExceptionalT-SQL Scriptingfor creating various d Confidential base objects likeStored Procedures, Functions, Triggers and Views.
• Expert in creatingSSISpackages to manageSQL Serverd Confidential bases andSQL Serverobjects between instances ofSQL Server.
• Experience inPerformance TuninginSSISpackages by using Row Transformations, Block and Unblock Transformations.
• Expertise in creating and managingEvent Handlers, Package Configurations, Error Handling, Logging, SystemandUser-defined VariablesforSSISPackages.
• Experience in developing and deployingcomplex Drill-Down reports, parameterized reports, Cascaded reports, Dynamic ReportsusingSQL Server Reporting Services(SSRS).
• Good knowledge of D Confidential Marts, D Confidential warehousing, Operational D Confidential Store (ODS),OLAP, D Confidential Modeling like Dimensional D Confidential Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Proficiency in creating different types of reports such asParameterized,Cross-Tab,Linked, Drill through, Drilldown reports, Top N, Sub reports, and formatting them usingSSRS.
• In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.
• Energetic, quick learner, multi-task ability with exceptional problem solving and attention to detail.
• Self-motivated, organized and attention to time and deadline management.

TECHNICAL SKILLS:

D Confidential bases: MS SQL Server 2014, 2012, 2008 R2/2005 Oracle 9i/10g, MS-Access - 2007

ETL Tools: SQL Server Integration Services (SSIS), D Confidential Stage, DTS, SQL Server Analysis Services (SSAS).

Operating Systems: Windows 2012R2/2008/2003 Advanced Server, Windows NT 4.0 / 3.51, and have necessary knowledge of Linux operating system.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 8/10, Excel Pivot.

Programming Languages: T-SQL, C, C++, C #.Net, VB.NET, Visual Basic for Applications (VBA), XML and MDX.

Internet Languages: JavaScript, XML, HTML, SOAP, REST, XSL, XSLT.

D Confidential base Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler, D Confidential base Engine Tuning Advisor (DTA).

Other: Microsoft Office, MS Project, MS Visio, MS LYNC, SQL Loader, DB visualize, TFS, Quick Test Professional (QTP) and Quality Center (QC).

PROFESSIONAL EXPERIENCE:

Confidential

Senior Analyst

Responsibilities:

• Worked as a team lead along with 8 others for a team of ~125associates.
• Worked closely with Senior leadership team members, managers and developers.
• Handled many tasks to enhance the process and special projects.
• Extensively worked and completed archiving process (task to analyze and decision files that can be archived from share drive to web storage) by coordinating 45 associates to learn and work on it.
• Advised on process improvements and “best practices”.
• Document all d Confidential mapping and transformation processes in the Functional Design documents based on the business requirements.
• Created new reports based on requirements.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the d Confidential mart.
• Re-wrote numerous procedures to conform to documentation standards as well as for clarity.
• Created numerous procedures from scratch (including extensive screenshots).
• Re-wrote SQL code for efficiency and changes.
• Created SQL queries for tests from scratch.
• Worked with SQL Queries using joins to facilitate the use of huge tables for processing several records in the d Confidential base.
• Experienced in writing and using Stored Procedures, Stored Functions, D Confidential base Triggers and Packages using SQL.
• Extensively used SQL for accessing and manipulating d Confidential base systems.
• Worked on modifying and executing many codes to pull required d Confidential from Terad Confidential warehouse.
• Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business d Confidential documents.
• Designed and implemented d Confidential integration modules for Extract/Transform/Load (ETL) functions.
• Experience with various ETL, d Confidential warehousing tools and concepts.
• Responsible for creation of SSIS Packages for D Confidential Population into Staging and Dimension area.
• Worked on ETL Automation Testing Tools through SSIS on the Side lines to easy the Testing of D Confidential Population for our Testing.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Worked with Technical Experts to Improve Report Performance and performed System testing.
• Worked with the developers during coding and while doing the remediation of the test.
• Maintained a close and strong working relationship with teammates and management staff to achieve expected results for the project.

Environment: MS SQL Server 2008/2012, T-SQL, Terad Confidential SQL Assistant, Express Studios, Toad, SQL Server Integration Services, Management Studio, SQL Server Reporting Services (SSRS), Statistics, SAS and Analytics, C#, .Net, OLE DB, SQL Server Profiler, SharePoint and Windows.

Confidential

Senior Analyst

Responsibilities:

• Involved in requirement analysis and design.
• Involved in d Confidential solutions in support of advancedd Confidential analytics enabling the transition from log management to broader analytics.
• Extensively worked on ETL Load (SSISPackage), report creation and d Confidential visualization includingdashboardsandreports leveraging charts(Pivot tables), gauges and drill-through.
• CreatedSQL Agent Jobsto schedule jobs for extracting d Confidential from different source systems using SSIS packages. Stored Procedures are used within these packages to aggregate the d Confidential .
• CreatedSQL Server Traces in SQL ServerProfiler, to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Create on demandAd hoc reports, Parameterized reports, linked reports, Snapshot reports, Drilldown reportsandSub reportsusingSSRS.
• Created numerousSSISpackages (ETL) to migrate d Confidential from different server locations and heterogeneous sources likeExcel, CSV, flat file, XMLandText Format D Confidential .
• Implementing custom analytics and reporting tools to assist clients in market analysis (SAS, Tableau).
• Performance tuning of SQL queries and stored procedures usingSQL ProfilerandIndex TuningAdvisor.
• Transformed d Confidential from various d Confidential sources usingOLE DBconnection by creating various SSIS packages.
• Migrated d Confidential from different source locations toDev / QAenvironment usingSQL 2008 SSIS packages.
• Created SQL Server Traces in SQL Server Profiler, to collects a variety of information about SQL Server connections, stored procedures andTransact-SQLstatements.
• Created complex stored procedures, triggers, cursors, views, user-defined functions, SQL Server Traces inSQL Server Profilerto collect a variety of information aboutSQL Servertransactions, server performances andTransact-SQL (T-SQL)statements.
• Executed test scripts, documented defects and verified fixes using bug tracking system BI designer / development / production team.
• Manually performed transcript d Confidential verification obtained from the client's d Confidential base to validate the integrity of the application.

Environment: MS SQL Server 2008, T-SQL, SQL Server Integration Services, Management Studio, SQL Server

Confidential

Analyst

Responsibilities:

• Key contributor in technology, strategy, andd Confidential mapping discussions to refine and enhanced Confidential migration processes.
• Responsible ford Confidential migration from disparate sources to structuredd Confidential warehouse in SQL server.
• Developedd Confidential integration solutions using SSIS.
• Lead Engineer ford Confidential quality process implementation.
• Designed automated processes ford Confidential validation utilizing SQL Server d Confidential base administration duties such as writing stored procedures and developing SSIS packages.
• Directly responsible for d Confidential validation.
• Successfully delivered validation results to ensure expedient and corrective actions are taken befored Confidential quality issues.
• Create d Confidential bases or reports that report on or follow file movement, production, or specific requestedd Confidential . Execute per-definedd Confidential queries to augment reports, validate results, and provide draft report review. Retrieve information from systems as part of task completion.
• Create new reports for management to help track workflow and simplify processes. Organized collected information andd Confidential into usable formats.
• Retrieve relevant information and create reports that summarized Confidential in an appropriate format.
• Document a wide array of information, from simple to complex, including operating procedures, materials, job aids, or management reports.
• Translated functional requirements fromSeniorManagement into actionable technical specifications for report migration solution.

Environment: MS SQL Server 2008, T-SQL, SQL Server Integration Services, Management Studio, SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), Statistics, SAS and Analytics, C#, .Net, OLE DB, SQL Server Profiler, MOSS, SharePoint and Windows.

Confidential

Analyst

Responsibilities:

• Performed report tests and maintainedd Confidential warehouse.
• Analyzed raw d Confidential in Excel and organized into desired format.
• Ensuredd Confidential integrity, quality assurance testing, resolved issues.
• Produced weekly, monthly ad hoc reports.
• Performedd Confidential query, extraction, compilation, and reporting tasks.
• Developed test strategies and plans and implemented all test scripts.
• Designed and implemented d Confidential integration modules for Extract/Transform/Load (ETL) functions.
• Experience with various ETL, d Confidential warehousing tools and concepts.
• Responsible for creation of SSIS Packages for D Confidential Population into Staging and Dimension area.
• Translated functional requirements fromSeniorManagement into actionable technical specifications for report migration solution.
• Presented findings and recommendations to team, clients and management.

Environment: MS SQL Server 2008, T-SQL, SQL Server Integration Services, Management Studio, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Statistics, C#, .Net, OLE DB, SQL server Profiler, MOSS, SharePoint and Windows.