SUMMARY

• More than 12+ years of Database and Reporting experience.
• Used Oracle, SQL Server and Access Schema to create Physical data Model Design. I have Normalized and De - normalized Database.
• Created Database, Tables based on Model and have Test ER and Data writing SQL Scripts.
• Created Data Dictionary in Excel and in Database.
• Extensive DDL and DML statements.
• Set with business to gather requirements.
• Extensive experience in Production support where I provided tire 2 supports to end users in most of my projects.
• Extensive experience in SQL Server 2000/2005 servers.
• Involves in data/process, migration SQL Server from SQL 2000 to SQL 20005/2008, Physical and Logical Design of Databases.
• Managed and served all internal SQL Server 2000/2005 databases; relational databases (OLTP) and data warehouse (OLAP).
• Worked closely with .Net developer created and change database wrote procedure using TSQL.
• Perform database management tasks including: Creating SQL Views, SQL Script, Stored Procedure, Function and Triggers.
• Worked in some of internet technologies like html, JavaScript and others.
• Experience on writing Business Requirements, Analyzing and Developing Crystal Reports.
• Providing Business Intelligence solutions in Data Warehousing, source system analysis, data extraction from various sources like relational database, flat files using ETL Tool Informatica PowerCenter 9.0.1.
• Good knowledge of Informatica PowerCenter tools Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse. Good knowledge and understanding of Data warehousing concepts like Star schema, Snow-flake schema, Dimensional Data Model, Slowly Changing Dimensions, Inmon and Kimball Approach. Preparing documentation for various processes to meet the business needs
• Excellent problem solving skills with strong technical background and good interpersonal skills and ability to meet deadlines and work under pressure.
• Demonstrate attention to detail and possess strong organizational skills; Able to prioritize multiple tasks; Reliable and adaptable;
• Take initiative and readily accept new responsibilities; Skilled in conducting needs assessment, detailed analysis and problem solving; Work well individually or as part of a team.

TECHNICAL SKILLS

Business Intelligence Reporting Tools: SAP Business Objects version 6.5.1(Designer, ReporterSupervisor), BCA Scheduler and Publisher, Auditor, Business Miner, Business Query and Document Agent Server, WebnIntelligence and Info View, Crystal Reports 2008/XI

RDBMS/Databases: Oracle 11gR2/10g/9.i (SQL, PL/SQL, Stored Procedures, Triggers Function), SQL SERVER 2000 and 2005 (SQL, TSQL, ProcedureFunction), Microsoft Access

ETL Tools: Informatica Power Center 9.0.1, SQL*Loader, PL/SQL Developer JDeveloper, Oracle SQL Developer, Toad 9.0

Languages: SQL*Plus, PL/SQL, UNIX Shell Scripts, HTML, DHTML, C, C++VB 5.0/6.0, Java.

Operating Systems: UNIX (Sun Solaris), Windows NT/XP, WIN 2000

Data Modeling: Erwin 4.0, Visio

Applications: Microsoft Excel, PowerPoint, Word, Visio

Software: iMIS, CAS 3.1,Home Site, DD&C Ctrix2, DD&C Report Writer 7.1FoxPro 6.0, Stylist, Personator(Smart Marketing Suit), Mailer 4Powerseller (Infomaker), Millennium (Gallagher), FNMA-MornetFreddie Mac-Midanet, CPI & CRT, Brooks, D/U & LP Brooks

Bug Tracking Tool: JIRA, TestDirector 8.0, Microsoft System Center 2012 (Service Manager)

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Database Analyst/ ETL Developer

Responsibilities:

