PROFESSIONAL SUMMARY

• 14+ years of total experience in Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of Data warehousing and Database business systems.
• Experience with advanced Analytics
• 9 years of experience in Analysis, Design, Development and Implementation of Business Intelligence Projects.
• 9 years of experience in SalesforceLightning, 5 years in Salesforce CRM(cloud computing) and Teradata ARM CRM.
• Experience in interacting with the end users, gathering and documenting the requirements and suggesting the users the capabilities ofthe tools.
• Over 8 years of experience gathering functional requirements as an Analyst.
• 9 years of Data warehousing, ETL experience, SAS, Informatica V10, Power Center 10/8/7/6.2/6.1/5.2/1.7 , Informatica cloud, Ardent Data Stage 6.0 /5.1(Data Stage Administrator, Ascential Data Stage Designer, DataStage Director, DataStage Manager),Big Data, Data Junction 7.5(Map Designer, Process Designer, Meta Data Query)
• Extensive 12 years of database experience using Teradata 15/14/13/12, Oracle 11/10/9i/8i/7.x, Sybase 12.0/11.x, Toad, DB2, UDB on OS/390, NT, AIX, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2000, Oracle Report Writer, SQR 3.0, Erwin, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• 3 years of experience in TableauDesktop,TableauServer, andTableauReader in various versions ofTableau9.x/8. x.
• Excellent communication skills and ability to coordinate with multiple IT teams.
• Strong experience in business process engineering and software development life cycle, including analysis, design, development, testing, quality assurance, data quality and implementation of software applications.

Technical Summary

CRM: Sales Force CRM and Teradata CRM

Data Warehousing: Informatica Power Center, Data Stage, Cognos, Micro strategy, TableauDesktop,TableauServer, andTableauReaderData Modeling: SAS ABM, Erwin, Sybase Power Designer, Star - Schema Modeling, Snowflakes Modeling, FACT & Dimensions

Databases: Teradata 14/13/12/11, Oracle 12/11g/10g/9i/8i/8.0/7.x, MS SQL Server 2000/7.0/6.5 , Sybase SQL Server 12.0/11.x, DB2, MS Access 7.0,Teradata V2R4.1

Programming: SQL, SQL Assistant, Transact SQL, PL/SQL, Toad, Embedded SQL, Cobol, Unix Scripting, C, Java, VBScript, Visual Basic 6.0/5.0/4.0, HTML 4.0, DHTML, SOSL, SOQL, APEX, Triggers etc

PROFESSIONAL EXPERIENCE

Sales force Consultant

Confidential, Columbus, OH

Responsibilities:

• Expert in Mentoring and coaching, supervise, conducting meetings and providing overall direction to the department.
• Worked on quantitative techniques and processes used to enhance productivity and business gain.Worked on Datais extraction to categorize and to identify the behavioraldata, patterns, and techniques based on organizational requirements.
• Worked in Agile environment
• Experience with advanced Analytics, worked on measurement, test plans, Market research, segmentations, multiple channels in Nationwide including PCIO, Nationwide Financial, Nationwide Bank.
• Worked on various Salesforce.com Standard Objects like Campaigns, Leads, Accounts, Contacts, Opportunity, Forecast, Cases, Reports and Dashboards.
• ImplementedSalesforceLightning Components for small set of users for customizing reports and dashboards.
• Worked on convertingSalesforceclassic VF pages into Lighting using Lighting components and Lightning App builder
• Responsible for creating Marketing communications, segmentations and other development activities of
• Developed various functionalities using Apex Classes, Triggers, Visual Pages, Controllers Classes, and Extensions and deployed them into the Production using change sets.
• Created Workflow Rules to automate Tasks, Email Alerts, Field Updates, time dependent actions and Outbound API Messages.
• Worked on Sales force cloud implementation projects, Worked on Data Migration from Teradata to Salesforce.
• Experience with salesforce architecture, Salesforce Integration and Seibel
• Worked on Sales Cloud functionality, including Account Planning, Sales Forecasting, Opportunity Management, lead Management.
• Wrote SOSL and SOQL queries with consideration to Governor Limits to export bulk data and data modifications.
• Experience with Nationwide advisor’s data (Life, Annuity, Mutual funds etc)
• Responsible for ETL (Informatica) jobs, for CRM and TableauSymantec layer Views
• Worked on Tableau reports and Salesforce cloud computing (wholesalers to track the advisor activity).

Environment: Agile, Siebel, Salesforce.com platform, Salesforce Lightening, APEX language, Customizations, Workflows, Process Builder, Visualforce Pages, Triggers, Controllers, REST APIs, JavaScript, Web Services, Change Sets, Chatter, Sales Cloud, Reports and Dashboards, GitHub, Informatica Power center 10, Tableau Desktop, Tableau Public, SAS 9.4, Teradata SQL Assistant V15, Teradata CRM, Exact Target, ARM, Agile environment, DevOps, JIRA tools, MS office/MS Project

Confidential

Informatica/Data Warehouse Consultant

Responsibilities:

