Data Web Developer

Satya Prakash Mishra, PMP, CSM

Contact: +1-213-***-****

Email:*********@*****.***

Location: Los Angeles, CA, USA

Citizen Status: Permanent Resident (Green Card holder)

SUMMARY

Certified project management professional (PMP) and scrum master (CSM) with 20+ years of global IT experience in performing project management, managing resources, providing software solution and architecture, development, business analysis and data analysis.

10+ year of experience in leading teams of 20+ members, working in onsite offshore model and handling multi-vendor teams

Vast experience in Data warehouse and BI analytics, analyzing business and function requirements, data modeling, data analysis and validation, data migration and reporting

Baselined requirements and effort estimates

Identified project team members’ roles and responsibilities

Prepared project schedule detailing all tasks and deliverables to be performed and monitored the same to completion

Created detailed project management plan describing processes to be followed in the project

Prepared transition plan including budgeting time, methodology and preparation of evaluation methods for the same

Created project status report for stakeholders

Evaluation and appraisal of team members.

Mentored junior team members, shared knowledge with peers and team building

Contributed in RFP and other organizational works e.g. hiring, interviewing etc.

Worked directly with customers and users of the systems to identify their business processes, rules and application user requirements

Prepared functional specification, solution & technical design and system mapping documents

Designed logical and physical data model

Built ETL jobs in SAP BODS and Informatica

Created tables, views, PL/SQL scripts (stored procedures, functions, packages, triggers), indexes, Materialized Views, Snapshots, Constraints, arrays, varrays, nested tables, Sequence keys etc. in Oracle and SQL Server

Performed performance tuning and optimization on large Oracle OLTP databases and addressed data quality issues

Performed work review, unit testing, integration testing and system testing

Actively contributed in implementation, change and release management

Experience in G&G data management and implementing Geological and Geophysical tools for Oil and Gas upstream

Implementation of EPOS /Petrel across multiple business units

Seismic, faults, horizons, cultural data, drilling/production & well data Cleansing, Loading, Migration from OpenWorks, Seisworks to Petrel and EPOS framework through various utilities and their Quality Check with the help of different tools such as InnerLogix

Ensured data management standards and processes are followed to maintain Data Integrity and quality

Designed the UI, business, data layers, database and data loading methods

Designed and developed web forms using ASP.NET, ADO.NET, and Visual Studio 2008

Developed UNIX shell scripts to kick off automated jobs, manipulate files and monitor system performance, load data and generates reports

Deployment and post implementation Support

Generated Manual and automatic reports

Investigated incidents received from help desk and coordinate resolution and recovery actions for assigned incidents, Service Requests and Change Requests.

Installed and configured vendor software.

Imparted end user training.

EXPERIENCE

Project Manager – Cognizant (July 2012 – Present)

Currently working as engagement lead cum Sr. Data Analysts for a renowned banking company in the USA. In this role, I am managing Cognizant’s BI team, working as POC for client, performing data modeling, data analysis and validation, ETL development in SAP BODS, Informatica Cloud and Snowflake. Migrating data from centralized on premise data warehouse to Snowflake Cloud by using Informatica Cloud.

Worked as an Application service manager and on-boarded BI applications from several regional IT support teams to a centralized global support team to provide efficient and better support for a major pharma company in the USA.

Worked as BI Project Manager and Solution Architect: In this role, I was responsible for managing the project team as well as creating system architecture for a BI reporting project developed in Informatica, Qlickview and Oracle for a major pharma company in India.

Worked as Sr. Data Analyst and performed data analysis and data validation, creating data model and built a data warehouse for an Indian Insurance company in India

Worked as BI Project lead and managed a BI team for a BI reporting project for a major communication company in India

Worked as Sr. Oracle Developer and in this role performed data analysis and data validation and developed database coding in Oracle PL/SQL for a major communication company in the USA

Sr. Software Engineer/Project Lead/Manager – L&T Infotech (Sep 2004 – July 2012)

Worked as Project Manager and Sr. Data Analyst for G&G data migration project for a major oil and gas company in the USA. In this project, I managed project team of LTI, implemented G&G tools across the globe and migrated data from old systems to new G&G applications.

Proposed and managed CBT on G&G applications and tools.

Worked as Sr. Software developer cum Onsite team lead in ADM projects developed in Oracle, SQL Server, Unix, ASP.NET, Java Script and few 3rd party tools for a major Oil and Gas company in the USA.

Sr. Software Engineer – eClerx Services Pvt. Ltd. (May 2003 – Aug 2004)

Worked as Sr. Web Developer and developed web application in ASP.NET, Java Script and SQL Server for a technology company in the USA.

Sr. Software Programmer – Intelecorp Software India Pvt. Ltd. (Nov 2002 – May 2003)

Worked as Sr. Web Developer and developed B2C web application in ASP, Java Script and SQL Server.

Software Programmer – Zett Media (Aug 1999 – Nov 2002)

Worked as Web Developer and developed web applications in ASP, Java Script, Oracle and SQL Server.

PROFESSIONAL AND TECHNICAL SKILLS

Area

Skills

Database & Tools

Oracle PL/SQL, MS SQL Server, SQL Developer, SQL Navigator, TOAD, SQL Analyzer, Erwin, Data modeler, SQL Loader and Snowflake DB

ETL Tools

Informatica Cloud and SAP BODS

Web Technologies

ASP, ASP.NET, VB.NET, JavaScript, HTML, CSS, Visual Studio and Team Foundation Server

G & G Tools

Openworks 2003, R5000, Seisworks, EPOS 4.0, Petrel, Innerlogix, ULA and Gocad

BI & Reporting

Qlikview, SSAS, SSIS and SSRS

Other Technologies & tools

UNIX Shell Scripting, OHM, Zytax and Org publisher, SwiftKanban

Project Management

Visio, MS- Project, Waterfall, Agile, Scrum, Kanban, Confluence

CERTIFICATIONS

Scrum Master Certification (CSM) from Scrum Alliance (Certification ID – 001107143)

Project Management Professional (PMP ) from PMI (Certification ID – 1233409)

Foundation Certificate in IT Service Management (ITSM)

Microsoft certified professionals (Desktop VB6.0) ( MCP) (Certification ID - Y0IBPATV4)

Brainbench certified in ASP, XML, HTML, Visual Interdev

Excellent performance award in C language from CSI (Computer Society Of India)

Completed Salesforce Admin course

Completed Big data (Hadoop, Map Reduce, Hive, Pig and Hbase) course

Completed Snowflake’s Hands On Essential – Data Warehouse training.

EDUCATION QUALIFICATIONS

Degree

School / University Name

Year of Graduation

Specialization

Post Graduate Diploma

ICFAI (The Institute of Chartered Financial Analysts of India)

2006

Business Management

Post Graduate Diploma

C-DAC (Centre for Development of Advanced Computing)

1999

Advance Computing

Bachelor of Engineering

Govt. Engineering Collage Raipur (NIT, Raipur, CG )

1997

Mining

HONORS & AWARDS

Received appreciation from client and Star Award from L&T Infotech in Nov 2011 for suggesting and managing CBT on G&G tools, which saved effort, time and cost to train resources.

Received appreciation from client and Team Award from L&T Infotech in Nov 2010 for implementing G&G tools across client’s business units.

Received Team Performance Award from L&T Infotech in 2009 for suggesting and implementing effort saving and cost effective solutions to the client for the ADM project.

Received appreciation from client and Star Award from L&T Infotech in Nov 2008 for suggesting, developing and implementing a web based application to remove manual process of uploading excel files into a 3rd party tool.

Contact this candidate