SUMMARY:

Over 17+ years’ experience in Project Management, analysis, design, development, testing and implementation of Client/Server, ERP, web applications and Data Warehouse. Familiarity with the Project Management Institute (PMI) Guide and the Project Management Body of Knowledge (PMBOK). I have expert knowledge within leadership, analytical and problem solving skills. Expert in directing the development and/or operation of a large organizational element of IT management. Experience with IT development methodology throughout the Software Development Life Cycle (SDLC) and ITIL V3 Certified

SKILLS:

Operating Systems: Windows 2000/NT/98/95, UNIX, MS - DOS, Windows 3.1

Languages & Technology: VB, ASP, PL/SQL, SQL, Fundamentals of Java 2, Perl, C, Tobin, ADO, COM

Web Servers: IIS (Internet Information Server)

Databases: Oracle7.x/8i/9i/10g/11g, Sybase, MS Access 8.0/7.0/2.0, MS SQL Server 7.0/2000

Tools: Developer 2000/Developer6i, Designer6i/2000, Erwin, Business Objects 5.0/XI,BODS, Crystal XI, Infomaker 11 and Cognos 8, SAS 4.3

ERP: Oracle 11i Financials (Customization of Reports and Forms.), Novistar, P2es, Oracle EnergySAP BW/BI Netweaver 7.2.

BigData: Hadoop,Hbase,Hive, BigSQL

EXPERIENCE:

Sr .Data Architect/Data Analyst

Confidential, Richmond, VA

Responsibilities:

• Responsible for Data analysis, Data/process flow diagram and Data Lineage Mapping attributes for CTR (Currency transaction reporting), Monetary Instruments, general Anti-money laundering(AML) reports for Confidential Transactions.
• Responsible for identifying attributes required for Anti-Money Laundering and Suspicious Activity Report Filing for currency transactions.
• Responsible for Data analysis, Data/process flow diagram, Identifying required attributes for Global Sanctions list screening and Data Lineage Mapping
• Global Sanctions/ Economic Sanctions is responsible for screening customer records against various watch lists on Partnership (Khols, HBC and HSBC), real time( Confidential Auto Finance(Coaf)), Wire Transfers, daily, weekly, periodic or ad-hoc frequency to identify matches to the watch lists. List Includes OFAC Specially Designated Nationals, OSFI -Canadian legislation and UN anti-terrorism measures list, HM Treasury - watch list, Political Exposed Persons (PEP),OSFI - implements international sanctions and measures to combat terrorism list.

Environment: Oracle 11g, SQL, PL/SQL, Teradata, Unix, Excel, Actimize,Bridger,Tsys, First Data and TranSand.

Confidential, Pittsburgh, PA

Responsibilities:

• Responsible for identifying attributes/data used inconsistently across multiple models (Basel, CCAR) as well as reports and downstream processes.
• Involved in identifying required attributes for write-down of principal for multiple models (Basel, CCAR) as well as reports and downstream processes.
• Charge-off Date
• Charge-off Amount - Separate fields for principal, interest and fees
• Principal Forgiveness Date
• Principal Forgiveness Amount
• Responsible for identifying attributes for Delinquency Status, Material Fair Value Adjustment, Repo Initiation, Over-Draft Protection, Default Resolution & Recovery Requirements, 3rd Party Foreclosure, OREO Sale, Short-Sale/Settlement, Settlement, Full Balance etc..
• Involved in reviewing attribute mappings and current gaps with SMEs to Confirm mappings and Identify gaps which need to be addressed, to remediate gap attributes for current year models and Design required Process changes to ensure data capture moving forward.
• Responsible for mapping consumer charge-off and recovery data in support of RCMR (Basel and CCAR models).
• Participated and validated Business Requirements, Design Documents, Mapping Documents, Test Strategy, Test Plan & Test cases in User Acceptance and System Integrated Testing environments.
• Involved in validating data between Source (Assets) and Target RCMR (Basel and CCAR models).
• Responsible for Developing ETL scripts to pull the Data from ETL Stage Database for MSP asset class. Responsible for creating SAS Dataset and Data profiling.

Environment: Oracle 11g, SQL, PL/SQL,SAS, Unix and Excel

Sr.Data Architect

Confidential, Fairfax, VA

Responsibilities:

• Responsible for Data Analysis, Lessons learned analysis and Data Artifacts for the Postal One application releases.
• Responsible for validating and approving Data/Database related production support Data repairs for the Postal One application.
• Responsible for checking Database related log file for Postal One applications Pre and Post Deployments.
• Responsible for creating Ad-hoc and Canned reports for SIT/CAT for each release, information on SRS, DRs, ERs .
• Responsible for creating graphs/charts for root cause analysis (Code issues, Database issues, configuration issues, user errors etc.), creating graphs for Priority details (critical, high, medium and low).,Days to close charts etc.

Environment: Oracle 11i, SQL, PL/SQL, HP ALM, SAP Business Objects XI R3