• Create/modify Stored Procedures, Triggers Function, and Views, Sequence
• Gap analysis for new application and database migration in three different databases.
• Data mapping for source to target.
• Modify existing tables to comply with business need.
• Work with DBA and System admin closely for database and application performance.
• Data analysis, ad-hoc query and reporting to support business needs.
• Data manipulated using DML.
• Used DDL to create and alter new tables.
• Periodic data integrity validation.
• Perform data extracts on a nightly basis.
• Produce Quota Progress reports for each region.
• Analyze and identify data related issues and recommend solutions for corrective measures to the business owner.
• De-dup case and person data.
• Provide data extracts to produce Quota Progress reports on weekly, monthly, quarterly and annual basis
• Data Cleanup: Identify data cleanup tasks and provide case-level information by region to business owner for distribution to field staff;.
• Validate data cleanup tasks against TAAMS and TFAS data to verify if assets exist to ensure appropriate updates are made.
• Perform data cleanup tasks as approved by business owner and field staff by updating case information within ProTrac.
• Developed Informatica mappings in Informatica Power Centre 9.1, to load the data into Oracle database, from various source systems, using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression and Filter, according to the Business requirements.
• Created Informatica ETL code from functional and technical specifications and documented all ETL code with proper changes.
• Majorly involved in Data profiling activities in order to send a more refined data for the ETL process in order to carry out the ETL operations smoothly.
• Produce weekly and monthly data extracts from ProTrac.
• Import weekly and Monthly data extracts from TAAMS and TFAS using Access.
• Wrote MS-DOS batch (.bat) files to load data.
• Understand business requirement as per the functional and technical specifications, responsible for project deliverables, issue identification and resolution.
• Created report specification form for can and ad-hoc reports.
• Gather report requirements from end users.
• Create Universe.
• Converting Daily, Monthly, Quarterly and Year end reports from Crystal reports to SAP Business Objects 9.0.1. (Designer, Reporter, Supervisor BCA Scheduler and Publisher, Auditor, Business Miner, Business Query and Document Agent Server, Web Intelligence and InfoView).
• Modify existing reports and create new reports in BO.
• Create and implement data retrieval store procedures, views for Reports.
• Modify and create Crystal Reports 2008.
• Collect requirements, design and create Report in ProTrac using industry standard report generation tools.\
• Generate and submit reports by region / agency for BIA and OHA on a daily, weekly, monthly and quarterly basis.
• Creating New/Modify report: Gather report requirements; Write the procedure; Prepare data for the report; Create crystal report daily report run; Create crystal report for Protrac; Setup the report to be part of the Daily, Monthly, Quarterly Model in Access as needed; Setup the report in Protrac.
• System change management: Manage ProTrac change control activities; Document, manage and submit for approval ProTrac application changes to business owners, OIO, and CCB.
• Create and submit CCB documentation.
• Create test data.
• Wrote test plans for software upgrade.
• STIG testing, make sure the database and application are fine on the server.
• Generate test scripts and implementation plans for planned changes.
• Schedule and coordinate field testing of planned changes and provide support during testing.
• Compile and submit test result documentation and testing certifications.
• Attend CCB meetings for approval of planned changes.
• Coordinate and communicate planned change Implementation with business owners, CCB and OIO; Upon approval, implement system changes and perform post implementation testing and validation; Establish and implement processes for version control; CDS submit official DRs for the bugs.
• Writing Business requirement for New application.
• Perform business process re-engineering and align business requirements with COTS product.
• Create business process flow diagrams in Visio 2010.
• Identify business issues and recommend solutions.
• Perform business requirements analysis and recommend solutions for approval.
• Create draft system requirement documents; Facilitate and conduct business requirements meetings and document the outcome with action items and To Do lists.
• System requirements analysis activities: Perform system requirements analysis and translate business.
• Requirements into system functional requirements.
• Create user accounts as per IIS.
• Maintain ProTrac user accounts: change password; change location; update user role.
• De-activate Protrac user account.
• Assign security roles to users.
• Liaison with DBA for database related issues.
• Liaison with IT Operations and Network Admin groups for infrastructure related issues.
• Unit testing and validation for ProTrac software installations.
• System Operations: Work with help desk and system administrators to resolve application related issues; Provide Tier 1, 2 and 3 support to diagnose and troubleshoot user problems and identify solutions for corrective measures beyond capability of helpdesk personnel; Proactively monitor and establish performance baselines for system performance and health; Troubleshoot system, configuration and data issues and identify corrective measures; Communicate system and data issues to business owners; Troubleshoot, identify and implement corrective measures for system security related issues.
• Establish and maintain system security roles/functions to enable docket entries as defined in the business process.
• Liaison with COTS manufacturer: Develop and communicate business and functional requirements for ProTrac to align the system functionality with probate business process; Identify, report and resolve system related issues; Factory testing and validation of system changes received from the COTS manufacturer.
• Create and submit status reports with project accomplishments and achievements.
• Conduct regular program reviews.
• Personnel management activities.
• ProTrac specific presentations.
• Create template for data change request and coordinate with Help desk manager to implement.
• Create and assign help desk tickets.
• Perform data cleanup and maintenance.
• Login and system access issues.
• Escalate infrastructure related issues to IT Operations / Network Admin groups.
• Create and implement data retrieval procedures for Forms.
• Collect requirements, design and create forms in ProTrac using industry standard report generation tools.

