We provide IT Staff Augmentation Services!

Project Management Resume

Responsibilities:

  • Seeking assignments in Project Management, Data Warehouse Architect/Modellingwif a reputed organisation in the IT industry.
  • Over 20 years’ of functional & managerial experience in the areas of Data warehouse Architecting and Administration, as well as Quality Assurance, Software Programming & Administration. This includes more than 10 years of professional experience in USA wif Bank of America, Freddie Mac, Morgan Stanley.
  • Currently associated wif Fifth Third Bank as Senior Data Consultant .
  • Honed skills in Service Delivery, Project Management and 24*7 Production Support.
  • Exhibited excellence in overseeing the activities pertaining to Data Analysis & Mining wif deft in ensuring the data quality for client reference data.
  • Extensive experience in database administration, software installation and patching, scripting/ programming, systems analysis and technical support.
  • High proficiency in automating reporting & back - up processes, improving database performance, ensuring maximum uptime and data integrity, and rapidly resolving problems.
  • Capacity to lead multi-skilled resources and achieve task delivery on time.

PROFESSIONAL EXPERIENCE

Confidential

Project Management

Responsibilities:

  • Managing end-to-end delivery of projects (including database administration, architecting, back up & recovery, disaster recovery, etc.), based on the Onsite-Offshore Delivery Model.
  • Designing the business solution and preparing effort/ cost estimates.
  • Working on the preparation of proactive proposals for generating new business, cost reduction and consolidation. Adhering to all SLAs as negotiated wif the clients.
  • Planning for risks and putting in place requisite measures to mitigate them.
  • Driving the set up and implementation of quality processes.Data Warehouse Administration & Architecting
  • Designing and developing databases. Providing required support to the Development Teams.
  • Handling the administration and implementation of Data Warehousing databases.
  • Administering, monitoring and tuning Oracle Databases in line wif organisational needs.
  • Managing the design and implementation of application security and database security measures.
  • Undertaking Logical and Physical Modelling using tools like Erwin and Toad.
  • Looking after 24/7 production databases administration as well as hot backups and recovery situations.
  • Developing database utilities using SQL, PLSQL, UNIX Shell Scripting and Oracle Exp/Imp and sqlldr.
  • Taking database backup and managing recoveries using SqlBackTrack tool.
  • Planning and implementing Data Base Re-organisation.
  • Designing & developing data warehouses ETL data stage 8.0.

TECHNICAL SKILLS

Programming Languages: C, C++, Java, SQL, Pl/SQL

Internet Technologies: Html 4.0, Java script 1.2, JSP, and Servlets.

Databases: ORACLE 8i/9i/10g/11i, Teradata, SQL Server & DB2, Netezza

Data Modelling Tools: ER/Studio, Erwin, Oracle designer.

GUI: Oracle D2K wif Forms 4.x/5.x/6.x, Reports 4.x/5.x/6.x, VB 5.0, Visual

Hardware: Unisys 2200, 1100/73/74, Unisys A Series, U6000/35, IBM ES9000

Operating Systems: Windows XP/NT/2000, UNIX, Aix, Solaris 10.0

PROFESSIONAL EXPERIENCE

Confidential

Consultant

Responsibilities:

  • Worked on marketing Offer systems data for value proposition systems .
  • Designed and developed data stage sequence jobs and parallel jobs for momentum system.
  • Coordinated wif the offshore testing team to get the testing completed as per schedule.
  • Involved in development of queries to identify & resolve data related problems among the available systems providing support to customers.
  • Creation of audit jobs for MOS system
  • POC project for data stage migration from 9.1 to 11.5 .
  • Conduct scrum meeting daily mornings to know sprint status.
  • Holds the distinction of developing the strategies for resolving discrepancies in data among various systems.
  • Has been involved in all stages of SDLC and ensured adherence to data policies & standards for quality assurance.
  • Successfully provided ongoing support to programs, projects & groups dat work wif datacreation of logical/physical data models.
  • Involved in development of queries to identify & resolve data related problems among the available systems providing support to customers.
  • Stellar role in creating the test plan, test strategy and end-to-end functional test scenario’s.
  • Essayed a key role in performing the bulk updates and resolved the issues found.
  • Coordinated wif the offshore team to get the jobs completed in a timely manner.
  • Functioned as a Coordinator for all project team activities.
  • Hadoop big data HDFS, pig, hive, spark, map reduce, yarn, beeline. R, Rstudio, splunk

