Summary: 9 years of extensive and progressive experience in the field of information technology, as a system analyst, Database / Business Analyst Programmer.

Technical Skills

• Oracle utilities SQL Loader, and Import / Export.
• Oracle Business Intelligence Enterprise Edition 10g / 11g
• SQL server 2005-2008, SSIS, SSRS and SSAS.
• Visual Basic, Crystal Reports, Business Object.
• Erwin, Toad and Power Designer Data modeler.
• Microsoft Office and MS-Visio.
• HP Quality Center
• Microsoft Windows XP, Windows NT, Windows Vista, Windows 7.

Other Skills:

• Experienced in managing project stakeholders, customers liaising with consultants and working with contractors and vendors.
• Excellent organizational and communication skills.
• Ability to analyze the situation and decision making.
• Ability to use structured techniques for Analysis and Design, and Identify IT solutions for business needs.
• Knowledge in project management and planning for complete project life cycle.
• Software development life cycle SDLC .

Professional Experience

Confidential

Data Analyst Contract

• Present Project: Consumer Finance Protection Bureau.
• Responsible for multiple tasks managing the monthly statement template inventory, managing Messaging on the statements, responsible for Test Plan internal and vendor, also responsible for creating scenarios for testing, Data conditioning, Data mining for analytical reporting, creating multifunctional reporting.
• Writing complex scripts in SQL and generating reports in Excel, Access.
• Managing Template Data inventory, ensuring data mapping is accurate from data source to target. Also, identifying the ownership, designing the logic calculations and dependencies of each field on the template according to the statement types.
• Managing the statement messaging on monthly mortgage statements.
• Arranging multiples meetings with LOBs to discuss the verbiage of messaging, identifying the LOBs, Ownership of the messaging and getting them signed off.
• Creating hierarchy of messaging based upon the statement type and creating logic to identify which statement will trump the other.
• Created unique message codes for programming, and assigned control numbers which enables vendors to identify the location and order of messaging on the statement.
• Updating messages through proper change control so as to track all changes.
• Besides, collecting business and functional requirements, creating Test Plan and ensuring that all functional requirements are met in Test Plan.

• Also, creating scenarios, logic, writing SQL scripts and generating Test Files based upon scenarios and ensuring that Test Files have at least minimum number of loans to satisfy all scenarios as described in BRDs.
• Designing and creating SQL training documentations and providing SQL training to new contractors.
• Project 2: Department of Justice.
• Also, arranging meetings and actively participating to resolve any pending issues.
• Worked on a project of data migration from one server to new dedicated ones.
• Discussing the issues / status/progress of the project with Business users and collecting Functional / Business requirements in weekly meetings.
• Performing data validation and finding 'Exceptions' in different monthly statements 'DAP', 'HELOC', 'ARM' and many others.
• Downloading data from Mainframe As400 , using SSIS packages and other third party tools for exporting data to target databases to new DEV, UAT and PROD Servers.
• Also performing data mapping, changing schema, adding new columns to the tables as needed and preventing duplicates records.
• Creating scripts in Excel for the testers and loading scripts in HP Quality Center.
• Creating data sheets in Excel and Access for Testers and creating step for testers to run scripts in HP Quality Center for data Validation.
• Writing SQL queries SQL Server 2008 for internal testing, which is used for data validation and finding 'Exceptions'.
• Also performing External Testing in HP Quality Center to assist testers to find the correct account s .
• Also Creating / modifying existing queries for Regression analysis, ensuring the accurate data retrieval and exporting for Business reporting in excel and Access.
• Also generating the defects reports for the vendors in excel and words.
• Performing monthly statements review for new modifications and validating new changes.

Confidential

Business Analyst Contract

• Collecting data from different clients in multiple format and converting into Access, excel, and SQL Server databases.
• Creating SSIS Packages for ETL transformation Aggregate, Conditional Split, Fuzzy Grouping, Fuzzy Lookup and Lookup. Converting and importing / exporting CSV / TEXT, EXCEL and Access files into SQL SERVER and in different format.
• Also, created a bankruptcy cube. It has 1 FACT and 12 DIMENSIONS tables.
• Cube has 20 measures such as, Total Accounts in Bankruptcy, Average FICO Score, Average Age of Account, 30 Days Delinquent Accounts, 60 Days Delinquent Accounts, 90 Days Delinquent Account Percentage of each of the measures etc.
• Used SSIS PACKAGES to load the data in FACT/DIMENSIONS tables using BULK INSERT.
• Also, Performed data cleansing, data conditioning and data mining to create complex reporting for
• Bankruptcy analysis and other work streams.
• Writing queries in SQL SERVER using JOINS, MERGE and COMMON TABLE EXPRESSION. Also, creating and modifying queries in Access Create table, append, update, Delete for updating the databases.
• Also, write and modified existing queries in SQL Assistant Teradata, and pulling data from server and exported into Text, CSV, Excel and Access for the end users.
• Also using Mainframe, Monarch and CA Docview tools for importing / exporting data and converting into Flat files CSV and Excel files for reporting on daily and weekly basis.
• Also, creating advance functions in Microsoft Excel, like PIVOT, VLOOKUP, HLOOKUP, INDIRECT and many others for data manipulation and reporting.
• Creating and designing reports using ACCES and EXCEL for analysis like standard tabular, Parameterized, Drill Down and Drill Through.
• Creating new and updating / modifying existing process control documents.

