PROFESSIONAL SUMMARY:

• Technology Consultant specializing on Business Analytics, Solution Architecture and Project Management.
• Experienced in Banking, Brokerage, HealthCare and Supply - Chain Management domains.
• Project Management and Business Analysis Skills
• Strong ability to facilitate JAR-sessions and requirements gathering discussions.
• Skilled in conducting system analysis for various technological architectures.
• Experienced in object-oriented analysis and design, Service Oriented Architecture (SOA).
• Proven analytical and modeling skills.
• Ability to translate business requirements into IT deliverables.
• Extensive experience in technology projects following Waterfall or Agile.
• Excellent at hosting and running senior level meetings and following up with meeting minutes.
• Senior-level knowledge of relational databases; expert-level SQL skills.
• Experience working in multicultural environment, working with offshore/outsourcing teams.

TECHNICAL SKILLS:

Data repositories: Teradata, MS-Access (SQL/Macro/Screen Design), SQL-Server, DB2 (SQL/ utilities)Data Warehousing (DW), Data Mining, Informatica IDQData modeling (ERWIN data modeler), SQL tuning.

Business Intelligence: SAP - ECC, SAP-BW, SAP-Business Objects, SS&C Varden-Reporting, IBM-COGNOS.

Big Data products: Hadoop-DFS, Hive, NoSQL

Products and tools: MS OFFICE - (Word/ Excel/ Visio/ Power Point/ Outlook), SharePoint 2010; UML notations;

ETL, EDI, NDM, SWIFT, HP: ALM.

EXPERIENCE:

Confidential

Integration Manager /Sr. Business Analyst

Responsibilities:

• Responsible for end-to-end leadership from requirements gathering through implementation of solutions.
• Responsible for creation and enforcement of standards and design patterns for integration.
• Conducted agile development of multiple independent work streams within the project structure.
• Managed on-going communication with business stakeholders.
• Performed functional and structural analysis of various ERP systems (SAP-ECC, JD Edwards, Oracle-EBS);
• Involved in defining logical and physical models of Teradata-based EDW elements.
• Defined data integration processes, determined scale, scope and goals of data integration.
• Prepared high-quality technical documentation - created technical documentation for architected solutions.
• Recommended Data Governance policies and processes to improve Data Quality standards: business rules, data definition, referential integrity.
• Designed processes to support Procurement-centric Master Data Management (MDM) integration.
• Conducted in-depth data analysis, using advanced SQL.
• Defined SIT and UAT strategy; provided analytical and technical support to UAT team.
• Supported creation of a BI Tool solution (IBM-COGNOS, TABLEAU) and implementing enhancement to existing integrations.
• Delivered End-to-End product maintenance, including: Incident Resolution and Service Request Fulfillment.

Confidential

Release Manager

Responsibilities:

• As a Release Manager of team of 30 on/off-shore resources, evaluated agile framework and metrics.
• Managed backlog development and prioritization, created Agile release plans, sprint planning.
• Created implementation plan, including dependencies/predecessors to support scheduled deployment.
• Coordinated release content and effort based on a request backlog and roadmap.
• Participated in all Change Advisory Board (CAB) activities.
• Created key documents and presentations to support SDLC processes.
• Ensured release dependencies are surfaced, understood and associated risks are appropriately managed.
• Coordinated department-level and enterprise-level release communications.

Confidential

Lead Business Solution Architect

Responsibilities:

• Conducted JAR sessions with corporate end-users to gather requirements for successful implementation of Oracle-EBS;
• Led Inventory Management and Procurement focus-groups;
• Performed root cause analysis of business issues; identified gaps, risks and potential impacts;
• Assisted in identifying and customizing RICEW (Reports, Interfaces, Conversions, Extensions, Workflow);
• Involved in Conference Room Pilot presentations and other business/technology workshops;
• Defined Key-Design-Decisions (KDD).
• Designed test cases; overseen SIT end-to-end testing.
• Provided functional support and to end-users.
• Prepared full range of standard documentation: User Stories, Business Requirement Documentation (BRD),

Confidential

Lead Data Architect

Responsibilities:

• Conducted business study with stakeholder to find project-level consensus.
• Developed solution strategy: involved in creating normalized logical data model for TERADATA-based DW.
• Conducted data profiling and data normalization effort; managed configuration of ETL’s to extract data from array of sources and convert them into database structure.
• Designed processes to support Inventory-centric Master Data Management (MDM) integration.
• Performed business-oriented and metadata-level data analysis, using advanced SQL skills and procedures.
• Led workshops to define and configure BI-reports (SAP-BO, TABLEAU).

Confidential

Sr. Business System Analyst

Responsibilities:

• Conducted requirements elicitation with local and overseas stakeholders;
• Developed Use Cases supported by UML diagrams;
• Designed and maintained high complexity SQL’s.
• Conducted technology workshops, involved in buy-or-build collaboration.
• Drafted Data Governance framework: improving Data Quality’s standards; designed business rules repository, data definition constrains, referential integrity; drafted Data Dictionary; created data cleansing formulas, data mapping matrix.
• Designed Master Data Management (MDM) integration path.
• Designed logical and physical model of new DB2 database.
• Coordinated configuration of SS&C Varden-Investment Reporting.
• Maintained SDLC-type documentation for the product’s release.
• Created user book; conducted user sessions.
• Served as a contact point production support.

Confidential

Sr. Business System Analyst

Responsibilities:

• Elicited functional requirements via meetings with SME and by studying regulatory documents.
• Implemented full project life cycle phases including business stakeholder interviews, requirements gathering, producing BRD documentation and providing functional specification for developers and QC.
• Developed conceptual model of reporting Data Warehouse; developed logical data model; drafted entities and defined their attributes;
• Led walkthrough sessions to communicate requirements and functional specifications to IT team members.
• Created project presentation for senior management.
• Prepared system test plan.
• Created user book; solely accountable for conducting sessions.

Confidential

Sr. System Analyst

Responsibilities:

• Analyzed business requirements
• Designed, coded and tested modules integrated into existing architecture of DB2 Stored Procedures and
• MQ messages.
• Interacted with local and overseas business teams to create logical data models.
• Created visual presentation and detailed project plan; created system and program specifications.
• Defined relationships between various data objects.
• Involved in design, coding and testing of application programs.
• Responsible for integration SWIFT and MQ solutions into existing application framework.