Confidential, VA

Data Analyst

Responsibilities:

• Worked on 4 Oracle and 1 SQL Server database.
• Analyze Teradata with 3M customers.
• Maintained day to day routine activates.
• Worked closely with department’s managers to get the task right.
• Escalate data issue to different dept. for clarifications
• Du-dup and manipulate data.
• Create scripts to select, insert, update and/or delete
• Determine how to fix a specific data issue based on the business rule.
• Worked closely with Business team to resolve data issues Customer Service Rep.
• Done ad-hoc request using SQL script.
• Reporting have done using Aggregate functions.
• Modify table structure using DDL scripts
• Have done the ETL process to load data.
• Have done Data Mapping source to target.
• Have done Gap analysis between oracle and Sql Server database
• Perform analysis on NSI data issues in OLTP and OLAP database.
• Execute Procedure when need.
• Function, Trigger, sequence, Index
• Execute Perl scripts Perl script to validate bulk data
• Execute Shell scripts to transfer data from one server to another.
• Work closely with C# and Java Developers.
• Used SunOS 5.10 for Unix and Toad Oracle 9.0.1
• Used PuTTY .0.58, Vi Editor and SQL*Plus to create script and execute scripts.
• Doing QA in Back end tester and Front End for Account Manager, CSR Tool, Order Editor, and Name Secure Applications.

Confidential, MD

Database Analyst/DBA/Crystal Report Developer

Responsibilities:

• Maintained Time and Attendance system for Dept. of HHS.
• Analyzed data for Auditing Dept. quarterly bases.
• Data Validation has done.
• Data have been updated, deleted, merged, and inserted based on Tickets.
• Backup and recovery strategy: 1). Daily full database backup. 2). Hourly Trans log backup. 3). Weekly system database backups. 4). Documented restoration protocols.
• Maintaining database consistency: Daily DBCC DB checks.
• SQL jobs: Sending email, running PP Close, etc.
• Index rebuild: Biweekly rebuild indexes.
• Monitoring database performance: Using SQL Server tools and generated scripts to monitor database performance, including lock, block, query tuning, etc.
• Programming: Generating stored procedures and scripts to maintain database integrity: Monitoring PPE activities, cleaning up bad data (for example, application sometimes generates NULL value for VLTP requests, which ruins the whole leave approving page for the LAO), assigning DBA role to new coordinators, etc.
• Make Application Servers up and running fine, if not then inform System Admin.
• Migrated 4 databases into one server one at a time.
• DB activities: User database backups, System database backups, Transaction log backups, Manage Indexes, User database Integrity checks, System database Integrity checks, DB Alerts, Performance Monitoring, Manage disk space for backup files and logs, Monitor database growth, Monitor db tables (major activity tables) growth, Manage version upgrades
• Data Modeling have done using Erwin.

Confidential

Crystal Report Developer

Responsibilities:

• Developed Crystal reports for 13 departments of HHS (FDA, PSC,IT, CMC, AoA..) using Oracle Data Warehousing (Demoralized)
• Wrote Business requirement, Analyzed SAS, Coble and Mark IV program with the programmer to Convert 200 reports in Crystal.
• Adhoc reports are done using Free Hand Sql.
• Wrote SQL Scripts, Procedures and created necessary tables as needed to complete the reports.
• Most of the calculations and coding are done in Crystal using Crystal and Basic Syntax to eliminate load on database server.

Confidential, VA

Database Administrator

Responsibilities:

