SUMMARY:

• 20 + years of experience in IT industry, 10+ years of Project Manager/Lead, Business Analyst, solution architect/data analyst experience in the areas of Retail, Supply chain, Manufacturing, data warehousing.
• Fast technology learner and constantly updating/adopting of current technology developments.
• Experience with both COTS and custom application development projects
• Experience in Project Management methodology with full cycle of SDLC method in Client/server application in Unix/ NT/Novell Environment using regular databases like Oracle 9.0 or SQL Server 2000. and Internet technology based projects.
• Good functional knowledge of all business processes, improvement and process re - engineering, mapping to system process and technical architecture solutions
• Participate in System/integration/unit/user acceptance testing/defects tracking,, versions management to make sure Project deliverable is met with quality standards including data quality
• Preparation of Project scope, Request for Proposal, Bid documents, outsourcing contracts etc
• Project Management Approach project management, financial management risk assessment, triage of bugs and issues, SWOT analysis assessing development interdependencies,
• Manage releases between dev, test and prod environments translating business requirements into functional specifications; maintaining project schedules and establishing milestones along with development and quality assurance leads; managing and tracking the quality and status of multiple projects;
• Communication of status and facilitation of problem solving; prioritization of features, tasks and new issues.
• Projects Leading

SKILL:

Operating System: Win NT 2000/XP, Unix/Linux, AS/400, VAX/VMS

Databases: Oracle 9i, Access 2000, SQL Server 2000, DB2/UDB 8.1

Language Used: SQL Navigator, PL/SQL, Cobol Data General/PC, VB, Query Tools

ETL & OLAP Tools: Business Objects, Oracle Discoverer, DB2 Warehouse ManagerSQL Server DTS/ Analyse services, COGNOS Enterprise server, Power Play, Impromptu, Visualizer Scheduler etc

Knowledge in: Microsoft Technologies VB, .NET, Java,J2EE, Cold Fusion Front page Web components, IBM DB2 Integrator tools, Web technology tools,, MS Project, Agile PM Tool, Quality/testing deliverable and documentation

PERSONAL SKILLS:

Action oriented, business acumen, composure, creativity, customer centered, priority setting, results through action, Positive attitude, enthusiasm, and a team player

PROJECT EXPERIENCE:

Confidential, Washington, DC

Project Manage/Lead

Responsibilities:

• Develop project scope, Plan and task list and maintain project plan
• Lead the design for data warehouse/reporting
• Conduct monthly customer review meetings/presentation to update project progress
• Maintain budget/cost estimates for the project and EVM review monthly
• Lead the infrastructure team to setup/network/security tasks and coordinate
• Lead the web services team using Oracle weblogic and SOA suite
• Manage customer requirements/BI reports with different agencies
• Lead Oracle BI report development and user
• Maintain all the project contract, software development, security compliance documentation and follow the submission guidelines (NIST, FEAF))
• Involve in server security scans and resolve the issues with server and network management team
• Review the project tasks weekly with the team to resolve any pending tasks/issues

Environment: Oracle 11g, ODI, OBIEE, Web Services and SOA suite, ERWIN, Unix, Sharepoint

Confidential, Washington, DC

Project Lead/ Data Architect

Responsibilities:

• Develop project scope, data migration plans for STATS reporting team
• Overview migration from COBOL flat file to DB2 Target table for reporting collection
• Overview of d esign DB2 Report database with metadata information.
• Review data mapping, ETL specs for loading fom flat file into DB2 target tables
• Analyze new report requirements and review the target tables design
• Define/review Data Architecture standard and data definitions
• Interact with DBA team and network management team to review the tasks
• Review on data aggregation, transofrmation during ETL process and documentation

Environment: DB2, COBOL, Mainframe, Ab Inito ERWIN, Unix, Sharepoint

Confidential, Quantico, VA

Project Lead /Data Architect

Responsibilities:

• Develop project scope, data migration plans for Retail and Finance Datamart
• Review d esign fact and Dimension tables based on the source Retail and Finance data
• Plan and schedule the mapping for data load in DEV and Prod servers
• Review data mapping for Retail and Finance Datamart in OWB
• Bi - monthly management update on progress in agile project delivery phases
• Review Data Architecture standard and data definitions, Data Replication and archiving strategy
• Review of server and database, network performance and follow up with issues list

Environment: Oracle10g, OWB 10.2, ERWIN, Unix, Clear case Tools, Sharepoint,Cold Fusion

