CAREER SUMMARY:

• Certified BI Professional with expertise in Business Intelligence, Data warehousing, Analytics tools and Architectural best practices.
• Expertise in Big Data from Volume, Variety, Velocity, Veracity and Value perspectives.
• Projects have included Financial, Risk, Forecasting, Descriptive, Operational, Predictive and Cognitive (Adaptive) Analytics.
• Experience in solution design, Roadmaps, evaluation of current and emerging technologies, Architectural solutions.
• Leading and coordinating solution designs that effectively deliver technology solution driving higher productivity, decision making and managed, governed results.
• Data Lakes, Data Hub designs, Hadoop optimization, Hadoop sizing, Big Data strategy, Hadoop based Operational reporting system and storage system.
• Strengths include aligning IT deliverables with business needs, accelerating data discovery for business users, business intelligence reports (dashboards, OLAP and formatted reports), operational reports, data warehouse source to target maps, GAP analysis, documentation and functional testing.
• Wealth of product knowledge on all Data Warehouse, BI and Analytic tools and Hadoop distributions from ETL to Data Structures.
• Familiar with all phases of SDLC, Agile, ITIL and RAD.

TECHNICAL SKILLS:

Reporting Tools: SAP/Business Objects, COGNOS, Micro Strategy, Crystal Reports, Tableau, Qlikview, SAP BI4, SPSS Modeler Premium and SAS Base (Analysis of BRIO, Datameer, Hyperion Financial, FOCUS and WebFocus reports)

Analytic Tools: R Studio, Pentaho (WEKA), SAS RapidMiner, SPSS Modeler, IBM Watson Data Explorer, ANOVA, MS Analysis Services

Data Quality /Data Profiling: Trillium TS Insight, TS Discovery, TS Quality, Dataflux (SAS), DQXi, IBM Quality Stage, Melissa Data, QAS (Experian), Microsoft SSIS / Data Quality Services, Spectrum (Pitney Bowes) and Informatica Power Center and Rules Point

Data Warehouse: Kimball, Inman, Federated

RDBMS: Oracle, Teradata, Informix, EPM (PeopleSoft), Sybase, DB2, MS SQL Server

SQL Tools: SQL Server Management, RapidSQL, TOAD, SQL Assistant, Queryman

ETL Applications: DataStage, Informatica, Ab Initio and SSIS

Modeling Tools: Erwin, Enterprise Architect and Embarcadero

Big Data: Data Integration Hub, Deep Analytics Environment, Archive Storage and Data Lake

NoSQL: HBASE, Couchbase, Cassandra, PostgresSQL SOLR and Mongo DB

Hadoop Distributions: Cloudera, IBM Big Insights, HortonWorks 2.X, Azure (HD Insight)

Hadoop Tools: Scala, SQOOP, Pentaho, Datameer, Informatica, HDFS, PIG and HIVE

Compliance: HIPAA, HITECH, GLBA, SOx, FCRA, OFAC, Security/Privacy - PHI, PCI, PII

SFA Systems: Siebel, Salesforce.com, SalesLogix, Goldmine, Telemagic, ACT

Other Systems: HP Service Manager, Peregrine, ServiceNow, PureShare, HP Quality Center, Longview's Khallix Budgeting & Forecasting products, FiServ

Finance Systems: Oracle Financials, EPM (Peoplesoft), MAS 90, MAS 500 and SunGard (Analysis only) and Microsoft Dynamics AX (Analysis only)

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior Manager

Responsibilities:

• Technology Platform support
• Data Hub creation and design using HBASE / Hadoop (Hortonworks/ Azure HD Insights)
• Coordinating Analytics tools choices and training related to Business Intelligence and Visual Analytics
• Guiding principles on COTS Application Solution design, Data Management, Content Management, Visual Analytics, Data Analytics, Forecasting and Risk Analytics.
• Support of Academic program to deliver introduction to Visual Analysis, Data Preparation and Reporting best practices.

Confidential, Somers, NY

Big Data Analytics Solutions Architect

Responsibilities:

• Coordinating Analytics deliverables for all aspects of consulting firm
• Guiding principles on Application Solution design, Data Management, Mobile delivery, Content Management, Visual Analytics, Data Analytics, Forecasting and Risk Analytics.
• Guide strategy on Analytics environments, infrastructure and tools.

Confidential, Alpharetta, GA

Big Data Analytics Solutions Architect

Responsibilities:

• Coordinating Global Analytics deliverables for international consulting firm.
• Guiding principles on Application Solution design, Data Management, Mobile delivery, Content Management, Visual Analytics, Data Analytics, Forecasting and Risk Analytics.
• Guide strategy on Analytics environments, infrastructure and tools.

Confidential, Deerfield, IL

ESS Solutions Architect

Responsibilities:

• Infrastructure and Technical Architectural guidance on sizing, construction and design of Reporting and Analytics Environment Solutions for Reporting, Visualization & Analytics.
• Involved with all Infrastructure, Integration, Information, User Interface and BI Architectures issues.
• Working with Logical Data Warehouse concepts using Hadoop, Traditional RDBMS and In - Memory Data Warehouse appliances.
• Working with HDP 2.1, Netezza, Teradata, Oracle Exadata and DB2 BLU
• Guiding principles on Visualization environment construction
• Guided Documentation of all Data Flows related to systems and Data Marts.

