SUMMARY:

• Nearly 7 years of experience in IT for organizations in India, Japan and USA. Experience working in teams as small as 5 and as large as 40. Extensively worked in SQL, PL/SQL,C++ and used databases like Oracle, Teradata, MS Access, SQL Server2005/2008. Involved in designing various reports/documents/dashboards using BI tools like Microstrategy, SSRS, Cognos. Sound knowledge of data ware housing concepts, data mining, ETL & data modeling. Interacting directly with End Users for requirement gathering. Responsibilities include identifying the area of process improvement and establish effective and efficient processes. In - depth understanding of all stages of software development life cycle (SDLC) like requirement specification, software designing and development, testing and maintenance. Excellent Communication and Presentation skills.

TECHNICAL SKILLS:

Data Warehousing Tools: Microsoft SQL Server Management Studio, SSIS, SSAS,TOAD, Teradata SQL Assistant 12.0

Databases: Teradata, Oracle 9i/10g, MS-SQL Server 2005/2008, MS-Access, IBM DB2

Languages: SQL, PL/SQL, C, C++, HTML,XML

Business Intelligence: MicroStrategy 9.4,1, SSRS, Cognos

Operating Systems: Windows 98, NT, XP, Vista, Macintosh OS, Windows 7 Professional

Software: Adobe Acrobat XI, Microsoft Outlook 2013, Lotus Notes, MS Office 2013 products, Cisco WebEx, Cisco VPN Client for Windows, Leech FTP, SSL, Sharepoint, Microsoft Visual Studio 2005/2008, SQL Server BI development Studio, PSPad, Oracle PeopleSoft, Oracle SQL* Plus, Eclipse, Windiff, WinMerge, Notepad++, Doxygen (documentation tool)

Configuration Management Tools: Microsoft Visual Source Safe, CVS, Rational Clear case, SVN

Defect Tracking Software Tools: Rational Clear Quest, Bugzilla

PROFESSIONAL EXPERIENCE:

BI Report developer

Confidential, Atlanta, GA

Responsibilities:

• To understand and maintain Entity Relationships between datasets
• Created functional documents for the project as per new enhancements
• Participated in meeting discussions related to design and development.
• Effectively handled and communicated with the offshore Teradata database team and ETL issues.
• Create, modify, test Datasets, documents & grid reports. Create schema & application objects in Microstrategy.
• Transform unstructured data from various sources using ETL to structured tables in database.
• Used Teradata SQL Assistant to validated report data by writing queries in SQL
• Fixing issues from UAT environment, creating turnover packages to move objects to QA/UAT environment.

BI Analyst

Confidential, Santa Fe, NM

Responsibilities:

• Work with school coordinators and application developers to identify business needs and discuss solution options.
• Creating /Modify existing design documents for the same and get it approved from the Project Manager.
• Analysis of raw datasets from different sources to structured tables in data ware house.
• Validate reports by SQL test scripts against SQL server 2008 database
• Extensively used Business Intelligence tools like SQL Server Reporting Services (SSRS) to create reports for Federal and State Govt.
• Support PED's ARRA reporting using data related to professional licensure, teacher quality, staff development and school budget in support of dissemination of state-appropriated monies to school districts
• Provide SQL Server 2008 database coding to support business applications using SQL queries

BI Report Developer

Confidential

Responsibilities:

• Creating requirement gathering design documents as per Client needs
• Document source schema for other team members .
• Create reports in SSRS for end users. nsure best practices are applied and data integrity is maintained through security, documentation, and change management
• Provide communication with the customer/client to address any concerns.
• Create to source to target mapping and identify relationships.
• Ensure the understanding and complete requirements with the help of development and quality assurance team members.
• Organizing unstructured data to tables in data warehouse using SSIS.
• Identifying test scenarios, creating test plan & writing test cases
• Validate data with test SQL scripts to follow QA standards
• Creation of Logical Data & Physical Data Model and schema analysis
• Source to Target Mapping, Creation/ Population of Look up Tables and Fact Tables in Oracle 10g
• Documented and maintained database system specifications, diagrams, and connectivity charts
• Understand and the Entity Relationship models.

Confidential

Trainee

Responsibilities:

• MicroStrategy Desktop: Reporting Essentials
• MicroStrategy Architect: Project Design
• MicroStrategy Desktop: Advanced Reporting
• MicroStrategy Intelligence Server Administration
• MicroStrategy Administrator

Software Developer

Confidential

Responsibilities:

• Customization of Illumination Device Driver for a handset launched in market
• Solving bugs reported, Debugging and testing, Integration and Delivery of the module to Integration team
• Follow Software Development Life cycle and it’s methodologies
• Provide Power point presentations for team discussions with Client.
• Provide Knowledge transfer sessions to new fresh graduates