SUMMARY

• Sixteen years of software experiencewith over six years of technical lead & managerial experience in data warehouse development asBusiness Intelligence/ Data Warehouse Manager, Architect.
• 11+ years of experience in Data Warehousing (Dimensional Modelling, Database design and ETL) and Business Intelligence (Reports, KPI, Scorecards and Dashboards).
• Architected data warehouse from requirements gathering to conceptualization to creation of data marts usingInmon and Kimball methodologies.
• Data Architecture (Conceptual, Logical, Physical) experience involves building 2.5 Normal form & Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, and KPI} using Erwin, ER/STUDIO, Power Designer .
• ETL Architecture experience involves defining different layers (landing/staging, recovery point layers) complete ETL schedule and flow to fit SLA, mapping design, Error handling and Workflow Design on Informatica Power Center 5x, 6x, 7x, 8x., guided team on SSIS and Datastage.
• Expertise in creatingcomplex reportsin various reporting solutions. Expertise in BI reporting tools like Business Objects, Crystal Reports, MicroStrategy, Tableau, SAS, Pentaho, Cognos.
• Possess clear understanding of the business intelligence elements such as OLAP, Forecast analysis, BI Reporting, Management reporting, financial reporting, Dashboards, Scorecard, and Alerts.
• Solid experience Analysis, design and Implementation of BI applications using Microstrategy 9i/8i/7i including MicrostrategyDistribution services, OLAP Cubes and Microstrategy mobile.
• ImplementedMicrostrategy objectssuch as attributes, facts, hierarchies and complex metrics that conform to the dimensional and de - normalized data models.
• Experience in developingdynamic Dashboards and Scorecards.
• Worked / reported directly to / with the CIO, CFO, and Director of Operations, initiated, conceptualized, personally developed, and customized an EIS / Dashboard program / approach for President level reporting, broker analysis, and national accounts.
• Architected the projects and created Schema Objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Drill maps.
• Strong expertise as solution architect designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options, benchmarking & tuning (application, database and hardware) for test, development and production environment.
• Served as business intelligence group leader for all communications, service responses and issues in several projects right from requirements until installation and post production.
• Worked with high performance teams developing and implementing state-of-art data warehouse applications. Ability to understand the business needs in terms of business value.
• Strong experience working with Pentaho 7 reports and Ctools dashboards.
• Managed and mentored 20+ team technically to deliver solutions, both partner and company
• Designed Data Warehouse with 36+ TB of Compressed Data and ETL layer loading 400 mn records for one adapter with multiple batch size.
• Hands on experience in writing RDBMS, ANSI SQL, PL/SQL, and T-SQL programs in Oracle, SQL Performance tuning and stored procedures, SQL Server, MS Access and Sybase, DB2, Teradata. Extensively used DTS Packages, query management tools like Query Analyzer.
• Awarded Best BI consultant award for revenue cycle management project.
• Highly adept at promptly and thoroughly mastering new technologies with a keen awareness of new industry developments and the evolution of next generation programming solutions.
• Conceptual thinker, results oriented, creative, thorough, initiative, technical, pragmatic, Proactive, analytic/ systematic thinking, excellent written and verbal communication skills, great problem-solving skills, able to identify and justify the optimum solution.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows NT/ 95/2000/XP, MVS

Scripting Languages: Unix Shell Scripting, PERL, ANSI SQL, T-SQL, PL/SQL, Focus, VB Script, Java Script, HTML, XML, XSL.

Reporting Tools: Business Objects 6.5.1/XI R2 SP2, Crystal Reports 7.0/ 8.5/9.0/10/ XI R2 SP2, Cognos, Tableau, Microstrategy 9i/8i/7i, Pentaho

ETL Tools: Data Stage, Informatica 6.0/5.1, Power Mart, Power Center, Oracle Warehouse Builder, DTS, AbInitio

Business Intelligence tools: Desktop Intelligence, Reporter, Designer, Supervisor, Web Intelligence, Broadcast Agent and Publisher, Big Data (under training), Report Studio, Query Studio, Framework Manager, Analysis Studio, Metric Studio, Event Studio, Data Manager, Access Manager, Transformer, Power Play, Power Play Web, Upfront, Impromptu Administration

Data Bases: Oracle 8i/9i/10g, Sybase 12.0, Teradata, File Maker Pro 5/7, MS Access, SQL Server 7.0/2000/2005 , SQL Server, DB2

Web, Client-Server and Desktop: ASP, JSP, MS Visual Interdev, VB6, .NET, XML, CSS, MS Office, MTS, COM, DCOM, and Web Logic Server

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Cassandra, Oozie, Flume, Chukwa, Pentaho Kettle and Talend

