SUMMARY:

• I have more than 13+ years of Database, QA and Reporting experience.
• I have used Oracle, SQL Server, DB2, POST GRE, UDB and Access Schema to create Physical data Model Design. I have Normalized and De - normalized Database.
• I have created Database, Tables based on Model and have Test ER and Data writing SQL Scripts.
• I have created Data Dictionary in Excel and in Database. Have done Extensive DDL and DML statements.
• I have set with business to gather requirements.
• I have extensive experience in Production support where I provided tire 2 supports to end users in most of my projects.
• I have extensive experience in SQL Server 2000/2005 servers. Most of my expertise involves in data/process, migration SQL Server from SQL 2000 to SQL 20005/2008, Physical and Logical Design of Databases.
• I 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.
• I have worked in some of internet technologies like html, JavaScript and others.
• I also have experience on writing Business Requirements, Analyzing and Developing Crystal Reports.
• I have been 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 and SAS Dataflux. 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
• I have 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, Reporter, Supervisor), BCA Scheduler and Publisher, Auditor, Business Miner, Business Query and Document Agent Server, Web Intelligence and Info View

Oracle 11gR2/10g/9.i: (SQL, PL/SQL, Stored Procedures, Triggers Function)SQL SERVER 2000 and 2005 (SQL, TSQL, Procedure, Function), DB2ETL Tools: Data management Studio 2.5 (Data Flux SAS), 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.

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

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

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

WORK EXPERIENCE:

Confidential

Sinior Data modeler/Solution Designer

Responsibilities:

• Generated ETL process job and export data in various file formats using Dataflux.
• Extract data from different databases and source files.
• Did Reverse engeeniring for existing database with Erwin.
• Forward Engineering for have done new database.
• Complete compare have done to capare existing model and database to update model with new structure.
• Conceptual model defines the entities and relations.
• Logical modeling have done add the attributes and business rules in Erwin.
• Physical modeling have done to turn entities into physical table.
• Generate SQL script so it can be run by generate the tables.
• Data modeling process have done: Applied 3rd Normalization, Designing the data structure, defining the relations. How to identify entities, for one entities should we create one table or multiple tables. These are sets of rules these are defers to ER modeling oltp design, dimention modeling used for datawarehouse design(OLAP).
• Data flow diagrams, workflow diagrams, system interface diagrams have done using Visio, Word.
• Also done data mapping.
• Gap analysis between databases.
• Wrote SQL queries and Views and Store Procedures, Funtions.
• File transferred one unix server to another using winSCP.
• Used PuTTY, Vi Editor.
• Generate dos script files.
• Data validation and reconciliation is done.
• Worked closely with database team and data modeler team to get the right database shema and changes took place in database structure.
• Wrote business requirement for business users and also analyzed business required provided by business user.
• Attened meeting with clients and weekly department meeting.
• Understood the business requirement and sas euc code to design and developed Service Data validation djf in Data flux.
• Worked with closely with Autosys team to make sure the djf is scheduled write.
• Tested the djf in DEV and UAT in unix environment and deploy the djf in Production.
• Worked with
• Prepared and designed all EDM and key control documents to meet the requirement of audit team for each project and got all mandatory approval from Business and IT to deploy the djf in production.
• Executed sas EG and dataflux djf to validate and match result with business for accuracy of the reports.
• Made necessary modification to sas EG and dataflux djf to optimize code efficiency and tested the djf in dev and uat unix environment.
• Understood the business requirement and followed to the EDM and SOX process for key control projects.
• Designed and developed Project Name Report in dataflux and created and modified the nodes to make it more efficient to minimize the execution time for djf in production.
• Project documentations worked on as followed: Maintenance Test Plan Results, Design Light (Design document). Privacy Impact Assessment Questionnaire, Requirements Light, Test in Production Waiver.docx and Maintenance Implementation Backout Plan. Transition meeting check list and Peer review check list.

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 and 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 Confidential .
• 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 Confidential .
• 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.

Business objects and Crystal reports developer

Confidential

Responsibilities:

• 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 Confidential 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 Confidential ; Setup the report to be part of the Daily, Monthly, Quarterly Model in Access as needed; Setup the report in Confidential .
• Create and submit status reports with project accomplishments and achievements.
• Conduct regular program reviews.
• Personnel management activities.
• Confidential specific presentations.
• System change management: Manage Confidential change control activities; Document, manage and submit for approval Confidential application changes to business owners, OIO, and CCB.
• Create and submit CCB documentation.
• Create test data and 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.

Business Analysis Support

Confidential

Responsibilities:

• 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 Confidential user accounts: change password; change location; update user role.
• De-activate Confidential 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 Confidential 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 Confidential 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 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 Confidential using industry standard report generation tools.

Confidential, VA

Data Analyst / QA

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 and 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 Confidential .
• 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

Confidential

Crystal Report Developer

Responsibilities:

• Developed Crystal reports for 13 departments of Confidential 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.
• 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 Confidential .
• 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)