Confidential

Data Analyst Contract

• Coordinated among the regions, and discussed the nature of the data and business requirement.
• Extracted data from different sources and integrated, mapped and transformed
• Into a uniform data type SQL Server 2008, Access and Excel.
• Created an electronic form to collect data from regions and standardize the process.
• Used SSIS for ETL processes created packages, maintained and deployed.
• Created queries using JOINS, MERGE and COMMON TABLE EXPRESSION.
• Created Pivot Tables, advanced formulas Vlookup, HLookup and INDIRECT functions to manipulate the Database.
• Reduced data redundancy and integrated data to enhance the performance.
• Created many reports for analysis, like Tabular, Drill Through and Drill Down,
• Ad hoc and canned , charts and graphs to track down the progress of the project.
• Transformed data into presentation by using Power Point for higher management.
• Tools used SQL Server, SSIS, SSRS, Microsoft Access, Excel, Visio and Power point.

Confidential

Data Analyst Contract

• Worked on a project of Database migration from Access to SQL Server 2008.
• Performed ETL for data transformation and migration. Extracted raw data csv, Excel and Text files and load into database.
• Used Import / Export Utilities, SSSIS Packages and automated them by using SQL Server Job Agent.
• Generated periodic, and user defined / parameterized, Standard, Tabular, Drill Down, Drill Through, PIVOT reports using SSRS, Crystal reports, Microsoft Access and EXCEL.
• Also, worked on existing database performed reducing data redundancy, data integration to enhance the performance.
• Also, performed data modeling physical / Logical, and Reverse Engineering to identify the complex relationship between / among the tables in database.
• Created advance queries by using JOINS, UNION, MERGE and other functionalities for Data manipulations to serve the customer's needs.
• Designed Gantt charts, Pie charts, Bar charts, line charts and Pareto Charts.

Confidential

Programmer / Analyst

• Designed and created databases and modified existing one for clients.
• Database migration in Oracle from 9i to 10g .
• Created flow charts diagram, data models Physical as well as logical models. Also defined the relationship between different entities ERD , and Screen shots. Performed Froward / Reverse Engineering on existing database.
• Also, worked on data warehousing, designed and created Data Mart and created Dimensions and Facts tables using the star schema.
• Created SSIS Packages and other IMPORT / EXPORT tools to load the data into DIMENSION tables.
• Created several multiple advanced reports for detailed analysis. Created standard, Drill Down, Drill through and parameterized reports on weekly, monthly and quarterly basis.
• Created advance queries, PL/SQL procedures, functions, cursors, validation triggers.
• Created tables, Data mapping, Data Integration, Data mining and normalization.
• Besides, generated several reports standard, tabular and parameterized.
• Tools used Oracle 9i 10g and OBIEE, SSRS reports, Crystal Reports, Excel, Power point, ERwin and VISIO.

Confidential

Oracle Database Analyst

• Dealt with Business users and determined their business/functional needs and requirements.
• Developed several Front End , for business user with Master Details functionalities, and other navigational objects.
• Created data flow diagrams, activity diagrams, Data modeling ERD and USE cases.
• Used Oracle Designer 2000, Erwin and Toad as Data Modeler, Visio, during the development process.
• Developed advance queries, validation triggers, database triggers, PL/SQL stored procedures, functions, Implicit Explicit Cursors for data manipulation.
• Used Oracle utilities SQL Loader, Import/Export utilities for loading data into Oracle database from external sources.
• Generated operational reports Master details, Tabular, Drill down. Periodic as well as parameterized reports for the stakeholders.
• Used Oracle Report developer, Crystal Reports, Microsoft Access and Excel.
• Made many presentations for project updates and progress. Used Microsoft Power point and Excel for presentations.
• Completed many projects successfully for the clients in education, retail / sales, warehouse / inventory management, E-commerce and other industries.