Quality Standards: SEI-CMM /CMMI, ISO 9000, PCMM

Data Modeling and other tools: ERWin 3.x/4.x (Data Model Mart), ER STUDIO 8.0/8.5/9/9.0.1 , Rational Rose, Sybase Power Designer, Smart Draw, ERD, Test Director, Data Cube, ETL Informatica, TOAD (Tool for Oracle Application Developer), PVCS Version Manager, Visual Source Safe, IPMS, Clear Case.

Testing life cycle: Test cases, setting up test environment, test execution, verification of test results

Projects management: Technical Lead, Project Leader

PROFESSIONAL EXPERIENCE

Confidential, Downers Grove, IL

Senior Business Intelligence Architect

Responsibilities:

• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, Architecture and Reporting.
• Determined requirements using business analysis, interviews, surveys, business process descriptions, use cases, scenarios, etc.
• Designed efficient BIDynamic Dashboardsfor the business users with dynamic prompt answers and with multiple data sets in both Microstrategy Desktop and Microstrategy Web.
• Designed and developed Dashboards using Microstrategy Report Service Documents for various products and services in Insurance Service Group.
• Created web intelligence reports using merged dimensions, multiple queries and free hand SQL.
• Analyzed and interpreted of information gathered in order to define the most effective solutions to the requirements being worked on.
• Defined system attributes external interfaces, constraints & other non-functional requirements.
• Gathered information from existing systems, analyzed various programs and time requirements.
• Prepared time estimates and justifications for assigned tasks and provided recommendations to project managers.
• Created functionality to provide automated email delivery of KPI data and analytics to executive management.
• Involved inMicrostrategy Intelligence Serverperformance monitoringandmanaging cache expiry times.
• Participated as a member of scrum teams in an agile software development environment.
• Acted as the Product and/or Feature owner on product enhancement and new product development.
• Acted as the customer advocate to make sure we create the best user experience possible.
• Successfully proposed, architected, and implemented (including DDL, ETL, and new business processes) a multi-dimensional data mart, with over 8 million records for Nationwide. The return on investment was a huge reduction in processing time by 87%, as well as a huge reduction in required manual effort (8 hours of resource time vs under 1 hour).
• Designed and built an Operational Data Store that consolidated five different data sources to a single repository.
• Modified and created SQL stored procedures and views to align reports and .net applications with the business needs.
• Reviewed existing data mart strategy and make quality and performance recommendations. Developed performance tuning techniques.

Confidential, Chicago, IL

Sr BI Architect

Responsibilities:

• Directed architecture and engineering effort to design, develop, and deploy solutions.
• Conducted both 1:1 interviews with all organizational levels as well as participated in Joint Application/Joint Analysis Design sessions.
• Responsible for the development of logical data models and physical data base designs applied across multiple computing environments.
• Integrated production support feedback into data warehouse development lifecycle, greatly reducing support costs.
• Managed all technical aspects of Enterprise Data Warehouse migration from Oracle to a 12 Terabyte Teradata Data Warehouse, utilizing Informatica for data migration and data loading.
• Effectively tuned Microstrategy implementation for greater performance based on recommendations from internal testing.
• Led a team of 3 junior MicroStrategy resources from analysis through implementation.Completed this very aggressive, short timeline project before deadline and under budget.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Provided expertise in the development of MicroStrategy Dashboards: Resurrected a Sales and Marketing dashboard, made changes for a demo.
• Provided advice, dashboard functionality, designed and quoted effort for new version(s) of the Sales and Marketing dashboard.
• Assisted development \testing teams in the design of new BI solutions.
• Involved in data roadmap, current / target state for enterprise data.
• Captured business requirements and rules, designed the associated artifacts.
• Documented data flow processes and communicated them to the Business teams and Technology teams.
• Model, develop and deliver end to end BI solutions from engaging source system vendors, creating ETL jobs in SSIS / SQL scripts, to deliver dashboards, reports and data packages for multiple lines of businesses.
• Designed and maintained the logical and physical data models to support the business requirements.
• Mapped data elements of data sources into the domain data models.
• Maintained documentation of data models, including relationships, constraints and metadata.
• Published and conducted model reviews with business and technical project teams.
• Reviewed database design changes with the team to determine the impact to the physical database and other systems.
• Participated in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization
• Provide Architect with an eye toward high performance, scalability, and high availability.
• Created data audit reporting to surface significant information identified by post-load SQL data audits: data type headroom, period-over-period fact variance changes, fact-to-fact data consistency, etc.
• This platform is currently used by nearly half of the company's staff for operational, tactical, and strategic reporting needs. In the first several months of use more than $20,000 in monthly savings were identified by analysts using the warehouse cubes.
• Supported data related inquiries and questions in development and production.