Confidential, Reston, VA

Lead/ Integration Manager

Responsibilities:

• Lead interface team ha ving data architect, analyst and testers
• Review data mapping for interface requirements with standard Canonical data model
• Review with team Data model according to naming standards and grouping by functions
• Create XSD schemas, WSDLs and validate using XML Spy
• Create mapping for request/response schemas, XSLT using Contivo Analyst, Mapforce
• Generate application design document for interface developers using Data power
• Participate in interface impact sessions to identify affected data elements and systems
• Participate in requirements sessions to study/analyze the interfaces impact

Environment: Oracle10g, Erwin, Unix, MS Project, Visio, Webservices, Abnitio,Business Objects, Java, MS Project, RUP tools, .Net/VB, Ms Project/server 2003, Cold Fusion

Confidential, Mclean, VA

Lead - Data architecture and Business Intelligence

Responsibilities:

• Create and maintain project plans based on the requirments and scope, estimate resources and budget needed in data warehousing/Business Intelligence projects
• Maintained project risk documentation and managed risks mitigation efforts during implementation, swot analysis
• Manage and anlyse business requirments from various groups and consolidate it to technical requirments using IBM requisite pro
• Manage and allocate resources and responsibilities to meet the project deadlines and conduct weekly review of team performance (team size > 25)
• Verify the application design and data base design along with devlopers and business users to ensure data architecture standard and manage release of versions (Dev, test,Prod)
• Participated as Lead in asset based security systems, loan evaluation system, custom fee assessment, credit risk rating system, credit enhancement system guiding the team in changes and interact with the technical team to implment the changes according to the project time line
• Track project issues and discuss with the business and technical users to resolve based on issue logs, defect logs, risk management issues

Environment: Mainframe, Sybase, DB2, SQL server, Oracle,Erwin, Unix, MS Project, Visio, Datastage, Microstrategy, Webservices, Cold Fusion, Java, J2EE, MS Project/server, IBM Requisite pro

Confidential, Shelton, CT

Project Manager/Lead

Responsibilities:

• Work on migration of Credit card applications projects from mainframe to third party systems and requirements gathering using IBM requisite pro
• Create and maintain project plans based on the requirments and scope, estimate resources and budget needed, SOPs, merger operations tasks and report to EPMO
• Compiling GAP analysis between mainframe legacy and Vendor systems, prepare/monitor business requirement analysis(RA) using requisite pro, discuss with different business user group for OLAP and data mining report project
• Discuss with vendor team about application development statuses, migration plans, outstanding issues and defects, risk management issues during implemetnation
• Identify the project interfaces, related RA and follow up with vendor, Confidential IT teams for applications like accounting, card payments, Business Intelligence
• Establish change control procedures for ongoing agreed RA and follow up with development and business team
• Review network infrastructure and security issues and discuss with infrastructure team to enhance the performance, application migration, storage sizing etc
• Manage and allocate resources and responsibilities to meet the project deadlines and conduct weekly review of team performance (team size >25) for IBM MQ series integration project
• Review tesing plans with testing coordinators for system, integration and UAT for web based reporting project

Environment: Mainframe, Oracle, Erwin, Unix, MS Project, Visio, Lotus notes sametime, Java, J2EE, Cold Fusion, MS project/server, IBM Requisite pro

Confidential, Lansdale, PA

Project manager/Lead (Business Intelligence)

Responsibilities:

• Study and analyze user requirement and match with new application system options and responsible
• Define the scope of the project and roll-out plans, prepare project proposal, plans and schedule, SOPs
• Manage and allocate resources and responsibilities to meet the project deadlines and conduct weekly review of team performance (team size 30)
• Prepare hardware and software architecture for testing center and review tesing plans with testing coordinators for system, integration and UAT
• Creating Data mapping/verification templates, subject and dimension model matrix for the data warehousing/Business Intelligence projects
• Prepare data validation/transformation template for data discovery, data quality and data delivery.
• Cost estimation (manpower, software and hardware, License fee etc.)
• Organize the resources, meet external vendors on hardware/software to meet the schedule and milestones for web based projects with budget of >600k
• Track project issues and discuss with the business and technical users to resolve
• Review complete user group, network security, server allocations etc

Environment: AS/400, NT/2000, Cobol, Oracle 9i, Toad query tool, Access 2000,Informatica 6 tools, Cognos 7 tools, s MS office tools, Erwin, Visio, Mercator data mapping tool, MS Project/server

