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.