Confidential, Chicago, IL

Senior BI Architect

Responsibilities:

• Involved with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, testing and documentation.
• Designed the process for and completed a large data conversion of 110 database tables within an extremely tight timeframe.
• Enhanced trading services and claims report; decreasing rendering time over 90% by designing an OLAP model consisting of specific 1.2 terabytes of data loaded in a snowflake schema, utilizing SSAS hybrid solution to increased reporting time from minutes to sub-seconds.
• Accomplished the strategic execution of projects to ensure the processes align to the customer's plans and technology road maps architecting OLAP data model schemas for cube development allowing analytical reports to render at maximum
• Pioneered the deployment of the first iPhone Dashboard for NT that delivered performance trends and metrics for the entire Revenue Cycle Management process.
• AnalyzingBusiness Intelligence Reportingrequirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
• Created Microstrategy objects likeReports, Ad-hock reports, Documents, Prompts, Filters, Metrics, Facts, Consolidations, Custom Groups, Attributes TransformationsandHierarchies.
• Engineered BI solutions by deploying scorecard reports.
• Updated existing MicroStrategy projects, created 7 new MicroStrategy projects, and created 30 complex MicroStrategy reports (mainly data extracts) that supplement Excel.
• Used conditional, compound, transformation, and level metrics. Used conditional formatting to enhance the grid reports.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
• Served as business intelligence group leader for all communications, service responses and issues in several projects right from requirements until installation and post production.
• Rewrote top 50 reports that were generating inaccurate results. Contacted MicroStrategy Support, on 10 occasions, following through from problem to resolution.
• Translated business requirements into data needs and developed detail E-Rand dimensional models.
• Worked closely with Business Analyst to implement data loading specifications.
• Set standards for use of ERWIN for modeling and model management process using ERWIN.
• Identified and documented data definitions, business rules and business metrics.
• Architected 4 new BI data marts with over 400 data interfaces to support reporting and analytics on MicroStrategy.
• Maintained existing ETL procedures, fixed bugs and restored software to production environment.
• Played key part of the development of metadata standards and enterprise information dictionary.
• Created and represented a knowledge base of data requirements in the investment management areas such as; fixed income, equity, trading, sales & marketing, security master, industry classifications, etc.
• Created SQL scripts for database modification and performed multiple data modeling tasks at the same time under tight schedules.
• Trained end users or technical support staff to use programs.

Confidential, Riverwoods, IL

Principal Business Intelligence Architect

Responsibilities:

• Guided business and IT representatives through an enterprise warehouse planning process.
• Facilitated JAD sessions to determine data rules and conducted Logical Data Modeling (LDM) and Physical Data Modeling (PDM) reviews with Data SMEs.
• Produced stakeholder consensus regarding the scope and purpose of six subject area data marts having 18 shared dimensions.
• Participated in data analysis and data dictionary and metadata management -Collaborating with business analysts, SME’s, ETL developers, data quality analysts and database administrators.
• Created dashboard enabling the company to actively manage the marketing plans for all its customers
• Participated in design of Data Asset Management (DAM), Marketing, Customer Contact Channel, IVR, Targeted Payment Protection business processes, target applications architecture and target data model.
• Developed relational model design, dimensional modeling, and ETL processes in Data warehouse (DWH) and Decision support system (DSS) environment. Validated and maintained the enterprise-wide logical data model for Data Staging Area, DWH and DSS.
• Aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users. Total number of entities 1170 including fact& multi dimensions.
• Developed and supported multiple Business Object reporting projects comprising 500 reports and 25 universes
• Developed the logical data model (LDM) & PDM and assisted the DBA to create the physical database by providing the DDL scripts including Indexes, Data Quality checks scripts and Base View scripts.
• Applied Confidential Financial Data Naming Standards, created new naming standards, checked models in and out of ER Studio Model Repository, and documented data model translation decisions.
• Performed data analysis and reverse engineering of data.
• Managed BI enhancement from Business Objects XI R2 to Business Objects XI 3.1.
• Provided data modeling support to the Marketing operations design team.
• Ensured delivery of LDM, PDM, Staging PDM and data lineage mapping documents.
• Created new macros in visual basic and modified existing macros to perform data validations.
• Migrated Data Warehouse from Retek RDW and OBIEE to MicroStrategy and Netezza in 9 months.
• Developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging area Data Models and Data Flow Diagrams.
• Troubleshoot problems with Pentaho Reporting based solutions (PRD, Mondrian, OLAP, PIR).
• Managed the data model changes in all enterprise applications. Performed impact analysis to ensure all systems leads are informed and coordinate efforts to implement changes.
• Developed detailed mapping documents that will provide the reporting and data warehouse team with source to target data mapping includes logical names, physical names, data types, corporate meta-data definitions, and translation rules.
• Conducted quality control/auditing to ensure accurate and appropriate use of data.
• Performed data analysis on production data issues.
• Assisted in developing and publishing data management standards, policies and procedures, including the management and maintenance of related tools and environments.