Confidential

Senior Data Architect

Responsibilities:

  • Analyse the existing code dat is in Data stage accessing oracle database
  • Preparation of conversion document for converting the existing codes in data stage to pendato
  • Preparation of test environment for testing pentaho code and comparing wif data stage code
  • Performance improvement of pentaho code to make it equal to or better than existing code.
  • Preparation of test strategy document including methods of configuration management.
  • Coordinate wif the client to understand the improvements to be done in pentaho
  • Acts as a co-coordinator between the client, developers, testers to get the project as per schedule
  • Developing Data Governance and Enterprise Data Management Policies
  • Developing Enterprise Data Management Standards
  • Understanding of Cross-Topic Policy Alignment, policy/standards linkages
  • Analyse the existing code dat is in SAS and accessing SAS data sets
  • Preparation of design document for converting the existing codes to access Teradata database rather than SAS datasets
  • Preparation of data dictionary and source target data mappings
  • Creation of logical/physical data models.
  • Stellar role in creating the test plan, test strategy and end-to-end functional test scenario’s.
  • Coordinate wif developers and testers to get the job on time
  • Functioned as a Coordinator for all project team activities.

Confidential

Senior Data Architect

Responsibilities:

  • Holds the distinction of developing the strategies for resolving discrepancies in data among various systems.
  • Has been involved in all stages of SDLC and ensured adherence to data policies & standards for quality assurance.
  • Successfully provided ongoing support to programs, projects & groups dat work wif datacreation of logical/physical data models.
  • Involved in development of queries to identify & resolve data related problems among the available systems providing support to customers.
  • Stellar role in creating the test plan, test strategy and end-to-end functional test scenario’s.
  • Essayed a key role in performing the bulk updates and resolved the issues found.
  • Coordinated wif the offshore team to get the jobs completed in a timely manner.
  • Functioned as a Coordinator for all project team activities.
  • Developing Data Governance and Enterprise Data Management Policies
  • Developing Enterprise Data Management Standards
  • Understanding of Cross-Topic Policy Alignment
  • Track record of generating the data mart used by reporting team for developing various reports using Business Intelligence Tool.
  • Developed the business rules & processes and oversaw the implementation of the guidelines for maintaining and updating client data.
  • Involved in planning and managing all phases of the project.
  • Reviewed the business rules spreadsheets and attended the release meetings.
  • Spearheaded the preparation of the ETL data mapping for the various inputs sources and the data from Oracle tables, Excel spread sheet and MS access databases were consolidated to build the staging table.
  • Successfully arranged the meeting wif the users, prepared the synopsis of the meeting and coordinated the developer’s activity,.
  • Led the preparation of test cases and production support document.
  • Data Governance and standards
  • Holds the distinction of:
  • Developing the plans for risk mitigation.
  • Providing support and assisting the SQA (Software Quality Assurance) activities.
  • Reviewing and analyzing system documentation.
  • Preparing & maintaining the functional specification documents as per the company standards.
  • Performing the data stage job level performance tuning.
  • Working wif SME to analyze the business process.
  • Coordinating the testing wif the testing team and ensure timely completion of testing.
  • Preparing the discussion diagrams & process diagrams to explain/support business and IT management decision making.

Confidential

Project Lead