Sr.Data Architect

Confidential, Mclean, VA /Wilmington, DE

Responsibilities:

• Responsible for, Data Analysis, Data profiling and Data validation and approvals for Bank Operations Falcon BCP/Share builder projects.
• Responsible for Developing Ad-hoc and Canned reports for Analysis to report suspicious, International wire transfers, multiple Joint accounts with different addresses, multiple accounts with different mailing addresses, missing zip codes or phone numbers.
• Responsible creating reports on commercial (small business) accounts, like monthly/daily deposits, cash deposits etc.

Environment: Teradata, SQL, Teradata SQL Assistant, Business Objects XI R3

Data Report Analyst/BOXI Developer

Confidential

Responsibilities:

• Responsible for Data requirements/ Technical documentation and Data Analysis for the Home Affordable Modification Program known as HAMP/MHA is federal program of the Confidential.
• The program was built as collaboration with lenders, Investors, mortgage servicers and the Federal housing Finance Agency, to create standard loan modification guidelines for lenders to take into consideration when evaluating a borrower for a potential loan modification programs like Tier1, Tier2, MHA,NPV, HAFA, PRA, 1MP, 2MP etc.
• Created and developed canned, Ad-hoc, Dashboard Reports for HAMP/MHA Program using Webi on MHA Data Mart Universe for Analysis and reporting.
• Responsible for writing complex SQL to generate reports and files.

Environment: Oracle 11g, SQL, PL/SQL,Toad, Clear Case, Clear Quest, Business Objects XI R3

Sr. Data Architect/Data Analyst

Confidential

Responsibilities:

• Responsible for Data Analysis, Data profiling and Data Modeling on various attributes from HP asset management, HP configuration management, HP Service Management, ITSM, SCCN, Systinet, Rackwise, Clarity, Quality Center which was heavily used in creating and maintaining Corporate compliance, Operational Risk, SOA Governance processes, reduce TCO, Application Portfolio Rationalization and IT Optimization.
• Defined Data attributes, Relationships, LDM (Logical Model) and PDM (Physical Model) ) in collaboration with Data Modelers.
• On a day-to-day basis coordinated and engaged Off-shore & On-shore teams
• Participated and validated Business Requirements, Design Documents, Mapping Documents, Test Strategy, Test Plan & Test cases in User Acceptance and System Integrated Testing environments.

Environment: Oracle 10g(SQL,PL/SQL), Teradata 10, SQL Server, DB2 9.7, SQL, Teradata SQL Assistant, Toad, SAS 9.2, Livelink, Hyperion Essbase, Business Objects XIR2, Unix

Confidential, Richmond, VA

Sr.Programmer/Systems Analyst/BOXI Developer

Responsibilities:

• Developed BI Reports using Business Objects for the Directors for HOPE,People gas sale to Steel River and for Dominion's exploration and production $3.475 billion sale of Appalachian region to Consol energy .
• Business Objects Administration(Supervisor) and Universe Design.
• Created Business Objects Classes, Objects and Lov’s (ERP and BW Databases)
• Designed and Developed reports using (Business Objects/ Crystal Reports XI )
• Designed, Developed databases for Hope and People Gas (for Steel River) and exploration and production (for Consol ) from the existing database based on the Sale agreement.

Environment: Oracle 10g (SQL,PL/SQL,SQLPLUS* Reports, SQL LOADER),Oracle Apps 11i,Forms 6i,Reports 6i, Business Objects XI, Business Objects Universe Designing and support, Crystal Reports XI, Tobin 4.3,Infomaker, Cognos 8 (Framework and reports), Oracle Energy-p2es Enterprise Upstream.Unix,Shell Scripting,, Toad, Harvest and Change Management,Doors 9.3, SAP BW/BI 7.0, BEX Queries and BEX Analyzer.

Confidential, Richmond, VA

Sr.Programmer/Analyst

Responsibilities:

• Developing Technical Specifications, Design Documents. Coordination & scheduling, testing.
• Extraction and loading data from External tables & Flat files Creating Tables, Constraints, Indexes, Views, Procedures, Functions etc
• Analyzed, designed and created Materialistic views for the reports, Analyzing and fixing the production issues, SQL Tuning, writing complex SQL and PL/SQL for reports, writing Shell scripts to retrieve the file and loading the data into tables using Sql Loader

Environment: Oracle9i,,SQL,PL/SQL,Procedures,Functions&packages, Sql Loader, control files, External Tables and LIMS * SQL, Explain Plan,Unix

Sr.Programmer/Analyst

Confidential

Responsibilities:

• Designed and developed daily and cycle scripts to identify the clip eligible accounts.
• Capacity planning for the tables and indexes, participated in creating stories, assigning story points and participated in interactive retrospective and planning Meetings, coordinated the efforts for loading Test Data from sources, data requirement analysis, Data Synchronization efforts and Data Trimming Strategies, involved in the Data Architecture sessions and recommended to create enterprise data standards, created Technical documentation, communicated the data needs with test teams, created a process for data refresh activities, code reviews, coordination and scheduling of development & testing, coordination with off-shore team for On Call Support, wrote complex SQL and PL/SQL, used Explain Plan for optimal performance and fine tuning, used hints to tune the SQL, writing shell scripts to create signal files to check the file availability and to retrieve the file as well as to run the SQL Loader and to run SQL Scripts (Blocks) to load the Data into Data warehouse(ETL process using PL/SQL and SQL Loader).

Environment: Oracle 9i, SQL, PL/SQL (PL/SQL Blocks, Procedures, Functions and Packages) Toad, Clear Quest, Case, UNIX and Agile

Confidential, Richmond, VA

Sr.Programmer/Analyst

Responsibilities:

• Developed core Dispatch and Expense Model calculations for forward/future trading in the Fuel Plan application. These will generate the assumptions that are dated based on Current and Historical data for the future fuel prices and assumptions that are not dated such as fuel basis percent and escalation methods. To separate the data layer and for code re-usability all the calculations are implemented as packages in the backend using Unit of Measures, Variables, fuel type, fuel basis, spot prices, Transportation for station and terminal level.
• Developed a Server Check application which checks the status of the stations and calls PI Reporting application which creates reports using PI real time application, This application checks the status of the PI servers for each station, if any of the servers status is failed, it calls the PI Reporting application for 24 times in 24 hours and close the application or it exists as soon as all the stations status active and data is available.
• Performed requirements analysis, technical specifications for system enhancements, like adding new meters, creating new reports and new module developments, worked with Business clients off site and onsite to gather new requirements. Supported and resolved production issues for Oracle (Energy, Revenue, Production, Accounting and GL modules) application 10.7. Responsibilities included System administration as setting up new users. Per new requirements altered SQL scripts, Procedures and Functions. Developed new scripts, Procedures and functions to move meters from agency to another and created monthly reports using SQLPLUS* reports and also created Unix scripts to check the files received every first week of the month for the imports and to send the email notification to users. Created and Supported Business Objects Reports, made changes to Universe and created new Objects and classes.

Environnent: Oracle 9i, SQL, PL/SQL (Procedures, Functions and Packages), Oracle Application 10.7, P2es - Oracle Energy, Unix,Shell Scripting and Business Objects 4.1,Visual Basic 6.

Sybase DBA

Confidential

Responsibilities:

• Supported Southern States Corporation Databases including Backup, recovery (Table level and Database level, adding and resolving the space issues, checking the log files for errors and performed day-to-day tasks)

Environment: Sybase system 12.0, UNIX and DB Artison.

Sr.Programmer/Systems Analyst

Confidential

Responsibilities:

• Accounts are assigned to holding queues which are staging areas for accounts before the strategy is determined since the assignment is done in weekly batch. Every account is assigned to an internal or outsourced agency based on attributes. Accounts are assigned to sub-agencies or queues using more defined attributes. Levels of placements are determined by time in queue, change of state of account, or other criteria. Levels of placement are Primary, Secondary, Tertiary, Quad, Quint, And Data is sent to the data warehouse which is used for analysis and reporting.
• Gathered data requirements developed strategies for assigning accounts and data validation, moving charged -off accounts to Holding queues, assigning the accounts to different agencies, sending the Placement files, updating and sending commission reports, posting Court Costs, receiving and Sending the files using FTP, loading the tables using Sql loader and control files, sending the files to the Data warehouse(ETL process using PL/SQL and SQL Loader), creating Weekly and Monthly Reports using SQLPLUS* Reports, creating New Procedures (PL/SQL) to Move accounts to New Queues and Agencies, modifying and tuning Old Scripts based on the Business requirement, on Call Support, creating Technical specifications, Step by Step Documentation and Training the New Developers/Operations, writing shell scripts to run batch file for daily, weekly and monthly, signal files to check the file availability.

Environment: Oracle 8(SQL, SQLPLUS, SQLPLUS* Reports),HP-UNIX(VI and Shell Scripts),Pro*C, Forms45, Toad, Clear Quest and Clear Case

Sr.Programmer/Systems Analyst.

Confidential

Responsibilities:

• Heavily involved in the conversion of Oracle Energy application to Novistar6i (Oracle Energy application 11i).
• Developed scripts to check the data in the permanent tables against the Interface tables and delete data from the permanent tables, if the data already exists, before loading the data From the Interface tables.
• Converted, created and modified Oracle Reports (SQLPLUS* Reports), SQL Scripts to Reports6i.
• Customized reports and forms for Oracle Energy application.

Environment: Oracle8, Oracle 11i(Energy), Novistar6i, SQL, PL/SQL, SQL LOADER, SQLPLUS* Reports, UNIX(SunOS 5.6),FTP, Forms6i, Reports6i,2.and Business Objects4.2,SQL Navigator3/4