• Worked on Teradata BTEQ, FastLoads, Mloads and ETL applications environment.
• Worked on SQL assistant to retreive sql queries based on the business requirements.
• Worked on stock ledger application performance issues in Informatica.
• Developed complicated Informatica mappings for stock ledger
• Worked on Peregrine for production ticket
• Completed PL/SQL Coding related to retail Supply Chain Management systems (Oversold application and Stock Ledger application).
• Lead theIT and end user groups business meetings to collect the requirements.
• Designed the work flow and developed the code and technical requirements based on the business requirements.
• Worked on mainframe to remove and update orphan records and FTPed data from mainframe to run most of the jobs in Informatica. Worked on metadata manager
• Actively communicated with the development team to assure they were following technical specifications.
• Worked on Peregrine tool to solve most of the production and customer related issues in the form of tickets.
• Extensively creating database packages, procedures, functions etc.
• Created indexes on Reporting tables and tuned the SQL Queries for better lead times of reports.
• Worked on C-shell, K-Shell scripts for batch processing in production and also reporting side
• Was on call for entire period of time and use to manage control-M production jobs when failed
• Managed Informatica upgrade decision making.

Environment: Informatica power center 8.0/, Informatica repository manager, Power Mart 6, SAS ETL 9.2.1, Oracle 11/10g, DB2, SQL Developer, Toad, Teradata 7.1, Teradata SQL assistant, Teradata Administrator 7.1, ETL works on UNIX, Main frame, XML, HTML

Confidential, Cincinnati, OH

Sr. Business Analyst/Data warehouse Lead

Responsibilities:

• Supported an Oracle ETL application on the back end.
• Worked on Complicated Informatica mappings
• Worked on Informaica performance issues
• Completed Oracle SQL Coding related to Supply Chain Management systems for retail medicines that where distributed to multiple cities (Merchandise Application).
• Created Unix Shell scripts for daily, weekly and monthly loads into Oracle 10g.
• Participated in MI and OM upgrade process.
• Lead theIT and end user groups business meetings to collect the requirements.
• Designed the work flow and documenting the code and technical requirements based on the business requirements.
• Converted most of designs and specifications into Oracle code.
• Designed the work flow and documenting the business requirements.
• Actively communicated with the development team to assure they were following technical specifications.
• Extensively creating database packages, procedures, functions, cursors and triggers using PL/SQL.
• Participated in data modeling and designed data marts also involved in building cubes.
• Created indexes on Reporting tables and tuned the SQL Queries for better lead times of reports.
• Worked on shell scripts for batch processing in production and reporting side.

Environment: Informatica power center 7.2.0, DB2 Oracle, 10g (Staging, Data Warehouse), ETL works on UNIX, Toad, XML, HTML, Erwin (Data Modeling), SAS 9.1.3 on HP-Unix, Front end tools for MI, OM and SG.

Confidential - San Antonio, TX

Business Analyst / Data Warehouse Lead

Responsibilities:

• Worked on Micro strategy installation (server and client machines with windows 2003 operating system)
• Worked on packaging Micro strategy desktop and object manager for user installation.
• Documented requirements and gathered all the necessary specifications for the particular application.
• Worked on terminal server installations and fire call id’s set up for offshore projects.
• Created database packages, procedures, functions, cursors and triggers using PL/SQL.
• Worked on ETL and BI tool comparison matrix and was also involved in Confidential COE ‘s tool documentation.
• Actively participated in marketing performance requirement meetings and documented BRD’s.
• Completed data migration from Oracle to SQL server (meta data using Microstratergy)
• Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
• Worked on developing complex mappings in SAS ETL to load the data from different sources
• Responsible for the developing ETL processes/programs with SAS EL to extract data from the client's operational databases, Transform and filter the data, and Load it into Target database using different transformations like Source Qualifier, look up (connected and unconnected), Expressions, Aggregator, Joiner, Sequence Generator, Filter and Router transformations

Environment: Informatica power center 7.0, DB2 Oracle 10g (Staging, Data Warehouse), Toad, SQL developer, SAS, Microstratergy 8.02, XML, HTML, Erwin (Data Modeling), Cognos Power play and frame work manager.

Confidential - Newport, NJ

ETL Developer/ Analyst /Data Warehouse Admin

Responsibilities:

• Interviewed the source system owner and collected the requirements from different source systems and preparing the flowchart regarding source flow from each source system
• Installed SAS 9.1.3 on Client (windows) and Server (UNIX) for Development, Test and Production Environments and Configuring the SAS Server.
• Designed the work flow and documenting the Business requirements.
• Participated in modeling the cost objects, developing cubes and involved in high level data modeling and designing the work flow and data marts.
• Documented and designed the ETL flow according to the cost objects created and model the whole process in two different environments one in ETL phase and other in ABM (Activity Based Management) phase.
• In SAS ETL involved in working with theserver managerand creating servers for each source and model schema for the required database and other source data.
• Participated in the high-level transformation designing and generated user transformation for easy developing.
• Developed several functions and procedures in automating the source and target to run on quarterly and monthly bases.
• Maintain Development, Test and Production Repositories using Server Manager in SAS Management Console.
• Worked on Microsoft SQL Server 2005 SQL, Oracle 10g and DB2 and stored procedures, connections using OLEDB and DBMS for SAS ETL
• Wrote Shell Scripts and PMCMD to interact with SAS Server from command mode.
• Installed, Upgraded Cognos on Client and Server machines.
• Created Daily Reports, Dynamic Reports and Ad-hoc Reports.
• Created indexes on Reporting tables and tuned the SQL Queries for better lead times of reports.
• Created PL/SQL (Oracle 10g) procedures for user friendly interaction with SAS.

Environment: SAS 9.1.3 on HP-Unix, OS/390, DB2, SQL server, Oracle 10g (Staging, Data Warehouse), Toad, XML, HTML, Erwin (Data Modeling), Cognos Impromptu and Power play, PowerPlay Web viewer, PowerPlay web explorer.