Confidential, Parsippany, New Jersey

Project lead /Sr data warehouse consultant

Responsibilities:

• Assist Project manager in project progress review meetings, prepare project week progress report, outstanding business and technical issues, assigning ownership of issues, tracking issues timeline etc
• Review network infrastructure and security issues and discuss with infrastructure team to enhance the performance, application migration, storage sizing etc
• Gathering business users requirements, developed work flow diagrams, use case analysis, system scope and coverage in phases for merger operations, data migration
• Maintaining Project scope/requirements update, resource requirements planning, plan update, monitoring milestones, change control management, risk monitoring and control issues for all the project in Data ware house team
• Creating budget forecast for hardware and software, current projects status review, Products review, work with product vendors, building Products review matrix with cost estimates
• Manage and allocate resources and responsibilities to meet the project deadlines and conduct weekly review of team performance, swot analysis
• Project Lead in DB2 Warehouse Manager (V8.1) and DB2 Olap Project for Consumer division. Installed, configured, created aggregations, OLAP cube and tested the performance against AS/400 data.
• As a Project Lead created and monitored Advanced Planning Document, the (MS Project) Project tasks, task execution, review of technical architecture, delivery to user, End User support/interaction, change management, source version control, document release control, interact with operation team in production support

Environment: AS/400,IBM IMS Mainframe, Cobol, NT/2000, Oracle 9i,DB2/UDB, MS office tools, Erwin, Visio, Informatica 6 tools, Cognos 7 tools, ESSBASE tools, MS Project/server

Confidential

Project Manager / Sr consultant

Responsibilities:

• Client feasibility study, Business Analysis, Project Management, Roll-out Plan, Implementation, Role in Data integration and migration, configuring Retail Merchandising software Product, and design for data mart requirements sourcing from Retek retail.
• Maintaining Project scope/requirements update, resource planning, plan updates, monitoring milestones, change control management, risk monitoring and control issues, resource planning, hardware and software budgeting, managing vendors in licensing and versions upgrades
• Responsible for create and design of data warehouse tables (Star Schema design) using SQL 7.0 server, Options using Data Transformation services, DTS import/export Wizards, clustered index analyzer wizards, SQL server query processor/ analyzer
• SQL server Enterprise manager, MS Olap services (cubes), Web Assistant Wizard, Access 97, Impromptu/Power Play etc. Used SQL Server performance objects for maintaining and tuning of data warehouse, replication, multi server options, Raid option for failsafe etc.
• As a Project Lead responsible for monitoring the Project tasks, managing the team and users group requirements and Project Delivery

Environment: NT Server with SQL 7.0 /Access 97/VB 6.0, IBM Intel based server, Oracle, Retek

Confidential

Project Lead/Sr Applications Consultant

Responsibilities:

• Designed and outsourced POS and back office system for Indonesia Operations
• Using VB, Oracle and Access
• Involved in preparing the Bid documents (RFP of IT Functions) for the outsourcing Prepared hardware /software architecture and data flow for the whole outsourced retail system development using Retek retail application
• HR Software rollout in Asia pacific countries including data migration from legacy systems
• Design the logical data model and upon approval of the design by the user requirement group members, design the physical data model
• Maintaining Project requirements update, resource planning, plan updates, monitoring milestones, change control procedures, risk monitoring and control issues, data quality management
• Used OLAP tools like Business Objects/Oracle Express (cubes) /Cognos Impromptu for the various users across Asia
• Business process mapping and system requirements using Erwin for Sales/marketing users

Environment: NT / Unix with Oracle, Retek, Dev 2000, Business Objects, Gentia, Visual Basic and Access 97

Confidential

Project Manager

Responsibilities:

• Project study, scope and budgeting and monitoring the implementation phases.
• Maintaining user requirements updates, resource planning, plan updates, monitoring milestones, change control procedures, risk monitoring and control issues, data integration plans, reporting requirements and getting business directions for the projects.
• Responsible for performing user requirement analysis, designing and creating functional specifications
• Complete system study, design and Implementation of warehouse inventory and Point of Sale software with security enhanced features, Lan/Wan maintenance.
• Responsible for POS and Rollout in all the shops and data collection at regional office
• Implemented CRM/Contact Management package project in the back office
• Introduced Corporate Internet Setup, website and Email system for 25 users

Environment: Foxpro/Lan with Novell 4.1,Visual Foxpro 3.0, Cobol, Oracle 7.x