We provide IT Staff Augmentation Services!

Project Manager/solution Architect (onsite) Resume

NY

EXECUTIVE SUMMARY:

  • 13+ years of experience in all stages of SDLC including project management, designing & planning, DW/BI application development, implementation and production support.
  • Extensive experience as a technical architect for DW/BI systems, focusing on ETL architecture, data modeling, data analysis, application design, programming and integration.
  • Proven ability to manage teams and resources for support and development projects, Plan & execute projects within stringent time constraints
  • Ability to simplify complex concepts and articulate technical problems and solutions to inform and influence a non - technical audience
  • Clear conceptual insight into Data Warehousing and Business Intelligence solutions. Worked extensively with dimensional modeling, OLAP, data transformation/cleansing/integration, ETL Processes, BI reporting.
  • Expertise in design, development, administration and maintenance of ETL artifacts using IBM DataStage, Informatica and hands on experience in SSIS.
  • Advanced knowledge data visualization concepts and tools having rich experience in BI tool Business Objects XI R2 and familiarity with reporting tool like SSRS, Tableau, MiroStrategy and Cognos.
  • Advanced knowledge of RDBMS including SQL Server, Oracle and DB2.
  • Hands on experience with for Corporate Performance Management tool Longview 7/10
  • Strong analytical, technical writing and problem solving skills

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2012/2014 , Oracle 10g/11g, DB2

DW/BI Tools: IBM Data Stage 7.5/8.1/9.1/11 , Informatica 10.2, Business Object 6.5/XI R2, MicroStrategy 9, Cognos 8, MS SSIS, SSRS, Longview 7/10

Other Tools: ERWIN 2.2, Microsoft Visio, Microsoft project, Microsoft Visual studio

Languages: SQL, PL/SQL, C, C++, Core Java, VB.NET, ASP.NET, ASP, JavaScripts, Powershell

PROFESSIONAL EXPERIENCE:

Confidential, NY

Project Manager/Solution Architect (onsite)

Tools: / Technology: DataStage 11.5, Informatica 10.2, Oracle 11g, Longview 7/10, SQL Server 2012/2014

Responsibilities:

  • Manage support team, plan and execute all stages of application implementations.
  • Assess business implications for each requirement, enhancements and translate business needs into technical terms.
  • Prepare time and effort estimates and development schedules. Assign support activities among team members. Monitor progress to meet deadlines, standards and cost targets.
  • Provide technical support to FP&A users for monthly/quarterly financial reporting, data extracts and reconciliations of financial actuals and forecasts
  • Model & architect DW design, execute the technical characteristics of the overall strategy of the data warehouse and ETL process in DataStage and informatica.
  • Involve in data analysis, volumetric analysis, designing and development of ETL and database artifacts. Identify, recommend and implement ETL process and architecture improvements.
  • Involve in integration testing, SIT and UAT and quality assurance process

Confidential, NY

Project Lead (Onsite)

Tools: / Technology: SQL Server 2008, DataStage 9.1, Oracle 11g, SAP Pack R/3, Longview

Responsibilities:

  • Planned, estimated development schedules
  • Managed development resources to ensure effective and timely delivery of projects.
  • Worked with business SMAs to determine project needs and requirements
  • Analyzed and finalized the requirement, converted it to technical specification and designed and implemented the solution with the team
  • Designed and tested database and ETL artifacts
  • Daily status reporting with offshore and client manager
  • Involve in integration testing and system testing and UAT and quality assurance process
  • Testing and perform performance tuning of processes developed by team

Confidential, NY

Project Lead (Onsite)

Tools: / Technology: SQL Server 2008, DataStage 8.1, SAP Pack R/3

Responsibilities:

  • Took lead architecture role to design SAP interfaces, worked with SMEs/functional leads to determine project needs and requirements and translate business requirements into detailed technical requirements and designs.
  • Managed development resources to ensure effective and timely delivery of projects.
  • Daily status reporting with offshore and weekly status reporting with client manager and global team
  • Coordinating work with various business and ERP global teams, internal and external third-party vendors
  • Analyzed and finalized the requirement, converted it to technical specification and designed and implemented the solution with the team
  • Established DataStage best practices and designed interface framework architecture for the offshore developers
  • Designed, tested and implemented ETL interfaces for high volume and diversified data load spread across various regions
  • Testing and perform performance tuning of processes developed by team
  • Worked with users to provides end to end support for all the functional and technical activities post go-live

Developer/ Onsite Coordinator/Project Lead

Confidential, NY

Tools: / Technology: IBM DataStage 7.5x2/8.1, Business Objects 6.5, Web Intelligence 6.5, BO 6.5 SDK, ASP.NET, VB.NET, Cognos 8.2, ErWin2.2, SQL Server 2000/2005/2008

Responsibilities:

  • Worked with clients to determine project needs and requirements as an onsite coordinator
  • Prepared time estimates and development schedules and managed and Mentor the team to ensure successful completion of project
  • Converted Business Logic into Technical Specifications and ETL mapping and design documents
  • Worked with users to provides end to end support for all the functional activities from onsite
  • Ensured on-time, quality release of systems and components
  • Provided technical direction to development teams.
  • For support projects provided support for ad-hoc tickets, planned and assigned support activities among team members
  • Managing team to ensure scheduled task monitoring and timely completion of tickets
  • Actively involved in data analysis, volumetric analysis, designing of relational and dimensional modeling and developing the Data warehouse/Data Mart along with Solution Architect.
  • Involved in integration testing and system testing and UAT and quality assurance process
  • Train and mentor junior developers
  • Prepared the requirement validation document, database and ETL technical specifications and design documents.
  • Set up ETL development environment and install DataStage in development and QA environment.
  • Designed, developed parallel and server jobs and sequences in DataStage 7.5 for extracting, cleansing, transforming, integrating, and loading data into the Data Warehouse.
  • Involved in testing, debugging and troubleshooting of jobs.
  • Wrote complex and advanced stored procedures.
  • Database and Query Optimization for better performance.
  • Designed, documented and developed multiple Star-Schema universe, Class, Dimensions, Details, Measures, contexts and organized these objects in Universe designer which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
  • Implementation of Aggregate tables to enhance the performance of reports for huge volume of data.
  • Thoroughly tested BO Universes and Reports, which include performance testing.
  • Developed web portal using BO SDK, VB.NET and ASP.NET.

Hire Now