• Analysis data in SQL Server 2000/2005 from 5 different OLTP databases, Log ship AetnaProd, AAProd Logship, ARMS, Dashboard Confidential and IISLOGS (for Confidential and non- Confidential (ICM/SS) Membership.
• Daily, weekly and monthly reports are done: Three month Eligibility Compares with zero active members; Low Scoring 7 clients per week; Eligibility lost members; New client Eligibility;
• Eligibility compare by client for six months.
• Maintain Access database. Collect and analyze data and perform or supervise the quantitative analysis of results.
• Error log reports show how many client files have failed while loading in the database.
• Analyzed how my are eligible, how many people are select for Varolii and how may contacted by Varolii (is a automated machine call to members to let them know they will be getting call from a Nurse)
• Load data into database from different source using DTS, Import/Export and BCP.
• Compare data between Confidential ’s different servers to sink data in the database. Data mapping has been done for the transition between new software and Active Health Management.
• Admin of the JTrac called (IISLOGS database) (Bug tracking tool) where all the issues of our company tracked; I have migrated and made changes based or business need to JTrac; Created Training Doc.
• Modified and save SQL script in VSS (Visual Source Safe) and TFS. Crated RFC (Request for change) have been done when Procedure or Script need to run in production server. Plat form change processes have done in our database when members change one company to another. Medicare member Analysis and investigate Term Members.
• Crystal report for upper management.

Confidential, VA

Database Administrator

Responsibilities:

• Manage and service all internal SQL Server 2000/2005 databases; Total of 15 relational databases (OLTP) and 1 data warehouse (OLAP).
• Modify and manage membership iMIS application based ASCO's requirements. Small and Annual Meetings and Grant databases created throughout the year based on business changes.
• Data modeling using Erwin and Normalization of the database have been done. Worked closely with .Net developer created and change database wrote procedure using TSQL. Perform database management tasks including: Creating SQL Views, SQL Script, Stored Procedure, Function and Triggers.
• Routines and ad hoc request have been done using SQL and Access Conduct training, prototype business processes, develop solutions and services, and implement work plans.
• DTS package created to load data in to database. Data integrity checks have done based on the business roles.
• Design and construct relational databases for web applications in SQL server 2005.Conduct design analysis of applications by working with developers and end users.
• Provided project leadership to implementation phase of the transition to self-publishing of scholarly medical journals.
• Created Access applications for end users to enter data and modify existing data base on new information. Access Database Reporting
• Generate financial reports using Crystal for Budget dept. and iMIS application.
• Database backup and Restore have done when needed. Database snapshot have taken before bulk data load.
• Performance and toning have done time to time. Setup Jobs in SQL Server Change user rights in SQL and Access Database
• Kill processes when dead lock occurs.

Confidential, VA

Senior Business Data Analyst

Responsibilities:

• Maintain SQL Server Data Warehouse, LOANS.
• Two Relational database Oracle, SBO and SQL Server databases, LENDWORX. Maintain Purchase and Sales data of the entire bank.
• Wrote Procedure and DTS package to load the data in Loans database
• Create custom SQL scripts to extract data for internal division and external requests.
• Used PLSQL Developer and SQL to create Ad-hoc report for business unit on a priority basis.
• Upload bid tape, final requirement fields received from sellers, upload purchase loan data reviewed by outsource vender, OS/SCI ; upload due diligence information for sale; upload sale file to Loans and SBO database received from multiple investors; upload funding schedule received from sellers/Investors.
• Reverse Engineering has done using ER-WIN to create data base Schema.
• Gathered the Report Requirements from the users and created the Universes and Reports.
• Defined Cardinalities and checked the Integrity of the Universes.
• Designed the Universes, Created Contexts and Aliases for resolving Loops in the Universes.
• Extensively used Decode statements, and Designer Functions like @Aggregate Aware (), @Prompt, @Date, @Select, @Where etc.
• Created various Reports by pulling the OLAP data from Data Warehouse like Sales of Product, By Region wise, Reports Based on time like Year, Quarter, Month, Week, Geographic reports and Comparative reports. Created charts to display summary of the data. Exported the Universes to the Repository to make resources available to the users.
• Created new classes and User Objects in designing the Universes. Created Documents both (full client and Web I), summary and detail with the functionality of Drill down to Detailed Document.
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts for creating Business Objects reports. Created Objects to Drill Down from Count (measure) to dimension objects
• Provided Object level security using table mapping and used derived tables and defined the prompts at table level.
• Supported a quantitative analysis team on its strategic analysis and ad-hoc report by extracting, manipulating, summarizing, and analyzing data Scheduled Business Objects Reports through Broadcast Agent and monitored scheduled reports through BCA console. Documented the Universe design and Reports development. Trained the end users in ad-hoc Report Development and participated in Production Support.
• Web Intelligence was used for web-based query and reporting. Transfer data from Lendworx to Loans database in nightly batch. Check for data integrity and discrepancy. Responsible for all management reporting and interface maintenance. Work with DBA closely for backup and restore data incase of data losses.
• Provide business managers with operational and business analysis and re-engineering initiatives for proposed process enhancements that achieves efficiency. Alter and modified table structure based on business need. Generate report quarterly bases for OTS and Sarbanes Oxley.
• Do weekly, monthly, and yearly report using SQL, Access, and Excel.
• Assist to create Data Warehouse for secondary marketing with Dimension and fact table.
• Help with creating Metadata process. Prepare file layout for New Client based on the E-trade DBMS
• Control user access right for two different applications.
• Back end testing for Dexma Application.
• Define, gather and document project scope, requirements, and process flows for loan origination system and system enhancement development
• Analyze and resolve stage and production related systems issues.
• Produce user manuals and troubleshooting guides as support resources for end-users. Provide systems training to end-users.
• Liaison between business units and technical team, as well as external vendors.

Confidential, VA

Data Analyst

Responsibilities:

• Mapped data for data mart against existing database, End User Report, Flat file, Excel file and Access data file for Restatement Project. Wrote procedure for gathering data from different departments and perform quantitative analysis of data. Wrote SQL Query to get result for report on the business requirements.
• Maintain responsibility for designing and testing changes to the data mart environment.
• Work within a team to maintain and enhance systems. Manage issue resolution process to ensure all user data quality issues are proactively researched and resolved. Process client requests using data mining tools in Visual FoxPro, SQL Server, and MS Access.Financial terminology conversion data dictionary. Created flow chart, Pivot Table and Layout of project process.

Confidential, VA

Database Analyst

Responsibilities:

• Setup databases for Fortune 500 clients to manage and process Grassroots, Employee, Facility, Vendor and Payroll data
• Extensive use of Stylist, Personate, and Accumail to cleanse data and map zip codes to 9 digit codes for zip to district matching
• Automate data load processes with design and implementation of data transformation services (DTS) packages
• Perform database backup, performance optimization, and database maintenance
• Provide technical support for database related problems and troubleshooting back-end issues
• Participate in the design, execution, and ongoing maintenance of disaster recovery and high availability planning
• Process client requests using data mining tools in Visual FoxPro, SQL Server, and MS Access. Design and create custom reports using Active Report Writer
• Implement T-SQL data access methods and processes (stored procedures, views, triggers)

Confidential, NY

Financial Data Analyst

Responsibilities:

• Maintain retail financial reports for performance measurement based on sales results, product performance and income/expense
• Perform data entry, extracts and manipulation of various software applications to support informational needs to achieve corporate objectives; Support the analysis and forecasting of the budget process; Execute office and Retail Banking Department profitability modules
• Work with different business lines to automate reports using Excel and Power Seller (Info Maker)
• Perform quantitative analysis, strategic analysis and ad-hoc report by extracting, manipulating, summarizing, and analyzing data. Revised, edited, and produced documents to correspond with current department policies and business rules; Created Test Plan and prepare documents for Sarbanes Oxley
• Perform data analysis within MS Access application and keep track of system issues within

Confidential, NY

Data Analyst

Responsibilities:

• Reporting: Interacted with product engineers and management to develop report specifications; translated specs into code and verified data integrity; used SAS, SQL, Korn-shell scripts, VBA, batch files, HTML, and schedulers for data extractions, analysis, and reporting; automation of routine Excel and PowerPoint reports using macros and VBA; produced accurate and timely overview reports for upper management
• Database Development: Using MS Access, automated imports from various source files; report development using queries, macros and VBA; verified accuracy of reports; end-user support; backups and database compacting; ODBC to Oracle databases; upgrade from Access 97 to 2000; designed data entry forms and navigation form, migrated Access tables to Oracle Server (linked to Access front end).