Confidential, Northbrook, IL

Big Data / Analytics Information Architect

Responsibilities:

• Evaluation of Hadoop 2 distributions and conversion to Cloudera CDH4.5
• Big Data solutions with unstructured, sensor data and sentiment analysis
• Improved performance on Dashboard reporting using Xcelcius 200%
• Claims, Risk, Fraud, Pricing and Sales oriented reporting solutions.
• Aided in selection of Data Profiling and Quality Tools.
• Guided Documentation of all Data Flows related to systems and Data Marts.

Confidential, Libertyville, IL

Sr. Business Intelligence Analyst

Responsibilities:

• Data Profiling using Dataflux.
• Documented requirements for reports and Assets, Payments, Delinquency Topics and System requirements.
• Managed conversion of reports from WebFocus to Business Objects or Qlikview
• Agile Story Creation, Documented Business Rules, Functional and Non-Functional requirements.
• Created Acceptance Criteria, Tasks for Development Teams and Estimations for current and future projects.

Confidential

Business Analyst

Responsibilities:

• Worked with Marketing Analysts on Data Quality and Standardization of the Data Warehouse data. Gathering requirements, documenting customer needs and aiding in profiling of the data.
• Documented Business Rules, Functional and Non-Functional requirements in Caliber tool.
• Created test cases and test plan for data quality tool and process in HP Quality Center

Confidential

Lead Business Analyst

Responsibilities:

• Member of the CL Replacement Project team. Gathering requirements, Documenting customer needs and Rationalizing reports to the new loan system.
• Aided in new design of new data model to accommodate new source system.
• Worked with the ETL team to develop new ETL scripts in Data Stage.

Confidential, Cleveland, OH

Lead Business Analyst

Responsibilities:

• Lead Data, BI and Integrations efforts. Gathering requirements, Documenting customer needs and Developing reports out of a data warehouse. (Converted 5 reports 3 new reports)
• Designed new Kalido structures to accommodate source system data.
• Developed new ETL scripts in Informatica to populate tables in the data warehouse. Khallix based applications were used for some of the financial data.
• Project: Treasury Securities - Sungard Treasury Application Upgrade

Confidential, San Francisco, CA

Lead Business Analyst

Responsibilities:

• Member of the Commercial Tools team. Gathering requirements, Documenting customer needs and Rationalizing reports to the new loan system.
• Worked with the SQL Server Developer to develop new ETL scripts in SSIS.

Confidential, UT

Crystal Reports Developer

Responsibilities:

• Developed 13 new reports.
• Upgraded the report server - platform to Business Objects Xi.

Confidential, Ogden, UT

Project Manager/BI Analyst

Responsibilities:

• Managed all phases on the creation of a new Data Warehouse. (Scope, Plan, Implementation, Testing)
• Guided Data Integration effort using Kalido software, MS SQL Server 2005 and custom applications.
• Managed output of OLAP cubes, new reports and clean up of existing reports.
• Evaluated BI solutions from vendors (Microstrategy, Talend, Qlikview and Business Objects) Including comparison matrix. Vendor for selection process
• Designed reports and OLAP solution to satisfy requirements

Confidential, Dallas, TX

Project Manager/BI Analyst

Responsibilities:

• Worked with team of Crystal Reports and Business Objects developers on the modification of all reports.
• Coordinated effort with new application development and Data warehouse team. Oracle, Golden gate and Toad were used for data analysis.

Confidential, San Jose, CA/Draper, UT

Staff Analyst

Responsibilities:

• Coordinated a global effort between Customer Service management around the world.
• Lead requirements gathering, JAD sessions.
• Improved accuracy of data and automated reporting for contact management and customer satisfaction surveys. Reduced expenses and decreased time to retrieve data.
• Integrated SalesForce.com, Blue Monkey and Phone Data(Avaya/Aspect) into Data warehouse. Facilitated communication with telecommunication group and end users. Eliminated changes in presentation of data. Ireland, German, Canadian and U.S customers.
• Created phone reports out of the data warehouse and, improved use of data for trending, analysis, and forecasting. Source of the data was an enormous Teradata data warehouse. Micro Strategy based solutions. Queryman and SQL assistant were used for queries.

Confidential, Long Beach, CA

Project Manager/Functional Analyst

Responsibilities:

• Analyzed current usage of applications, developed recommendations and advised business users on possible enhancements or changes. Queries using Toad and PL/SQL in an Oracle based data warehouse. Sources included khallix Longview, Peoplesoft HR and EPM Finance modules.
• Designed, documented and created COGNOS ReportNet and PowerPlay cube reporting solutions. Reduced reports from through rationalization and standardization.
• Reduced time for monthly close process from over five days to three days through improved data warehouse delivery of transactional data.
• LEAN and Six Sigma project environment

Confidential, Cypress, CA

Project Manager/Business Systems Analyst

Responsibilities:

• Managed Application and Reporting Projects. (Resources, Budgets and Plans)
• Designated as SOX audit stand in for Project Managers based on technical knowledge and performance facilitated more efficient audits reducing number of citations during audits.
• Created functional and conceptual design documentation for reporting and application development projects.
• Analyzed current usage of applications and presented recommendations to business users on possible enhancements or changes.
• Designed, documented and created Business Objects and Crystal Reports reporting solutions.