SUMMARY

• SDLC: Over 15+ years of experience in planning and Requirement Analysis, Defining Requirements, Designing teh product architecture, Building or Developing teh Product, Testing teh Product, Deployment and Maintenance.
• Managing teh everyday business operations associated wif BI, such as analytics, reporting, information delivery, data preparations, data exploration, and data warehousing. Technical expertise and general business skills (communication, presentation, leadership, analytical thinking)
• Provided competitive intelligence and actionable insight to financial, operational and sales teams as well as C - level management by identifying drivers corporate performance. Supervised a team of 3 analysts and developers, managed vendors and administered development budget.
• Ability to write and maintaintechnical documentationto describe Reports development, logic, coding, testing, changes, and corrections. UtilizedBest PracticesandProven MethodologyinBI developmentprocess.
• Experience and in Amazon Web Services S3, EC2, IAM, Route53, Databases(RDS, DynamoDB, Redshift), VPC, Lambda, EBS, EFS, Glue, Athena, SQS, SNS, API Gateway, Kinesis.
• Business Intelligence: Over 8+ years as an application developer wif expertise in implementing and developing Data Warehousing/Business Intelligence solutions applying advance techniques from Kimball Group, using IBM BI Cognos and OBIEE, in-depth and comprehensive experience in design, development, testing, Security and Support for Data warehousing and Client/Server projects
• Cognos BI: Development and implementation of Cognos10.x, Cognos 8.x, Report Studio, Query Studio, Analysis Studio, Transformer, Power play, Cognos 8
• Installed and configured Cognos 8.2/8.3/10 BI, BI modeling, Report Studio, Query Studio and Analysis Studio. Cognos8.3, Cognos 8.2, Report Net, Query Studio, Report Studio, Transformer, Power play, scheduled teh Reports based on teh database events using Triggers.
• Expert in developing and designing architectural solutions according to project/business need
• Oracle BI: Experience in development and implementation of OBIEE suite: BI Admin, BI Answers (Interactive Dashboards, Scorecard and Strategy Management, Spatial Visualizations and Analytics), BI Publisher, BI Server
• Designed and developed dynamic dashboards to evaluate teh Company’s performance. Implemented Row Level Security, Object Level Security, Package Security, Folder Security and created user classes as per teh requirement. Created complex Lists, Cross Tabs, Charts and Repeater in Cognos 8.x/10.x and OBIEE.
• Created JavaScript solutions in Cognos reports to enhance teh out-of-box capabilities of teh tool.
• Developed logical models providing Business Relations implementing Star schema and Snowflake schema concepts.
• Expertise in developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Identified teh Facts and Dimensions using Erwin Data modeling tool to represent teh Star Schema Data Marts.
• Hands on experience wif OLAP tools such as Transformer in creating multi-dimensional cubes and Power Play for Windows.
• Complex Report building wif Report Studio to customize teh functionality in prompt page, Master detail Relationships, Drill through in Report page, Customized Prompts and Conditional Formatting.
• Experienced in Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting Systems
• Experience wif SQL in testing and validating reports.
• Expertise in creating ETL processes in Microsoft Integration Services 2003/2008 and Informatica
• Expertise in Building Cube, Dimensions using TM1 Turbo Integrator processes and cognos planning by Applying rules to teh cube and worked on improving performance of teh cube.
• Expertise in analytical and problem solving skills. Identify teh root cause for teh problem and deliver teh solution wif in stipulated time.
• Manage Server wif Windows Server 2003/2008, backing up and restoring data, changing group s, checking event logs, creating administrative scripts, creating user and group accounts, deploying and upgrading software, installing a DHCP server, managing applications on a local computer, managing applications remotely, management tasks for disks and volumes, file and folder management, managing network printers, managing servers remotely, managing services, monitoring network traffic, monitoring security-related events, monitoring server performance, resetting user passwords, safeguarding system, scheduling tasks, setting up DNS, setting up TCP/IP, setting user and group security, installing Active Directory Server, installing Apache Tomcat.
• Created complex queries in Microsoft SQL Server 2005 (PL/SQL) and TOAD to discover various data sources.
• Installed, configured and managed Oracle DB 7/8/9i/10g/12g in Windows Server 2003/2008 and Linux
• Possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented wif a desire to learn client's business requirements.

