SUMMARY:

• 5+ years of IT experience in Database development and support, data analysis, Business analysis and testing.
• Development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.
• Extensively worked to Create DDL scripts, database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Expert in data modeling and database schema design using Erwin.
• Experience with SQL server reporting Services to generate different reports such as parameterized, drill down, Sub report, Link Report, Multi parameterized report etc. as per client’s requirement.
• Experience in creating SSIS packages.
• Experience in creating test cases and tickets using JIRA.
• Good Experience in resolving client’s issues related to application and database and supporting application.
• Extensive knowledge and experience in Agile and Waterfall Methodologies of Software Development Life Cycle.
• Extensive knowledge of Microsoft Excel for data analysis and data manipulation. Strong analytical and problem solving skills.
• Streamlined the data collection process for a more efficient way.
• Extensive user of Excel Pivot tables and VLOOKUP for data disaggregation.
• Perform quarterly extracts, compile and update the monitoring tool and present reports to the team.
• Provide Ad - Hoc query support, which includes custom report generation and data analysis, to internal team and client.

TECHNICAL SKILLS:

Database: Oracle9i/10g, SQL server 2008

Languages: PL/SQL, c#.Net, SQL

Operating system: Windows Server 2003/2008, Windows 7/Vista/XP

Tools: Microsoft Visio, Microsoft Project, JIRA, Notepad++, Visual studio 2008 and 2010, Sharepoint, BugZilla, ErWin, PG Admin III

Markup Languages: HTML, CSS, JavaScript, XML

Version Tool: TFS, GIT

Database tools: Microsoft Business Intelligence Studio (SSRS and SSIS), PL/SQL Developer, MS SQL server 2008, MS SQL server 2008R2

PROFESSIONAL EXPERIENCE:

Confidential, RESTON

Responsibilities:

• Working as a Database Developer to support a Data analyst project.
• Developed procedures, functions also wrote complex queries.
• Developed automation jobs for getting and uploading data using .Net 3.5 Framework.
• Evaluated, analyzed, researched and processed incoming data to provide the inputs to the customer.
• Working on GreenPlum to create scripts.

Confidential

Database Developer/Data Analyst

Responsibilities:

• Designed and developed Queries, Stored procedures, functions, Views, Materialized Views and triggers also generated different reports using SSRS.
• Involved in preparing Logical Data Models/Physical Data Models using Erwin.
• Assist with running queries for reports to find common areas of error to fix.
• Combine and analyze data across multiple Excel spread sheets and worksheets.
• Created packages using Integration Services (SSIS) for extracting data from flat files.
• Analyzes data for accuracy and notify management of inconsistencies in reporting based on department trends.
• Performed string manipulation using various string functions like instr, substr.
• Coordination with onsite counterpart as well as client. Actively involved in efforts estimation, unit test-case preparation and release activities.

Confidential

Responsibilities:

• Developed procedures, functions and packages also wrote complex queries.
• Used SSRS for creating different visual and data reports.
• Develop and initiate more efficient data collection procedures.
• Evaluated, analyzed, researched and processed incoming data to provide the inputs to the customer.
• Contacted and interacted with others to acquire source documentation, rectify discrepancies in the data, and responded verbally and through written means to inquiries/special requests.
• Used data analysis techniques to validate business rules and identify low quality missing data.
• Optimize queries using Execution plans and other techniques like Indexing, partitioning etc.
• Used GIT and Source Tree for the Code repository.
• Participated in UAT (User Acceptance Testing) where I helped user with the queries he had.
• Created impact analysis tool to help developers and BA’s to understand the impact of new requirements and to estimate the total time to work on them. This too helped them to provide the proper impact analysis to the client in less time.

Confidential

Responsibilities:

• Designed Views, Tables, Procedures and Functions also processed various sources of data and designed reports using MS SSRS.
• Created complex queries to handle the business validations.
• Created and Backed up Database populating with corresponding data for different stages of Testing.
• Extracted, compiled and tracked data and analyzed data to generate reports.
• Created different reports as per customer request using SSRS.
• Improved the performance of the queries by tuning the queries using indexing, partitioning etc.
• Extracted, compiled and tracked data and analyzed data to generate reports.
• Used Microsoft Team Foundation Server for code repository.
• Knowledge in Oracle utilities like SQL*Loader, Export/Import.
• Daily status sharing with the customer. Maintained the track if the patches sent on production from Production Support as well as Change Request team.
• Used BugZilla to keep track of bugs raised during testing.
• Developed Ticket tracking tool which team used for preparing daily status report and implemented email functionality.
• Created Patch tracking system to maintain the production patch details and to provide the reports to the management team and client whenever required.