PROFESSIONAL SUMMARY:

• SDLC: Over 16 years of experience in planning and Requirement Analysis, Defining Requirements, Designing the product architecture, Building or Developing the Product, Testing the Product, Deployment and Maintenance.
• Managing the everyday business operations associated with 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 driver’s corporate performance. Supervised a team of 3 analysts and developers, managed vendors and administered development budget.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections. Utilized Best Practices and Proven Methodology in BI development process.
• Experience and training 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 with 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 the Reports based on the 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 the Company’s performance. Implemented Row Level Security, Object Level Security, Package Security, Folder Security and created user classes as per the 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 the out-of-box capabilities of the 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 the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
• Hands on experience with OLAP tools such as Transformer in creating multi-dimensional cubes and Power Play for Windows.
• Complex Report building with Report Studio to customize the 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 with 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 cogon’s planning by Applying rules to the cube and worked on improving performance of the cube.
• Expertise in analytical and problem solving skills. Identify the root cause for the problem and deliver the solution with in stipulated time.
• Manage Server with Windows Server 2003/2008, backing up and restoring data, changing group memberships, 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 with 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/Advanced server, 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, Regex

Java & J2EE: Java, JSP, Java Script

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Data Engineer

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 the 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.

Environment: Amazon Web Services (EMR, Glue, RDS, S3, IAM, EC2), Big Data Clusters like Horton Works and Cloudera, using Scala and Python, Hive, Sqoop, Hadoop, Yarn, Zookeeper, Kafka, Docker, DevOps.

Confidential

Sr. BI Consultant

Responsibilities:

• Built and analyzed BI requirement from the client. Planned BI strategy according with 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 the implementation of Framework Manager Model with 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.

Confidential

Sr. Data warehousing Architect

Responsibilities:

• Expert in developing and designing architectural solutions according to project/business need.
• Collaborated with business teams, including senior executives, Directors, and other users to define and manage scope, project prioritizations and future analytical needs. Interacted with business users to gather the requirements
• Supporting and enhancing multiple OBIEE/BIP applications, maintaining the 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 the functionality in prompt page, Master detail Relationships, Drill through in Report page, Customized Prompts and Conditional Formatting.
• Create multi page dashboards with global filter variable functionality
• Create dashboards using Cognos 10. 1 Business Insight & Cognos 10.2 Workspace.
• Work with OLAP tools such as Transformer in creating multi-dimensional Power Play cubes.
• Design the target data warehouse using Star Schema. Built Dimension Tables and Fact Tables
• Identify the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
• Create workflows comprising of different sessions for their respective mappings in order to load data into Oracle database
• Involve in the 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 the new data warehouse.
• Involve in day to day Cognos administration activities by writing and maintaining technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.
• Utilize Best Practices and Proven Methodology in BI development process.
• Manage Server with Windows Server 2008, backing up and restoring data, changing group memberships, 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

Confidential, Boston, MA

Lead BI Consultant

Responsibilities:

• Managed project plans, scope, resources, change requests, risks and issues to fulfill business expectative.
• Designed and managed the finance data warehouse project, within-budget and on schedule (Oracle 10g)
• Provided regular guidance to the development team and prioritize feature sets into logical iterations to accelerate deliver to the 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 the new data warehouse.
• Set standards for business analysis and technical documentation.
• Prepared and deliver training 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 the integration of data from newly acquired businesses into the BI environment.
• Collaborated across other IT functional areas from all Latin-American countries to share knowledge and technical insight
• Transitioned the 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 with C-suite, entry level analysts, and business intelligence developers across major continents to build new functionality to meet the growing needs of the business units, including the creation of entirely new analytical datasets.
• Deciphered the 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 with power users.
• Created new ETL processes and provided IBM Cognos (8/10) and ETL Developers with guidelines in the 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 the Facts and Dimensions using Erwin Data modeling tool to represent the 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, Power Play, 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.

Confidential

Lead BI Consultant

Responsibilities:

• Manage and develop teams’ performance, ensuring that 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 training 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 with Business users to identify key dimensions and measures for business performance.
• Build models and packages using Framework Manager for the Enterprise Risk Management Group.
• Designed flexible, professional Dashboard, feature-rich and drill through reports using report studio.
• Created multi-dimensional cubes using package as the data source.
• Identified the Facts and Dimensions using Erwin Data modeling tool to represent the 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 the out-of-box capabilities of the tool.
• Participated in the detailed requirement analysis for the design of data marts.
• Performed various data analysis at the source level and determined the 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 the new data warehouse.
• Created ETL processes in Microsoft Integration Services 2003/2008 and Informatica
• Created, Coordinated and monitored work plans with business intelligence ETL & Database developers in Database Design and Development
• Developed procedures and standards for the proper management ITIL Technology. Created Event studio agent to run the jobs based on an event.
• Created User Groups, Roles to implement the Cognos Security using Active Directory. Involved in Cognos Administration activities.
• Closely worked with data warehouse designers to refine data and metadata.
• Conducted end user training on Report Studio and Query Studio. Used Microsoft Project to help understand the progress of the project
• Manage Server with Windows Server 2008. Installed and managed IIS 5.0.

Environment: Cognos (8.4, 10.1) (Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Connection, Framework Manager), Power Play Transformer, Cognos Power Play, Windows Server 2003/2008 (PL/SQL, Integration Services). Microsoft Project, Informatica, JavaScript, TOAD, Erwin, IIS 5.0, Apache Tomcat, Active Directory Server.

Confidential

Cógenos Develo per

Responsibilities:

• Designed, developed and maintained Cognos Planning and TM1 cubes according to the business requirements.
• Built models using query subjects, query items and namespaces from the 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 the 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 the new data warehouse.
• Created ETL processes in Microsoft Integration Services 2003.
• Managed the creation of functional and technical documents.
• Daily management of technical team in the development, testing and implementation of the 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 the Analytics deliverable including resource and scope planning.
• Published/Maintained the Cognos FM model packages.
• Used Framework Manager Modeling tool to create, update, analyze and manage business-related metadata for the report authoring using Cognos 8 Report Studio queries and analysis.
• Responsible for creating the Cubes and Reports and scheduling them accordingly
• Monitored the progress of the project by using Microsoft Project

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

Confidential

IT Architect

Responsibilities:

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

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