Pratyush Singh

Phone: 614-***-****

E-mail: adjlwb@r.postjobfree.com

Summary:

• 16+ years of experience in both client facing and internal roles as a critical thinker, upbeat and eager to learn cutting edge technology. Helped improve operational efficiency and ROI using a broad range of skills: Budgeting, Planning, Developing technology/product roadmap, Project Management, Solution Architecture, Data, Management, Data Infrastructure, Data Modeling, Data Engineering, Data Validation, Data Analytics, Dashboard and Visualization, Data Flow Diagrams, Requirement Gathering, QA testing

• Experienced in Data Governance, Data Quality, Master Data Management Methodologies, Data Stewardship, Data Lineage, and implementation/enforcement of external regulatory compliance like CCPA and HIPAA law

• Experienced in implementing data governance solution with defining, approving, documenting, communicating, tracking, and enforcing conformance of data strategies, policies, standards, architecture, procedures, and metrics

• Expertise in Leadership, Team Building, Managing, mentoring onsite and offshore team and produce quality deliverables

• Excellent in presenting solution/product to the customer/business and technology stakeholders effectively.

• Managed project and done documentation in waterfall and agile project environment Technical Skills

BI/OLAP Tools: Microstrategy, Hyperion Brio, Qlik, Cognos, Business Objects RDBMS: Netezza, Teradata, Oracle 10g, SQL SERVER, MS Access Packages: Microsoft Office Suite, CVS, SharePoint

Operating Systems: Windows 2000/98/95/98, Windows NT, MS DOS Ascena Retail Group, New Albany OH Date: May 2010 to Present Role: Sr. Business Intelligence Developer

Responsibilities:

• Led design sessions with business to brainstorm, gather, and document project deliverables.

• Translate requirements into solution that provide high quality information for business insight and action.

• Understand and improve end to end Business Intelligence (BI), Data Warehousing (DW) and Data Landscaping environments to help business make more informed decisions.

• Drove the collection of metrics, dimensions and reporting pain points for business.

• Designed and developed multiple dashboards with visualizations and images

• Led and implemented multi-terabyte database migration from Oracle to IBM Netezza and Netezza to Teradata.

• Created multiple inbound/outbound ETL scripts.

• Performed Hyperion Brio to Microstrategy reporting and Microstrategy version upgrades.

• Worked on migrations strategy of databases to AWS. Involved in pricing and feasibility discussions.

• Design, develop, test and performance tune queries, interactive reports, multidimensional cubes while following corporate and industry best practices.

• Integral contributor in multiple high impact and visibility package implementations like JDA for Allocation, Markdown and Size pack Optimization, Advanced analytics projects as well as Multiple planning tools.

• Created and deployed multiple reporting solutions using Microstrategy, Qlik visualization as well as custom solution leveraging Microsoft Excel and VB.

• Performed data modeling tasks for numerous subject areas being loaded in EDW. Environment: Microstrategy, Netezza, Teradata, AWS, Qlik, Hyperion Brio, Aginity, UNIX, MS Office suite, Jira

Boston Scientific, Minneapolis MN Date: Jul 2008 to Apr 2010 Role: Business Intelligence Architect

Responsibilities:

• Led team that provided a roadmap for data architecture, data governance, business intelligence and analytics

• Drove the functional and technical review for the Business Intelligence environment

• Provided technical guidance for design and implementation of data storage and governance systems.

• Worked with Business users for requirement gathering for Cognos and Oracle Discoverer reporting

• Created Design documents and Business layers for Cognos & Discoverer mappings

• Worked as test coordinator for creating Formal Test cases and UAT scripts

• Created multiple deliverable documents based on the GSM methodology being followed by the client

• Worked as test coordinator for creating OTSS validation document, Formal Test cases, bug tracking

• Worked with Business users and Stake holders to create UAT test scripts

• Involved in masking of Personal Health Info (PHI) data columns in multiple database tables and views Environment: Cognos 10.x, Oracle Discoverer, Informatica, TOAD, UNIX, Windows 2000, MS Office suite Tween Brands Inc., New Albany OH Date: Mar 2007 to Jun 2008 Role: Business Intelligence Developer

Responsibilities:

• Worked on the complete SDLC for the reporting systems

• Created Functional and Technical Design documents for the various deliverables

• Participated in JAD sessions for client specific development of reporting systems using Oracle Report 6i and Oracle BI Discoverer 10g for Enterprise Data Warehouse Team as well as Oracle Application 11i.

• Worked on Security Architecture for implementation of Row Level Security (RLS) for Enterprise Data Warehouse using Oracle VPD

• Worked on query tuning of various SQL Queries, Oracle reports using explain plans, SQL Trace, hints, Indexes

• Designed and Conducted end-user training sessions for exercising full use of Portal and Interactive reports

• Worked as test coordinator and Business Teams for creating Formal Test cases and UAT scripts, OTSS validation document, Formal Test cases, bug tracking

• Designed and monitored end-user reporting tools and systems, ensuring reports are accurate and up-to-date. Environment: Oracle Application 11.5.10(GL, AP, AR), Discoverer 10g, Oracle Reports 10g, TOAD, Unix, Windows 2000, MS Office suite

Occidental Petroleum, Huston TX Date: Oct 2006 to Feb 2007 Job Title: Business Intelligence Developer

Responsibilities:

• Responsible for architecting, scoping and redeveloping analytics and reports from BO to Oracle Discovere

• Analysis & Documentation of process to be used for conversion of over 300 Reports from Business Objects to Discoverer 10g and Oracle reports.

• Developed and documented the designing of the 9 Business Areas during the project.

• Personally developed more than 150 reports during the span of the project from different modules like GL, AP, AR, PO, INV, JIB, AFE and REV. Leveraged SQL and PLSQL to implement custom reporting solutions.

• Worked as the Single Point of Contact and coordinator between the Client & the Offshore Development Team.

• Provided training in Classroom sessions for the new users.

• Worked closely with key stake holders to provide production support for the reports & the Business Areas Environment: Oracle Application 11.5.10(GL, AP, AR, PO, INV, JIB, AFE, REV), TOAD, Discoverer 4i/10g, Oracle Reports 6i, Windows 2000, Business Objects 5.x. Education:

• M.S. Electrical Engineering, Texas A & M Kingsville, Texas, US

• Bachelors of Engineering Electronics and Telecomm, Amravati University, India

Contact this candidate