Responsibilities:

  • Led the analysis of the current system and providing feasibility analysis report for migrating to data stage.
  • Followed agile methodology for software development process.
  • Interacting wif business to understand their reporting needs and ensured adherence & following up wif the PMO defined Project Management Life Cycle Process.
  • Prepared the project schedule in MS Project and project plan including subsidiary plans for managing requirements, change, testing, communication, risk
  • Understood & managed the customer expectations.
  • Involved in investigating various options through which the jobs can be performed through data stage.
  • Has worked wif Development Team to provide schedule, status and implementation strategies.
  • Evaluated the business process by working wif SMEs.
  • Developed understanding of business objectives and requirements for all new request and ongoing support.
  • Played a key role in:
  • Creating/Updating the Data Conversion Scripts.
  • Developing the data cleansing processes, validation processes, created matrix check list before turn in to production.
  • Creating the implementation plans.
  • Coordinating the implementation activities on the development and the test Environment.
  • Liaising wif the test team and analyzing the performance in the development and the test Environment.
  • Logging the current version of the software, methodology used for Testing to star team.
  • Overseeing the interpretation and translation of highly complex requirement into functional or technical specification.
  • Prepared the Data Mapping by identifying the relationships and creating the UML (ER) Diagrams.
  • Successfully constructed the mappings wif the OWB Data Mapping tool as well as TCL based scripts accessing the OWB API. Reviewed and tuned PL/SQL.
  • Monitored/controlled the resource utilization as per the budget.
  • Successfully developed the work flow processes for acquisition, data cleansing, and loading of data, service requests for information by merchants and management along wif overall analytics.
  • Formulated the detailed the high level system documentation including the process flow charts, templates used in designing the jobs, the SQL used for filtering and a description of the various jobs involved in the process.
  • Significantly contributed in:
  • Creating the new shell script (master shell script) so dat the jobs can be run recursively for all the accounting periods.
  • Monitoring jobs using data stage director, analyze query plans, indexes, and locking behaviour
  • Preparing the initial design of tables involved in the conversion project and formulate the populating mechanism.

Confidential, NY

Project Lead /Sr. Data Warehouse Architect

Responsibilities:

  • Morgan Stanley IIG has come wif a proposal to work on a Proof of Concept (POC) for Test Data Management & Sanitization (TDMS) initially focused On Data Sanitization which is the process of making sensitive customer information in non-production environments like QA and development safe by overwriting it wif realistic looking but false data of similar type in Mainframe infrastructure
  • Defined the project tasks, resource requirements and reported the status to program manager on a regular basis.
  • The data in testing environment should be sanitized in order to protect valuable business information and client profile coz their could be a legal obligation to do so.
  • The ultimate purpose of this effort is to extract a subset of production data at will for QA/TEST purposes and sanitize business sensitive critical fields leading to the identification of the actual production records. Fields dat need to be sanitized or masked are like SSN, Employee Identification Number, Address information, Date of Birth
  • Data resides in VSAM datasets, Flat files and DB2 tables in Mainframe.
  • Led the project initiation, planning, requirement gathering and analysis and ETL tool selection.
  • Evaluated the IBM Data Stage server license & parallel license for data migration.
  • Created the sanitization algorithms for client specific fields and detailed data sanitization and masking documents were created and was peer reviewed.
  • Extracted the subset of data from production VSAM datasets for using in development environment.
  • Created source library, compile JCL library, run JCL library, object library and load library on mainframe
  • Used the Data stage Manager, Mainframe Machine Profiles has been created on Data stage to establish a communication channel between DS Server and Mainframe.
  • Conducted process analysis, impact analysis on Data stage daily batch jobs.
  • Collected data lineage statistics and generated reports on database objects.
  • Led the complex jobs were created using Data stage Designer using stages like Transform, Lookup, Aggregator, Link Collector, Merge, External Subroutine, CFF, MFF, Fixed Width flat file, Db2 Load Ready File, Relational Stage (Db2).
  • Performed SQL tuning at job level.

Confidential

Project Lead /Data Warehouse Architect

Responsibilities:

  • Successfully performed the impact analysis in replacing the existing Loan Origination System which is called as Empower wif ASAP (New LOS), Estimation and Analysis of impact of this change over downstream systems like ODS and law base.
  • Created the reports for different user groups for decision-making and the new ETL jobs/processes dat is responsible in populating the downstream systems.
  • Spearheaded the project initiation, planning, requirement gathering and analysis and ETL tool selection.
  • Gatheird the user requirement for new interfaces and discussing wif SMEs.
  • Has been assigned the tasks and coordinated wif offshore team.
  • Designed the ER-diagrams, Dataflow diagrams, module logic & data using Erwin.
  • Spearheaded the implementation of the data stage parallel edition for ETL mappings.
  • Oversaw the entire EDW planning and distribution of tasks in a team of size 20.
  • Pro-actively participated on all phases of system Development Life Cycle (SDLC).
  • Involved in the architecture team for the reporting data mart data model.
  • Contributed in:
  • Designing the error handling process and generated Error reports.
  • Managing the Logical and Physical design and implementation of Reporting Data mart
  • Creating the database definitions of the system in Oracle database and High Level Design document and Detailed Design Documents.
  • Developing the shell scripts in Linux to run the jobs from the server.
  • Developing the job sequences to run the jobs in the proper order/sequence.
  • Debugging and tested parallel jobs monitored and optimized jobs for better performance.
  • Designing the directory structures to store the files on the server.

