Sign in

Data Manager

Plano, Texas, 75024, United States
March 14, 2019

Contact this candidate


Shoyeb Khan




Extensive 7+ experience in developing logical and physical data models for both transaction as well as analytical systems.

Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.

Involved in all phases of SDLC (Software Development Life Cycle).

Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables.

Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.

Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.

Worked on Agile and Scrum Methodology for Salesforce custom app implementation.

Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators

Worked in different roles in the field of B2B technologies as EDI consultant, EDI Developer, Business Analyst and EDI Production Support.

Extensive knowledge of Oracle EBS Accounts Receivable (A/R) and General Ledger (GL) setup and configuration.

Have experience in debugging and problem solving skills with excellent understanding of system development methodologies, techniques and tools.

Excellent skills in System Analysis, Business process modeling, Application Design, Development and Deployment.

Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling.

Experience in analyzing the business requirements and creating Business Requirement

Document (BRD). Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.

Excellent communication skills, interacting caliber and adaptation to quick learning, ability to accomplish deadlines ability to work and lead a team.

Exceptional team player with Excellent communication and interpersonal skills, very good client facing skills and good at understanding problems and resolving them.


Providence Colleges & Universities, RI

Master’s in Business Administration with Information Technology


Data Modeling Tools

ERwin 7.1/7.2/7.3, System Architect 11.3, MS Visio 2000/2007/2010, ER/Studio, Power Designer

Database Tools

MS & SQL servers 2000/2005/2008, Oracle 9i/10g/11g, MS Access 2003/2007/2010, Teradata, My SQL, SalesForce to SalesForce


SQL, PL/SQL, T-SQL, UNIX Shell Programming, VI Editor, HIPAA

ETL Tools

Informatica power center 8.6.x,Data stage, Target Designer, Mapping Designer, Workflow Manager, MS Office

Reporting Tools

SSRS 2005/2008/2012, Business Objects

Operating Systems

UNIX, LINUX, Sun Solaris 5.8/5.9/5.10,

Windows NT/95/98/2000/XP


Humana, RI

DA/ BA/ SQL Sept 2017- Current

Worked is close coordination with the PM and the Business owners to developed project vision and define the scope of the project.

Developed Project Plan with Project manager's assistance for the first two phases of the Project.

Knowledge in SFA, Apex Classes, Apex triggers, Integration, Visual force, API, SOQL, and SOSL.

Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

Maintained a series of UNIX Shell Scripts to manage batch order processing.

Database performance monitoring and identifying bottlenecks hindering the performance of the database.

Experience in Salesforce Testing and Administration spanning all facets of package software and SaaS application implementation.

Worked with DBAs to create a best fit physical data model from the logical data model using forward engineering in Erwin.

Extensively used Erwin to model and transform date requirements in to data models and maintaining the database schema.

Hands on experience on communication protocols like HTTP, HTTPS, FTP, SFTP, SMTP, AS1, AS2, VAN.

Implemented B2B integration using EDI, FTP, FTPS, SFTP protocols.

Expert at onboarding trading partners and transferring files from test to production for secure exchange of electronic data.

Have good experience in developing translation maps for both inbound and outbound.

Translated various formats of files: XML, CSV, SAP IDOC, flat, positional, application to the standard file formats using the mapping tools.

Widely used Normalization methods and have done different normalizations 3NF.

PepsiCo, RI

DA/ BA/ SQL Jan 2016 - Aug 2017

Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.

Participate in updating the dimensional model, and identify the Facts and Dimensions.

Employed process and data analysis to model a Customer Information Business System.

Produced functional decomposition diagrams and defined logical data model.

Expert at onboarding trading partners and transferring files from test to production for secure exchange of electronic data.

Involved in customization of Oracle Forms, Oracle Reports.

Created views, procedures, and functions, packages in the Oracle Database using PL-SQL, SQL/PLUS, and TOAD.

Customized page layouts for Salesforce standard and custom objects.

Administered Salesforce CRM applications for Sales, Marketing and Support Departments. Involved in creating multiple analytical reports, with varying degreee of complexity.

Developed many complex reports using Oracle Reports 6i.

Run batch jobs for loading database tables from Flat Files using SQL*Loader.

Have good experience in developing translation maps for both inbound and outbound.

Translated various formats of files: XML, CSV, SAP IDOC, flat, positional, application to the standard file formats using the mapping tools.

Authored User reference documents on all the deliverables created for future reference by Business Users and conducted training sessions.

Documented and delivered Functional Specification Document to the project team.

Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries.

Lamda, India

JR. BA/ SQL April 2012 - July 2014

Involved in gathering business requirements by conducting a series of meetings and brain storming sessions with the business users.

Gathered and translated business requirements into detailed, production-level technical specifications, new Features, and enhancements to existing technical business functionality.

Involved in identifying the process flow, the work flow and data flows of the core systems.

Worked extensively on user requirements gathering and gap analysis.

Working on the ETL side of the process to load data into database from different servers.

Created partitions for parallel processing of data.

Developed UNIX Shell scripting for job automation and daily backup.

Involved in the analysis, design, flow, archiving of data and databases and also with their relationships.

Developed new Forms which are used to extract data from different systems and criteria. The results are written to a flat file.

Extensively used the advanced features of PL/SQL like Collections, Nested Table.

Created Indexes and Sequences for faster retrieval of the customer information and enhance the database performance.

Used shell scripting in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.

Worked on various Standard objects like Accounts, Opportunities, Leads, Campaign and Reports.

Experience in tracking errors caused by Business processes and reporting the error description/causes to trading partners/Application team.

Worked in production environment and resolved production issues in less resolution time.

Familiar with the understandings of ITIL concepts and implementing them in project.

Used the JIRA bug tracking and ticketing tool for raising the Incident, Problem, Change.

India Money Guru, India

JR. BA/ SQL Server/ BA Mar 2010 - Mar 2012

Involved in all phases of SDLC from requirement, design, development, testing and rollout to the field user and support for production environment.

Interact and understand the process requirements from the subject matter experts SME.

Identify, track, prioritize and maintain an inventory of business requirements / feature requests raise by different business units within CVS Caremark.

Developed Database Triggers, Packages, Functions and Stored Procedures usingPL/SQLand maintained the scripts for various data feeds.

Created Indexes for faster retrieval of the customer information and enhance the database performance.

Created dynamic SQL to support dynamic nature of front end applications.

Utilized SQL*Loader to perform bulk data loads into database tables from external data files.

Used the UNIX for Automatic Scheduling of jobs. Involved in Unit Testing of newly created PL/SQL blocks of code.

Good experience in Configuration of roles, profiles, user accounts, implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.

Develop business cases including business requirements for mobile application development for IOS and android-based platforms.

Analyze business requirements and perform current, target and gap impact analyses

Translated business requirements into data design requirements used for driving innovative data designs that meet business objectives.

Developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging Area Data Models and Data Flow Diagrams.

Extensively used ERwin to design Logical/Physical Data Models, forward/reverse engineering, publishing data model, applying DDLs to database, Data Modeling and restructuring the existing data Model.

Applied Discover Financial Data Naming Standards, created new naming standards, checked models in and out of ERwin Model Repository, and documented data model translation decisions.

Contact this candidate