SUMMARY

• Over 6 yrs of experience in business analysis, project management, Database Analysis, Design, Development and Business Intelligence of Microsoft SQL Server 2008/2012/2014 in Development, Test and Production Environments. Proficient in testing Client - Server & Web-based applications on Windows and UNIX platforms.
• Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Management Life Cycle (DMLC).
• Experience in different Testing Methodology like Waterfall and Agile (Scrum).
• Extensive experience in data extraction, transforming and loading (ETL) using SQL Server Integration Services (SSIS), creating various packages depending on user requirements.
• Experienced in creating reports for business analysis and management purposes using SQL Server Reporting Services (SSRS), Tableau.
• Experience in using different platforms for generating data such as TOAD, Teradata studio, SQL Assistant, SSMS, IBM Data Studio
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Excellent knowledge in the use of T-SQL for developing stored procedures, triggers, tables, Views, Group By, and Joins.
• Highly proficient in transferring data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and had experience with large amount of data.
• Strong with Analysis skills using Query Analyzer, SQL Profile manager and Engine Tuning Advisor.
• Knowledge on Data warehouse in designing and building the dimensions and cubes with star schema using SQL Server Analysis Services (SSAS) with OLAP.
• Experience in database maintenance using performance monitor, loading, experience of installation/upgrade, backup/restoration, alerts and schedules.
• Knowledge in relational database management systems (RDBMS), data warehousing, ETL process and multi-dimensional models.
• Strong with Microsoft office tools especially with Excel in creating lookups, Pivot tables and more. Good Knowledge and experience on SharePoint.
• Ability to work effectively independent and with a team. Can work as self-starter and highly organized.

TECHNICAL SKILLS

Project Methodologies: SDLC, Waterfall, Agile - Scrum, V - Model.

Languages: T-SQL, PL/SQL, VB Script, HTML, XML

Analytical Skills: Gap Analysis, Reporting, Documentation, Data Review, Risk Assessment

Tools: SSMS (SQL Server Management Studio), Business Intelligence Development Studio (BIDS), DTA, SSAS, Microsoft Office, MS Visio, MS Project, Qlikview 11, SOAP UI, Tableau, CA Agile Central (Rally)

Operating Systems: Windows XP/2000, Linux, MACINTOSH OSX

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

PROFESSIONAL EXPERIENCE

Confidential, TN

SQL Developer/ Data Analyst

Responsibilities:

• Gathered requirements from business users and prepared functional and technical documents.
• Involved in day-to- day affairs of the project delivery aspects by participating in Sprint Planning, Scrum meetings,and other business communications with the client.
• Written dynamic SQL scripts in SQL server management studio (SSMS).
• Used Try catch block, Merge and Common table expressions in T-SQL.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012 from different environments.
• Created the SSIS /DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Experienced in handling migration of existing reports using Power BI.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Responsible to follow up the production issues with offshore team.
• Lead agile model Scrum meetings and providing directions to team.

Environment: MS SQL Server 2012, Teradata SQL Assistant, Excel, Toad, DB2, Oracle, Teradata Express Studio, IBM Data Studio, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, SharePoint 2012, Report Builder, MS Access

Confidential, Foster City, CA

SQL Server Data Analyst

Responsibilities:

• Work in the Agile development environment and participated on standup and retrospective meetings.
• Generated matrix reports, drill down, drill through, sub reports and multi parameterized reports.
• Formatted the reports using the Global variables and expressions.
• PerformingDataanalysis on large, complex datasets; summarizing and presenting findings to clients and internal team members.
• Created reports to retrieve data using Stored Procedures accept multivalued parameters
• Used SQL and HSQL databases to check inserted data and developed queries to get data from different tables. Used Hibernate framework to connect with database and to retrieve the data also to store the data in database.
• Used SharePoint to assign permissions and to create report schedules based on particular day and sent them through Email in required format.
• Developed SSIS Packages to validate on row counts, identity value and column counts after Data transfer.
• Designed and created different ETL packages using SSIS from Oracle source to SQL Server as destination.
• Worked on the performance tuning of SSRS reports.
• Worked with the DBA to create environment for analysis.
• Created functions and procedures in T-SQL involving complex joins, CTE and sub queries to check the integrity and consistency of data.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for analysis.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: MS SQL Server 2012, (SSIS) SQL Server Integration Services, T-SQL, (SSRS) SQL Server Reporting Services, SQL Report Builder, SharePoint 2012

Confidential, San Jose, CA

SQL Developer

Responsibilities:

• Used T-SQL for developing stored procedures, triggers, tables, Views, Group By, and Joins.
• Creating, modifying SSIS packages to extract, transform and load data from heterogonous networks.
• Extensive use of excel as a reporting tool and data comparisons. Expertise in using advanced excel techniques.
• Documented operating procedures for various complex tests which uses large amount of data.
• Worked on the DB2, Teradata, SQL Server, Oracle and MS Access databases to pull the data for testing requested by Control functions.
• Performed validations on the tests to ensure the data pulled is correct.
• Implemented logics to pull the data from Teradata and Oracle databases.
• Worked on large complex data sets, formatting and presenting the spreadsheets and have good Knowledge on Excel.
• Deployed and managed reports on Share point server.
• Used SharePoint site to request the access for different data sources, databases and many reporting tools.
• Worked on Teradata SQL Assistant, IBM Data Studio and Toad.

Environment: UNIX, SQL, Oracle, Web Services, Oracle Quality Center, QTP, Agile methodology

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements from Business and documented them based on functional specifications.
• Created Database objects including Tables, Triggers and Views.
• Set database access privileges for different users and user groups.
• Involved in programming module screens like Employee, Work Assignment etc.
• Monitoring SQL Server activity through profiler.
• Query tuning and optimization through T-SQL.
• Design and implementation of database maintenance plan.
• Performance optimization and normalization of database
• Designed database schema validation tool using stored procedures
• Migrated data from Access, Text file to SQL Server through DTS
• Worked Tuning and optimizing queries and indexes.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, TOAD, UNIX, Windows, Waterfall, MS-Excel, Performance Tuning, Mainframes

Confidential

Jr SQL Developer

Responsibilities:

• Collected and documented business processes as well as business rules.
• Gathered Requirements through requirement analyze sessions.
• Used MS Project to maintain the project schedule and track its status.
• Worked on Gap analysis. Also worked on current flow and future state diagram.
• Assisted in developing test scenarios, test scripts & test data to support unit & system integration testing.
• Assisted the Project Manager in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server
• Developed timelines for project delivery, and managed projects and resources for successful completion
• Helped the product owners to come up with set of stories for better understanding for estimate and development.
• Worked Closely with Users and Sponsors gathering Business and Functional requirements, also working closely with Development team, Test team and UAT team. Reviewed Systems document, Test Plan and Test Cases.

Environment: Quality Center, Quick Test Professional, SQL Server 2005,Altova XML Spy, Microsoft Office, Microsoft Outlook.