TECHNICAL SKILLS:

Cloud Computing: Amazon Web Services Architect, covering resources like S3, EC2, IAM, Route53, Databases (RDS, DynamoDB, Redshift), VPC, Lambda, EBS, EFS, Glue, Athena, SQS, SNS, API Gateway, Kinesis.

BI Tools: Cognos (8.3,8.4,10.1,10.2) (Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Connection, Framework Manager), Power Play Transformer, IBM Cognos TM1 10.1/10.2

OBIEE: BI Admin, BI Answers (Interactive Dashboards, Scorecard and Strategy Management, Spatial Visualizations and Analytics), BI Publisher, BI Server Data Warehouse, Data mart, Informatica, Microsoft Integration Services 2003/2008

Big Data: Horton Works and Cloudera (Hadoop, clusters, Yarn, Zookeeper, Sqoop, Python, Scala, Spark, Hive, Impala, Avro, Flume)

Platforms & OS: Linux, Windows Server 2003/2008, Win NT, Win95, Win2000/2003/Advancedserver, WinXp

Database: Oracle 7.x/8.x/9i/10g/12g, Microsoft SQL Server 7/2000/2005, MS Access97/2000.

Other Tools: TOAD, SQL Programmer, Erwin, Microsoft Project

App/Web Servers: IIS 5.0, WebSphere, Apache Tomcat.

Directory Servers: Active Directory Server

Languages: Python, Scala, SQL, PL/SQL, C, C++, HTML, RegexJava & J2EE Java, JSP, Java Script

PROFESSIONAL EXPERIENCE:

Senior Data Engineer

Confidential, NY

Responsibilities:

• Created Big Data architectures using Amazon Web Services resources like Glue, RDS, S3, IAM, EC2 and Spark Cluster to leverage data processes to integrate information digital advertising.
• Created Spark applications in Big Data Clusters like Horton Works and Cloudera, using Scala and Python, Hive, Sqoop, Hadoop, Yarn, Zookeeper.
• Designed and Implemented Databases in RDS to support teh load of data coming from vendors systems.
• Created Docker containers to generate solutions for data processing.
• Trained as an Amazon Web Services Architect, covering resources like S3, EC2, IAM, Route53, Databases (RDS, DynamoDB, Redshift), VPC, Lambda, EBS, EFS, Glue, Athena, SQS, SNS, API Gateway, Kinesis.

Sr. BI Consultant

Confidential, NY

Responsibilities:

• Built and analyzed BI requirement from teh client. Planned BI strategy according wif business needs: Cognos Servers configuration, Cognos Installation, Framework model, Security, Reports and Dashboards wireframes.
• Implemented IBM Cognos 10.2.2 on Linux RedHat, add security to Cognos Connection through LDAP Server.
• Participated in teh implementation of Framework Manager model wif a Star schema including 4 fact tables and 20+ dimensions. Add security for query subjects in business and presentation layer.
• Built Complex reports and dashboard, list, crosstabs, prompts, drill through, javascript, visualizations.
• Improved performance in Framework Manager, Report Studio (Reports and Dashboards)
• Performed and documented unit and integration testing, performance testing, Regression Testing

Environment: Cognos BI 10.2.2 (Report Studio, Query Studio, Framework Manager, Cognos Connection), RedHat 6, Oracle 10g/12g, Linux, Erwin, HTTP Server, Apache Tomcat, LDAP.

Sr. Data warehousing Architect

Confidential

Responsibilities:

• Expert in developing and designing architectural solutions according to project/business need.
• Collaborated wif business teams, including senior executives, Directors, and other users to define and manage scope, project prioritizations and future analytical needs. Interacted wif business users to gather teh requirements
• Supporting and enhancing multiple OBIEE/BIP applications, maintaining teh environments and servers and troubleshooting & fixing any bugs, and migration financial Cognos BI 8.3 reports to OBIEE 10g.
• Implemented Cognos BI 10 on Linux RedHat6, Websphere Application Server, Oracle 12g.
• Migrated Cognos BI 8.3reports to Cognos 10.Create & Published Cognos10 Framework Manager models
• Create advanced reports using Report Studio to customize teh functionality in prompt page, Master detail Relationships, Drill through in Report page, Customized Prompts and Conditional Formatting.
• Create multi page dashboards wif global filter variable functionality
• Create dashboards using Cognos 10. 1 Business Insight & Cognos 10.2 Workspace.
• Work wif OLAP tools such as Transformer in creating multi-dimensional Power Play cubes.
• Design teh target data warehouse using Star Schema. Built Dimension Tables and Fact Tables
• Identify teh Facts and Dimensions using Erwin Data modeling tool to represent teh Star Schema Data Marts.
• Create workflows comprising of different sessions for their respective mappings in order to load data into Oracle database
• Involve in teh development of new ETL processes and created complex queries in Microsoft SQL Server 2005 (PL/SQL) to discover data from other departments in order to load it into teh new data warehouse.
• Involve in day to day Cognos administration activities by writing and maintainingtechnical documentationto describe Reports development, logic, coding, testing, changes, and corrections.
• UtilizeBest PracticesandProven MethodologyinBI developmentprocess.
• Manage Server wif Windows Server 2008, backing up and restoring data, changing group s, checking event logs, creating administrative scripts, creating user and group accounts, deploying and upgrading software
• Installing a DHCP server, managing applications on a local computer, managing applications remotely, management tasks for disks and volumes, file and folder management, managing network printers and servers remotely.
• Managing services, monitoring network traffic, monitoring security-related events, monitoring server performance, resetting user passwords, safeguarding your system, scheduling tasks, setting up DNS, setting up TCP/IP, setting user and group security, installing Active Directory Server, installing Apache Tomcat.

Environment: OBIEE 10g, BI Publisher 10g, OBIEE 11g, BI Publisher 11g, Cognos BI 10 (Report Studio, Query Studio, Analysis Studio, Transformer, Power Play, Framework Manager, Cognos Connection), Microsoft SQL Server 2005 (PL/SQL), Microsoft Project, RedHat 6, Websphere Application Server, Oracle 10g/12g, SQL Server2005, Linux, WinXp, Windows Server 2008, Erwin, WebSphere 8.5, Apache Tomcat, Active Directory Server

Lead BI Consultant

Confidential, Boston, MA

Responsibilities:

• Managed project plans, scope, resources, change requests, risks and issues to fulfill business expectative.
• Designed and managed teh finance data warehouse project, wifin-budget and on schedule (Oracle 10g)
• Provided regular guidance to teh development team and prioritize feature sets into logical iterations to accelerate deliver to teh business.
• Provided strategic, forward-looking BI and data management and introduce innovative solutions design solutions to maintain flexibility, good exception management and future integration opportunities.
• Monitored technology trends in BI and data management and introduce innovative solutions to meet business needs.
• Created complex queries in Microsoft SQL Server 2008 (PL/SQL) and TOAD, Oracle10g/12gto discover data from other departments in order to load it into teh new data warehouse.
• Set standards for business analysis and technical documentation.
• Prepared and deliver materials and seminars to educate business users on new features and functionality by ensuring product designs are well documented and communicated
• Mentored users in order to strengthen their ability to build reports and conduct accurate and comprehensive analysis.
• Conducted advanced analysis of business data, as requested by senior business leaders, to glean new insight into business performance, trends, and patterns to ensured Business Applications development meets or exceeds customer requirements
• Ensured product designs are well documented and communicated
• Led teh integration of data from newly acquired businesses into teh BI environment.
• Collaborated across other IT functional areas from all Latin-American countries to share knowledge and technical insight
• Transitioned teh finance team from an intuition based to a fact-driven decision making culture
• Directed data mining projects addressing financial behavior insight, cost efficiency and profitability: organization’s performance, according to key performance indicators (KPIs) such as revenue, return on investment (ROI), overhead, and operational cost.
• Assessed gaps and opportunities for new advanced analytical tools to support key business functions.
• Worked and communicated wif C-suite, entry level analysts, and business intelligence developers across major continents to build new functionality to meet teh growing needs of teh business units, including teh creation of entirely new analytical datasets.
• Deciphered teh key business drivers for performance for business units worldwide, including core functions such as finance, sales, marketing, HR, as well as company specific scientific operating units.
• Anticipated and Proposed new data marts and reporting tools to best meet future analytical needs.
• Developed proof-of-concept (POC) solutions to help business units better visualize their business needs and to clarify requirements for development by designing testing scenarios and conduct tests together wif power users.
• Created new ETL processes and provided IBM Cognos (8/10) and ETL Developers wif guidelines in teh design and development of data and business intelligence portions of business projects.
• Created advanced reports using Report Studio. Created Cognos Power play Cubes using Power play Transformer
• Created multi-page dashboards using Cognos 10. 1 Business Insight & Cognos 10.1 Workspace.
• Developed and implemented OBIEE suite BI Admin, BI Answers (Interactive Dashboards, Scorecard and Strategy Management, Spatial Visualizations and Analytics), BI Publisher, BI Server
• Designed and implemented data warehouse using Star Schema. Built Dimension Tables and Fact Tables
• Identified teh Facts and Dimensions using Erwin Data modeling tool to represent teh Star Schema Data warehouses and Data Marts.
• Conducted complex data analysis using a variety of business data (Oracle Financial Application Suite modules in order to demonstrate new methods for measuring business performance, assess trends, and predict future behavior.

Environment: BI Admin, BI Answers (Interactive Dashboards, Scorecard and Strategy Management, Spatial Visualizations and Analytics), BI Publisher, BI Server, IBM Cognos 8/10 (Report Studio, Framework Manager, Transformer, PowerPlay, Query Studio, TM1), OFA (Oracle Financial Application) Suite, Business Process Assessment & Redesign, Analytic Reporting & analysis including ETL, MS SQL Server 2008 (PL/SQL), TOAD, Erwin, Oracle 10g/12g.

Lead BI Consultant

Confidential

Responsibilities:

• Manage and develop teams’ performance, ensuring dat all tasks meet deadlines and quality standards, manage plan & produce BI projects by demonstrating clear and effective communication, execute project work plans and requirements collection and documented Report specifications.
• Produced business blue-prints, define & evolve KPIs for each business area, prepare engagement reviews and quality assurance procedures, provide and awareness on BI to all users.
• Implemented Cognos 8.4 and 10.1 on Windows Server 2003 and 2008, for Development, Testing, QA and Production environment.
• Installation and support of Cognos Servers (Dev, Test, QA, Prod), administration of Cognos Connection, migration, security management.
• Built requirements Analysis for Multidimensional modeling and reporting in Cognos.
• Interacted wif Business users to identify key dimensions and measures for business performance.
• Build models and packages using Framework Manager for teh Enterprise Risk Management Group.
• Designed flexible, professional Dashboard, feature-rich and drill through reports using report studio.
• Created multi-dimensional cubes using package as teh data source.
• Identified teh Facts and Dimensions using Erwin Data modeling tool to represent teh Star Schema Data Marts.
• Extensively Developed New Reports in Cognos8 BI using Report Studio, Analysis Studio and Query Studio.
• Created JavaScript solutions in Cognos reports to enhance teh out-of-box capabilities of teh tool.
• Participated in teh detailed requirement analysis for teh design of data marts.
• Performed various data analysis at teh source level and determined teh key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts.
• Created complex queries in Microsoft SQL Server 2008 (PL/SQL) and TOAD, Oracle10g/12g to discover data from other departments in order to load it into teh new data warehouse.
• Created ETL processes in Microsoft Integration Services 2003/2008 and Informatica
• Created, Coordinated and monitored work plans wif business intelligence ETL & Database developers in Database Design and Development
• Developed procedures and standards for teh proper management ITIL Technology. Created Event studio agent to run teh jobs based on an event.
• Created User Groups, Roles to implement teh Cognos Security using Active Directory. Involved in Cognos Administration activities.
• Closely worked wif data warehouse designers to refine data and metadata.
• Conducted end user on Report Studio and Query Studio. Used Microsoft Project to help understand teh progress of teh project
• Manage Server wif Windows Server 2008. Installed and managed IIS 5.0.
• Designed, developed and maintained Cognos Planning and TM1 cubes according to teh business requirements.
• Built models using query subjects, query items and namespaces from teh imported metadata.
• Designed and implemented data warehouse using Star Schema. Built Dimension Tables and Fact Tables
• Applied data level, Object level and package level security for various entries.
• Created user groups and roles in Cognos Connection.
• Experienced in creating new Data sources in configuration tab and test teh data sources.
• Created complex queries in Microsoft SQL Server 2003 (PL/SQL) and TOAD, Oracle10g/12g to discover data from other departments in order to load it into teh new data warehouse.
• Created ETL processes in Microsoft Integration Services 2003.
• Managed teh creation of functional and technical documents.
• Daily management of technical team in teh development, testing and implementation of teh Analytics solution and for troubleshooting complex issues.
• Built Complex Cubes and did time based partitioning on them
• Used HTML and Java Scripts for Advanced reporting purpose.
• Responsible for end-to-end life cycle of teh Analytics deliverable including resource and scope planning.
• Published/Maintained teh Cognos FM model packages.
• Used Framework Manager Modeling tool to create, update, analyze and manage business-related metadata for teh report authoring using Cognos 8 Report Studio queries and analysis.
• Responsible for creating teh Cubes and Reports and scheduling them accordingly
• Monitored teh progress of teh project by using Microsoft Project

Environment: Cognos BI (Report Studio, Query Studio, Analysis Studio, Framework Manager, PowerPlay Transformer), Cognos TM1, Microsoft SQL Server 2003 (PL/SQL, Integration Services). Microsoft Project.

IT Architect

Confidential

Responsibilities:

• Sized, priced and installed IBM me 570, partition& configuration of Storage, installation, connections of Network for Chedraui company from Xalapa Veracruz, Mexico.
• Installed HA (High Availability) in Servers, Installed Power6 Server 520 DHL company in Mexico.
• Dealt wif customers, designed custom solutions and needs

Environment: Modular Systems, Power Systems, Storage Systems, IBM Software, System p, System me, Insight Video Net, Lenovo, Motorola Symbol, Vmware, RSS, Technical Support and Sales for AIX and Linux (IBM)

IT Architect & Application developer

Confidential

Responsibilities:

• Analyzed, designed, develop and implemented programs in Visual Basic, PHP, Delphi, Java, PHP, HTML, Dream Weaver MX, Access, Installation and administration of Microsoft SQL Server and Oracle 9i in Windows, PL/SQL, data analysis.
• Installation and maintenance of network and computer equipment, optimization of computational resources.

Environment: Java, Php, html, Delphi, Visual Basic, Microsoft SQL Server, Oracle 9i, Flash MX, Dream Weaver MX, Access, Visio, Word, Excel and Power point