Confidential

Data Warehouse Analyst/Developer

Responsibilities:

  • Created the ETL processes dat extract data from different source systems and transform data from Sybase, Oracle and loading into target tables in Oracle 8.1.7.
  • Designed ER-diagrams, Data flow diagrams, module logic & data using Erwin.
  • Performed data analysis resulting in requirement specifications, analysis of different aspects of the data warehouse
  • Created logical and Physical model of Design & Development of the star schema using dimensional modelling.
  • Successfully:
  • Got the data dictionary, designing and modifying the Data stage jobs using Data stage Designer Created mappings based on the data dictionary.
  • Worked on data migration from Legacy System to Sybase and was responsible for creating ETL jobs, data transformation, data loading into Oracle, duly extracting data from Sybase.
  • Mapped the source to target element mappings from legacy System to Sybase and Sybase to Oracle database using data dictionaries for different jobs.
  • Performed the unit testing and debugging jobs. Use shared and local containers, to reduce coding.
  • Used Data stage Designer to create Data stage applications (jobs), where all the required mappings, transformations, routines and formats are designed to load the data into mainframe.
  • Designed the directory structure for projects.
  • Developed UNIX shell scripts to automatically FTP data from one server to another to reduce ftp time and shell script to rebuild the co files from log files and corrupted co files. Use VI editor.

Confidential

Data Analyst/Team Lead

Responsibilities:

  • Led the development using case tool APS for review and adjustment module for the Commonwealth of Massachusetts Enforcement and Tracking System.
  • Looked after the test cases were generated to test the individual screens.
  • Performed the unit testing, modular testing and integration testing.
  • Generated the financial reports based on the financial log.
  • Involved in data analysis, forms generation and identify discrepancies using the log file.
  • Detects System is used to maintain law and order situation in the city and the new module caters to the needs of incident based reporting system.
  • Created for new online transactions accessing DMSII database using SDF plus screens.
  • Involved in WFL for certain scheduled jobs were modified.
  • Created reports using ERGO.
  • Pivotal role in developing the new modules for application entry and case maintenance system.
  • Created the new screens to support childcare wrap up mode for clerical input of childcare provider information.
  • Accomplished the database redesign the programs were correspondingly modified and tested.

Confidential Pennsylvania

Programmer Analyst

Responsibilities:

  • Essayed a key role in serial number modifications from numeric to alphanumeric for raw material system.
  • Led the DMS 1100 modifications to allow for the move of the related construction indicator from MTC record to PLM record for the FG system was accomplished.
  • Oversaw the implementation using windowing logic and field expansion technique for raw material Inventory system and finished goods system on COBOL using DMS 2200 was performed.
  • Contributed in design of new modules for supermarket applications.
  • System designing and the various screens for online transactions were formulated.
  • Screens designing for online transactions using SDF.
  • Ensured computerization of various activities of cabin stores (only bonded items).
  • Increased the efficiency of operations pertaining to inventory control, generation and maintenance of customs bond documents and stores stock was accomplished.
  • Separate options has been provided for printing the reports (hard copy) and for displaying them on the screen.
  • The system catered to the receipt storage and issue of locally procured items in the case of bonded items, all documentation is based on customs requirements whereas in the case of local items, the paper work is based on inventory control requirements only.
  • Looked after the development and maintenance of the database, item master and vendor master.
  • Meticulously performed the report prepared to give accurate information about the safety stock status, nil stock status, and outstanding purchase list.
  • Spearheaded the Automatic Boarding Control System provides accurate count of passengers passed through Security and Boarding gates, the bar code information dat is available on the boarding card is read by means of a scanner.
  • Developed the menus for the various options and maintenance of static files.
  • Led the display screens has been incorporated so dat at any given time it is possible to get details of the domestic, international, transit and pad passengers.

Hire Now