Confidential, Downers Grove, IL

Senior Data Modeler / Data Analyst

Responsibilities:

• Analyzed business requirements and translated them into detailed conceptual data models, process models, logical models, physical models and entity relationship diagrams. Gathered enterprise level data requirements.
• Communicated data needs internally and externally to 3rd parties. Analyzed and understood the data options and documented data dictionary.
• Designed and created Data Marts as part of a data warehouse. Effectively used triggers and stored procedures necessary to meet specific application’s requirements.
• Captured data extract requirements for multiple subject areas sourced from an external ERP system.
• Maintained existing ETL procedures, fixed bugs and restored software to production environment.
• Analyzed data which included investigation and analysis, documentation, filtering of bad data through generation of crystal reports.
• Designed 3rd normal form target data model and mapped to logical model. Worked with Data Warehouse Extract and load developers to design mappings for Data Capture, Staging, Cleansing, Loading, and Auditing.
• Developed, enhanced and maintained Snow Flakes and Star Schemas within data warehouse and data mart conceptual & logical data models.
• Performed Statistical Data Analysis as per the client request.
• Participated in system integration, historical load, incremental load and parallel testing.
• Aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users, such as the Web-based 120-entity General Motors Card Services (GMCS) using Oracle 10g, SQL Server 2000, Sybase and MS Access.
• Established auditing procedures to ensure continued data integrity.
• Researched data sources for new business data and better sources of data feeds.
• Developed and coordinated enhancements and maintenance of data warehouse and data mart logical models.
• Analyzed content and quality of data model(s) and databases.
• Work closely with the DBA team to translate the model(s) from logical design to physical implementation.
• Worked closely with the Infrastructure Architect and Application Architect to insure the EDM is integrated with development efforts.
• Reviewed new data development and ensured that it is consistent and well integrated with existing structures.
• Worked closely with the end users and trained them. Identified, documented and resolved any BIM issues.
• Recommended data management procedures.
• Conducted team meetings & ensured project documentation is completed.
• Ensured all data has a complete and accurate definition.
• Validated the data in ER/Studio materialized views.
• Performed the quality check on the data models in Metacenter ER/Studio data repository.
• Tracked the metadata quality process to improve the count of missing definitions.

Confidential, Chicago, IL

Business Analyst/ Reports Developer

Responsibilities:

• Part of Analysis team for System Requirements for the 90-entity Global Corporate Events Management System (GEMS) Global Corporate Events Management System.
• Generate and execute Test Scripts and Batch Jobs to sync data between Oracle, File Maker Pro and MS Access databases.
• Created & scheduled packages using DTS services.
• Design financial reports using Crystal Report Enterprise.
• Publish the reports on the Web using Crystal Reports Enterprise Server.
• Created PL/SQL stored procedures and queries for Oracle database.
• Designed financial reports for customer data involving equity and debt sales reports, research reports, management reports, asset management and private equity reports using Crystal Report Enterprise and Business Objects.
• Published the reports on the Web using Crystal Reports Enterprise Server.
• Filtered Data with the Select Expert, selected Records with Multiple Criteria.
• Used Select Formula for viewing and editing the records, extensively wrote formulas to customize data formats in the reports.
• Extensively created parameterized complex SQL queries to populate the data in the reports.
• Created Security Groups, Summarized Groups, Cross Tab and Sub Reports using Crystal Reports Designer.
• Exported Report results within the Business Group in PDF format through outlook mail server.
• Tested and verified reports for data accuracy.
• Participated actively in User Acceptance Testing.
• Wrote complex ad-hoc queries in SQL in Teradata, Oracle, DB2, and SQL Server to fetch the data as per the client requests.

Confidential, Jacksonville, FL

Business Analyst/ Data Modeler

Responsibilities:

• Developed, enhanced and maintained data warehouse and data mart conceptual & logical data models using ERWin and MS Visio.
• Aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users, such as the Web-based 110-entity Global Conference Information Board (GCIB) and the Global Corporate Debt Events (GCDE) using Oracle, SQL Server, Sybase and MS Access.
• Maintained and enhanced and determined impact to the Enterprise Data Model (EDM), ODS Operational Data Source (ODS) and DSS (Decision Support System) and refined the EDM as needed as new applications or products were added.
• Established auditing procedures to ensure continued data integrity.
• Participated in business requirement definition and review business requests for data and data usage.
• Researched data sources for new business data and better sources of data feeds.
• Developed and coordinated enhancements and maintenance of data warehouse and data mart logical models.
• Participated in application design reviews to ensure data model adherence and data standards.
• Analyzed content and quality of data model(s) and databases.
• Worked closely with the DBA team to translate the model(s) from logical design to physical implementation.
• Worked closely with the Infrastructure Architect and Application Architect to insure the EDM is integrated with development efforts.
• Reviewed new data development and ensured that it is consistent and well integrated with existing structures.
• Worked closely with the end users and trained them.
• Recommended data management procedures.
• Defined data requirements to satisfy client business objectives.
• Ensured all data has a complete and accurate definition.
• Ensured a common business vocabulary for organizational use.

Confidential, Minneapolis, MN

Business Analyst/Data Modeler

Responsibilities:

• Consulted with business partners and applications team to ensure conformance to established architectures.
• Performed data analysis and modeling for development and maintenance projects.
• Developed and maintained Entity Relationship Diagrams and associated data dictionaries.
• Assisted in the development of task lists, project plans and workload estimates.
• Participated in walk-through of work products such as data models, implementation architecture, documentation, etc.
• Performed impact analysis for requested changes and additions to data structures.
• Worked both independently and collaboratively with multiple project teams.
• Designed, developed, and implemented complex logical and physical databases across multiple platforms, technologies and computing environments.
• Provided project reporting to project manager.
• Performed research, prepared technical studies, and made recommendations.
• Prepared business requirements reports, feasibility studies, and cost justification statements.
• Articulated information architecture to management.
• Researched and evaluated alternative solutions and recommended the most cost effective design solutions.
• Worked closely with technical and client management to ensure implementation of database management and support tools for complex business application development requirements and processes in accordance with latest enterprise direction (e.g., diverse development platforms, technological environments, software, hardware and tools).
• Consulted with the team and clients to determine the impact of new or revised applications on information architecture.
• Consulted with clients to determine information management requirements.
• Provided training and professional development on new technologies and applications to team.
• Executed custom queries and ad-hoc database queries using T-SQL and provided management with reports as needed.
• Provided support to end users for various database and application issues.

Confidential, NY, New York

Business/Data Analyst

Responsibilities:

• Worked with the Business Analysts for requirements gathering, business needs analysis, testing, and project coordination and validated data requirements by conducting JAD sessions.
• Involved in Database modeling, creating physical and logical structures of the database and tables using ERWin 3.5 and Oracle 8i and supported design through implementation.
• Designed and developed multiple Dimension and Fact tables.
• Created Technical Specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Analyzed data in existing databases and performed and verified source to target mappings/conversion specifications/ mapping rules.
• Ensured all metadata, including field definitions, valid values, is accurately captured and provided to stakeholders (developers, business users) as/when needed.
• Verified that applicable data -related standards are applied in data management activities.
• Implemented various transformations like Expression, Lookup, Sequence generator, and Source Qualifier, Rank, Aggregator etc.
• Developed several Complex Reports (various features used include multiple groupings, drilldowns, parameter fields, formulas and conditional formatting) using Crystal Reports.

Confidential

Programmer Analyst

Responsibilities:

• Collected the requirements from the clients by conducting JAD sessions.
• Documented the user requirements, system requirements, high-level and low-level System documents.
• Created data model structure and E-R modeling with all related entities and relationship with each entity based on the rules provided by the business manager using Erwin.
• Participated in Logical Data Model (LDM) and Physical Data Model (PDM) reviews with Data SMEs.
• Planned an approach for documenting, categorizing, and packaging requirements.
• Designed screens, Menus using VB 6.0.
• Designed complex reports using Crystal Reports 7.0.
• Formulated the requirements into individual Modules.
• Involved in designing the database using normalization in Oracle 8i.
• Developed MDI (Multiple Document Interfaces) using Visual Basic 6.0.
• Created tables, views, triggers and Coded Stored Procedures in PL/SQL using SQL Plus and TOAD. Created database connectivity and retrieved records using ODBC.
• Identified business objects and developed in VB 6.0.