We provide IT Staff Augmentation Services!

Sr Data Analyst/ Bi Developer Resume

NyC

SUMMARY:

  • 10+ years of experience in providing services in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
  • Over 8 years of experience in handling Data Analysis / Data Modeling, Data Warehousing and Business Intelligence (BI) Tools like Cognos 11,10.X, 8BI (8.1.1, 8.2. 8.3,8.4) Suite, Cognos Report Net, Framework Manager, Impromptu, Power Play, Transformer, Power Play Enterprise Server, Impromptu Report Administrator, Impromptu Web Reports (IWR), Access Manager, Active Directory, Sun Directory with knowledge of programming techniques in administering Oracle and SQL Server Databases.
  • Databases and ETL tools like Oracle warehouse builder (OWB), Informatica and Data Stage .
  • Involved in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams .
  • Extensively worked in Manufacturing, Telecom, Pharma, Finance & Banking, CRM, Supply Chain Management domains and Government Organizations .
  • Adept in the concepts of Supply Chain performance measurement, Supply Chain integration , Demand planning, forecasting and Supply Chain performance modeling.
  • In depth knowledge in Hadoop Architecture like HDFS, Job Tracker, Task Tracker, Name Node , Data Node and Map Reduce programing paradigms.
  • Experienced in developing Web - based Applications using Python , CSS, HTML, JavaScript, Angular JS and jQuery Tableau JS API.
  • Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts
  • 4+ Years of experience in Tableau Desktop & Server 9.x/8.x/7.x in analyzing and creating highly actionable and interactive reports and dashboards.
  • Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Trends, Hierarchies, Sets, Groups, Calculations, LOD expressions, Data Blending and Map s etc.,
  • Experience in Designing and implementing data structures and commonly used data business intelligence tools for data analysis.
  • Solid knowledge of data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
  • Experience in various Teradata utilities like Fast load, Multiload, BTEQ, and Teradata SQL Assistant.
  • Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.
  • Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
  • Strong experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export.
  • Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
  • Developed multiple reports/dashboards using Dual Axes charts, Geo-Maps, Histograms, filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar and Custom charts like Waterfall, Spider, Donut, Pareto etc., to visualize the data.
  • Expertise in Tableau Server Installation and Configuration, creating sites, users, groups, projects, providing access levels and monitoring server health.
  • Expertise in configuring Tableau server environment in 1-node/3-node/5-node architecture based on the client requirements.
  • Experience in establishing best practices for Tableau dashboard development and deployment model for promoting them to QA/UAT/PROD environments
  • Extensive experience in working with Tableau Desktop, Tableau Server in various versions of Tableau 8.1
  • Extensive experience in using Tableau functionalities for creating different Filters, Charts, Interactive dashboards with page and dashboard Prompts.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
  • Hands-on experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Experience in Administering user, user groups, and scheduling of instances for reports in Tableau.
  • Experience in Tableau Server 8.1, online publishing, Sharing, and Tableau online.
  • Experienced in creating Reports in Business Objects and Webi using Universe, Personal Data files, Free Hand SQL.
  • Extensive hands on experience in developing Data Warehousing/BI applications using Cognos BI, Tableau with strong business understanding of Financial, Health Care domain and Payroll, State.
  • Provide overall administration, configuration, security, and maintenance for the Cognos environment. Monitor system utilization and performance, troubleshoot and contact IBM support when problems arise, plan and test for system patches or upgrades, and offer new ideas for improvements
  • Involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service. Involved in documenting the business process by identifying the requirements.
  • Solid experience on Request Fulfillment, Incident Management, Problem Management, Agile Scrum, SDLC, Contract Management, Asset Management, CMDB (Configuration Management), Service Level Management Agile -Rally Application Lifecycle Management ALM (Quality Center) end-to-end process.
  • Excellent knowledge in Test Management tool - Quality Centre, Rally and Rational Clear quest, Rational Quality Manager, JIRA
  • Prepare weekly project status reports and keep management informed of project status and related issues.
  • Responsible for remote support services for internal and external clients to increase productivity, reducing travel expenses and system downtime.
  • Analyzed, incorporated new business rules to support changes as required by the business.
  • Acted as liaison between business units and technology groups to identify business processes and system requirements. Including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.
  • Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS. • Experience in data analysis using Hive, Pig Latin, Impala. • Well versed in Normalization / De-normalization techniques for optimum performance in relational and dimensional database environments.
  • Experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP and Bulk Insert).
  • Have expertise in Business Requirement Analysis, Analytical Reports using OLAP Tools.
  • Proficient with accessing data in TOAD, Teradata SQL Assistant, MS SQL Server 200
  • Implementing data solutions utilizing PL/SQL.
  • Ability to transform functional requirements into reports.
  • Knowledge in Installation of the Cognos 8, ReportNet Server and setting Security.
  • Have good experience in Developing Secured Models in Framework Manager and Publishing Secured Packages on to the Cognos Connection.
  • Expertise in Cognos 10, 8 Query Studio, Report Studio, Analysis Studio, Metric Studio, Cognos Connection and Framework Manager, Power Play Studio.
  • Expertise in developing Dashboards and Score cards using Cognos 8, 10 BI, Tableau and Qlickview Suite.
  • Participated in system integration, performance and user acceptance testing for systems.
  • Provided Production support by checking the integrity of the reports in the production support.
  • Good team player and have good understanding and ability of business problems.

TECHNICAL SKILLS:

BI Tools: Tableau 9X 8.X, Cognos Tm1 9.0((Architect, Contributor, Perspectives, TurboIntegrator) SAP BO 3.Xi, Universe, Designer, WEBI, Life Cycle Manager, MS BI SSAS, SSRS, Cognos 10.2.1, 8 BI Suite, Cognos ReportNet1.1, 1.1 MR2, 1.1 MR3, Framework Manager, SDK, Impromptu6.x/7.x, PowerPlay6.x/7.x, Impromptu web reports 6.x/7.x, OLAP and PowerPlay Transformer, PowerPlay Enterprise Server, Access Manager, Upfront, Scheduler, Cognos Scripting SAP BO

RDBMS: Teradata 13.0, MS SQL Server, Oracle 9i, 10g,11i MS Access, DB2 UDB 8.1, 8.2., Hadoop, HIVE, SQOOP, PIG, HIVE

Database Tools: Toad 8.5,9.0,9.7.2

ETL Tools: Informatica 9.0, IDQ, Oracle warehouse Builder 9.1.X, MS BI SSIS, Cognos Decision Stream 7.0, Cognos Data manager, Data Stage 7X, Erwin, SAP BW 7.0., HP Vertica

Testing Tool: Test Director 7.x/8.0, Quick Test Pro 8.2, Quality Center 9.0, HP ALM /QC (QC 9.2, 12.0)

Project Tracking: JIRA, RALLY, GitHub

Languages: SQL, PL/SQL, C, C++, Java.

Web Technology: HTML, DHTML, XML, Java Script

Operating Systems: Windows 95/98/NT/XP/2000, UNIX (IBM AIX)

Other Tools: Deployment Tool & Migration Utility (Impcat2xml),(migratetoc8), (deploytoc8)

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Sr Data Analyst/ BI Developer

Responsibilities:

  • Interacted with Business users and performed Gap Analysis of Client requirements.
  • Worked as Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings
  • Analyzed data sources and requirements and business rules to perform logical and physical data modeling.
  • Analyzed and designed best fit logical and physical data models and relational database definitions using DB2. Generated reports of data definitions.
  • Worked on SAS and IDQ for Data Analysis .
  • Extracted files from Oracle through Sqoop and placed in HDFS
  • Responsible for building scalable distributed data solutions using Hadoop.
  • Experience in managing and reviewing Hadoop log files .
  • Maintained existing ETL procedures, fixed bugs and restored software to production environment.
  • Worked with Data Warehouse Extract and load developers to design mappings for Data Capture, Staging, Cleansing, Loading, and Auditing.
  • Created SQL scripts for database modification and performed multiple data modeling tasks at the same time under tight schedules.
  • Reviewed new data development and ensured that it is consistent and well-integrated with existing structures.
  • Document new data mart requests, modifications and accompanying reports.
  • Working on analyzing the existing BI infrastructure and coordinating with various teams to install and configure single node Tableau server environment.
  • Using Erwin modeling tool, publishing of a data dictionary, review of the model and dictionary with subject matter experts and generation of data definition language.
  • Tested dashboards to ensure data was matching as per the Business requirements and if there Created the Entity Relationship Diagram implementing Star schema using VISIO
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Experienced on Tableau server administration, Monitoring server activities, identifying performance issues and updating software.
  • Developed Tableau Java Script API based reports in Tableau Server.
  • Created report schedules, data connections, projects, groups in Tableau Server.
  • Created Data Level, Object level, Package level and Row Level Securities in FMM.
  • Manage Cognos Administration including Upgrades, Maintenance, Security etc.
  • Create Dashboard Cognos Reports using Active Report, RAVE Visualization Perform production readiness audit of Tableau applications developed by the development team or users.
  • Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately. Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Experienced in understanding, reviewing, implementing, standardizing and documenting the Requirements Management Maturity (RMM) using HP ALM.
  • Created and maintained issue tracking and Change control documents
  • Extensively worked on SQL, created joins between huge tables to map the columns multiple tables.
  • Work as part of a team on activities such as unit, system and user acceptancetesting, data validation, documentation and knowledge transfer.
  • Support improvements in business process and Confidential Data Warehouse reporting toMeet Confidential reporting needs and Respond to data requests.
  • Use SQL and COGNOS tools on a routine basis in achieving the above tasks.

Environment: Erwin modeling Tool, Informatica IDQ, HDFS, Pig, Sqoop, HBase, Shell Scripting, Linux Red Hat. SAS, Tableau Desktop 10.3, Tableau server 9.2, Cognos 11, 10.2.2 (Framework Manager, Report Studio, JIRA, Query Studio, Metric Studio, Analysis Studio, Transformer), TFS, Oracle 11G,, Windows, Unix Tableau server / Administrator, tabcmd, Tableau drive, Sql Developer, DB2, JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Confidential, NJ

Sr. Data Analyst / Tableau Developer

Responsibilities:

  • Worked with the businesses and project team members (Architect, Solution Designer, and SME's) to understand and create reporting solutions. This includes prototyping potential solutions, or modifying existing work to meet new or changing needs with the use of development standards, processes, and tools available to the team.
  • Designed both 3NF Data models for ODS, OLTP systems and dimensional Data models using star and snowflake Schemas.
  • Developed views and templates with Python and Django's view controller and templating language to create user-friendly website interface.
  • Used Python and Django to interface with the jQuery UI and manage the storage and deletion of content.
  • Expertise in writing Hadoop Jobs for analyzing data using Hive QL (Queries), Pig Latin (Data flow language), Impala.
  • Analyzed data using Hadoop components Hive and Pig.
  • Used Sqoop Export to export data from HDFS to SQL database to connect to the frontend data-visualization.
  • Created and maintained Technical documentation for launching Hadoop Clusters and for executing Pig Scripts and Hive querie
  • Importing and exporting data into HDFS from database and vice versa using SQOOP. tilized SQL, NoSQL databases, Python programing and API interaction
  • Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas , Snowflake Schemas, SCD & Dimensional Modeling.
  • Performed Data analysis and Data profiling using SQL queries on various sources systems including Oracle, SQL Server.
  • Audit Data on a regular basis to ensure Data integrity and quality
  • Conducted JAD sessions, interacted with the End users on a regular basis for resolving issues pertaining to the reports, attending weekly status meetings.
  • Designed and Developed data mapping procedures ETL- Data Extraction, Data Analysis and Loading process for integrating data using Informatica.
  • Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
  • Experience in designing and development of Tableau visualization solutions and created business requirement documents and plans for creating dashboards.
  • Served as System Business Analyst meeting deadlines and budget requirements.
  • Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes .
  • Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet Business requirements.
  • Participated in the retrospective meetings and next sprint planning meetings.
  • Created and maintained issue log where Business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau Functiona l design document.
  • Assist with Support tickets and responding to developer questions; troubleshoot bugs and issues recorded in JIRA and coordinate with Lead Developers on status.
  • Analyze reporting requirements to architect appealing supportable reporting solutions.
  • Co-ordinate with Testing team for QA and UAT.
  • Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.
  • Involved in Tableau Server Installation and Configuration, creating users, groups, projects and assigning access levels.
  • Involved in Tableau server upgraded from single node to distributed environment, making Tableau services more scalable and stable.
  • Used Tabcmd and Tabadmin commands to publish workbooks and perform administrative tasks
  • Upgraded the Tableau server from 8.1 to 9.0/9.1 versions and involved in maintaining the server heath by regularly taking care of backup and cleanup activities.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Updating the IDD and Hub design documents
  • Worked on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Log Axes and dashboards using KPI's.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined best practices for Tableau report development.
  • Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
  • Preparing Dashboards using calculations, parameters in Tableau
  • Interacted with Business analysts and Data modelers and defined Mapping documents and design process for various Sources and Targets.
  • Defined best practices for Tableau Desktop and Server report development and effectively used data blending feature in tableau.
  • Created various Proof of concept interactive visualizations reports/dashboards based on the IRise prototypes.
  • Connected to Tableau through SQL, AWS Redshift databases to create customized interface for Tableau workbooks to provide native intranet style navigation.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
  • Designed SQL Server Integration Services (SSIS) packages to extract data from JDE to SQL Server Data Warehouse following the JDE specs and SQL Server standards.
  • Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Involved in creating dashboards and reports in Tableau 8.1 and maintaining server activities, user activity, and customized views on Server analysis.
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Environment: Tableau Desktop 9.0, Rally, Agile Scrum, 8.2, Shell Scripting, ERWIN, Teradata, MSBI (SSAS, SSRS, SSIS), MS SQL Server 2008R2, PL/SQL Amazon Redshift, Python, MapReduce, Oozie, Flume, Sqoop & SQL. TOAD, Flat files, Tableau server / Administrator, SQL developer, Access, .CSV Files

Confidential, Stamford CT

Sr Data Analyst / B I Developer (Wealth Management Prj)

Responsibilities:

  • Single point of contact for client for all reporting & database questions/concerns.
  • Gather and analyze the business requirements and then translate them to technical specifications.
  • Participated in all phases of Data mining, Data collection, Data cleaning, developing models, validation, and visualization and performed Gap analysis .
  • Responsible for Creating/maintaining complex SQL queries, custom queries, views, and stored procedures.
  • Extensively used JIRA for bug tracking and Project Management.
  • Selected to Agile tool selection project which resulted in the identification of a suitable Agile lifecycle management tool for Enterprise wide adoption (Rally) Capable in attributes for consistency, completeness and risk minimization.
  • Utilizing Rally for metrics/reports, user stories and defect tracking
  • Responsible for creating mapping documents for requested Data fields from Third Party Systems to UBS Data structures
  • Identified internal and external requirements requirement, design and configuration set-up and documented and delivered functional Requirements Document to the project team.
  • Analyze Data across multiple segments and provide strategic recommendations based on the project objectives including trends, alumni/member engagement, campaign performance, marketing mix informed by the data.
  • Extensively used oracle packages, stored procedures, sequences, ref-cursors, dynamic queries, UTL files, bulk inserts, exception handling, DB Links etc.
  • Worked on designing, developing, updating and modifying the query subjects in FMM former and created reports using report studio and analysis studio to match the business requirement.
  • Implemented IBM's best practices of FM modeling by creating different layers as Database layer, business layer and presentation layer.
  • Organized the query items in various folders based on their identity such as Facts, Dimensions and Reference.
  • Created SQL tables with referential integrity and developed queries using Pl/SQL Developer.
  • Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
  • Designed extensive dashboards, process map and created detailed reports about accounts, payment history, FICO scores, AML reporting and debt burden for the top management using Tableau.
  • Creating the connection with oracle OLTP to Tableau through drivers.
  • Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Develop mappings using Informatica 8.6 to process different source files and load data into staging and extracting data from staging and loading into production using Informatica 8.6
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
  • Analyzed the reporting requirements and created metadata models by connecting various data sources, building relationships between query subjects by setting up cardinalities and determinants and published them to the Cognos connection.
  • Developed various reports such as List, Cross tab, Charts, Repeater tables, Burst Reports in Cognos 10.x report studio from DMR Modeled FMM
  • Generated sophisticated reports in Cognos 10.x which include various features like Page break, Drill-Throughs, Drill-ups, Drill-downs, Master-detail Relationships, Filters, Prompts and Layout component reference.
  • Used some advanced features like conditional formatting in report studio to generate multipage reports. Implemented IBM's best practices of FMM modeling by creating different layers as Database layer, business layer and presentation layer.
  • Environment: Tableau Desktop 8.2 , Tableau server, Agile, RALLY, JIRA, Shell Scripting , Informatica 8. x, ERWIN, Cognos 10.1, 8.4, (Report Studio, Query Studio, Framework Manager, Transformer, Oracle 11g, SAP BO, and SQL Server, Informatica 8.6,

Confidential, Montvale NJ

Sr SAP BO Report Developer and Data Analyst (IBM)

Responsibilities:

  • Involved in analysis, design and gathering of requirements for project.
  • Understand and discuss the BI (ETL and Reporting) requirements with the Business Unit and preparing the detail design documentation per the standards.
  • Designs and or develops database objects ( databases , tables, stored procedures, DTS Packages ) to support the collection, tracking and reporting of business Data.
  • Manage the process that does the ingestion and delivery of subsets of licensed data to each of our client as per schedule.
  • Perform extracting, importing, and exporting of Data in various database applications.
  • Execute all regular transaction processes necessary to maintain operations records and databases.
  • Interacted with Business users and performed Gap Analysis of Client requirements.
  • Designed TSD and data mapping documents.
  • Used Erwin tool for relational database and dimensional Data warehouse designs.
  • Implemented change management after the application is in production and ensured the changes moved into production via DBA and ETL and were implemented in production with all approvals.
  • Importing the Teradata Views to the model and creating the relation between the views.
  • Work with SAP ECC source system & CRM target system functional teams for data cleansing, conversion and migration.
  • Worked on Information Designer and Webi.
  • Worked on Data Migration from SAP a nd Non SAP Data to Target databases.
  • Implemented SAP Business Objects Dashboards software in order to create executive dashboards
  • Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into target database.
  • Migrated both fact and dimension tables to HP Vertica
  • Prepared Technical Specification document and Business requirement document.
  • Involved in the Change control for the approvals.
  • Effectively involved in defect tracking, reviewing and analyzing test results using ALM (HP Quality Centre).

Environment: ECC, COPA, SD, SCM, Vistex, Business Objects 6.5/X1R2, ABAP. eradata 13.0, Oracle11g, Flat files, Windows xp, Unix, Subversion Cognos Connection, Power-Play, HP Vertica, Transformer, Excel, JavaScript, PL/SQL, Java, XML, Tomcat, SharePoint 2010, Teradata 13.0, SQL Server, SSIS, Clear Quest 6.0, Windows 2000/XP, MSOffice/Excel/Visio

Confidential, Orangeburg NY

Sr Data Analyst and BI Developer

Responsibilities:

  • Created and updated Materialized View for one of the dashboard.
  • Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision -making.
  • Designed and build relational database models and defines Data requirements to meet the business requirements.
  • Performed ad hoc analyses driven by events and actions in the Global Supply Chain.
  • Provided financial analysis related to Supply Chain activities as required.
  • Generated reports and performed analysis on the data using Oracle Business Intelligence, Complex SQL code & MS-Excel which involved KPI's in Supply Chain.
  • Extensively used Erwin r9.6 for Data modeling. Created Staging and Target Models for the Enterprise Data Warehouse.
  • Create Logical Data Model for Staging, ODS and Data Mart and Time dimension as well. Prompt resolving of the Production issues in due time.
  • Developed standard reports, Ad hoc reports, jobs, events, Dashboard, based on requirements.
  • Implementing a Business Intelligence (BI) program to improve scorecard, dashboard and analysis capabilities.
  • Collaborate with source systems Data stewards and technical personnel for Data governance and to resolve any Data quality or technical issues related to Data ingestion.
  • Worked on performance tuning of the complex transformations, mappings, sessions and SQ L queries to achieve faster Data loads to the Data warehouse .
  • Worked to ensure high levels of Data consistency between diverse source systems including flat files, XML and SQL Database.
  • Interact with customer as needed to better define and understand reporting requirements.
  • Working directly with the business to plan and implement reporting solutions.
  • Acted as liaison between business units and technology groups to identify business processes and system requirements. Including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.
  • Assisted in the troubleshooting of several VZW ( Confidential Wireless) systems problems and successfully corrected them.
  • Authoring reports in report studio per requirement by implementing many features like prompts, Conditional Formatting.
  • Developed DMR (Dimensional Modelling of Relational Data) and Relational Models using Framework manager.
  • Developed cubes using Transformer 8.4.
  • Used TM1 rules editor to create and edit rule to create various calculation
  • Utilized best in class Cognos OLAP technology to design financial solutions
  • Prompt resolving of the Production issues in due time.
  • Developed budgeting and forecasting cubes and designed standard operating manuals
  • Designed and maintained TM1 hierarchical cubes and security procedures.
  • Maintenance of TM1 users, roles, and security
  • Developed standard reports, Ad hoc reports, jobs, events, Dashboard, based on requirements.
  • Used Replication to copy the Cubes from one server to another server
  • Import the data from ODBC and Text files using TM1 Turbo integrator .
  • Manage TM1 data through TM1 Reports (Active Form & Slice)
  • Created Boolean variables and String variables for blocking charts.
  • Redesigning and creating new reports per the user requirements.
  • Extensive usage of SQL Queries for data Analysis.
  • Developed multidimensional models (DMR) and published packages using Framework Manager (FMM) and then generated reports from these packages.
  • Involved in review sessions and demos with business users and draft design/solution
  • Maintain the repositories for different environments like DEV, QA and PROD
  • Regularly synchronized the QA, DEV environments with Production reports.
  • Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
  • Extensive experience in Designing the FMM, to meet BI industry standards applied Physical Layer, Business Layer and Presentation Layer approach to increase the model durability.
  • Created Data Level, Object level, Package level and Row Level Securities in FMM.
  • Hosted Weekly status meetings to update and explain the work expected from them in coming week as well as get status on work completed to Cognos developers.
  • Responsible to support the issues with reports on the Cognos enterprise environments (Development, UAT, Test and Production)
  • Responsible to Sign-Off on the crystal enterprise and Ad-Hoc application after the release.
  • Responsible to trouble shoot problems incurred on parameter tool communication to Enterprise System.

Environment: Cognos 8.4, 10.0(Framework Manager(FMM), Report Studio, JIRA, Query Studio, Metric Studio, Analysis Studio, Transformer) Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, MS Excel, JavaScript, Oracle Warehouse builder 10 (OWB)PL/SQL, Java, XML, Tomcat, TM1 9.0, Turbo Integrator, Architect, Oracle 10G, Toad 9.7.2, Oracle Ware house builder, UNIX

Confidential, Ridgefield CT

Sr. Cognos BI and Data Analyst developer

Responsibilities:

  • Involved in Understanding Existing Business Models and Customer requirements by participating in the Designing Phase meetings with users.
  • Involved in maintaining and updating Metadata Repository with details on the nature and use of applications Data transformations to facilitate impact analysis.
  • Created DDL scripts using ER Studio and source to target mappings to bring the Data from source to the warehouse.
  • Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
  • Authoring reports in report studio per requirement by implementing many features like prompts, Conditional Formatting.
  • Created Boolean variables and String variables for blocking charts.
  • Redesigning and creating new reports per the user requirements.
  • Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
  • Used Framework Manager (FMM) to Build Models (layers, Cardinality, Relationships, Query subjects), Packages and publish packages to cognos connection. Defining appropriate relationships between query subjects in Framework manager.
  • Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
  • Extensively worked on Oracle SQL, created joins between huge tables to map the columns from multiple tables.
  • Involved in understanding the customer needs with regards to Data, documenting requirements, developing complex SQL statements to extract the Data and packaging/encrypting Data for delivery to customers.
  • Regularly monitor performance and availability of the environments
  • Support Production & Non-Prod Non-Prod Congo’s environment Servers
  • Worked closely with the business users to build the models and delivered based on the
  • Involved in review sessions and demos with business users and draft design/solution
  • Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
  • Created Jobs to Schedule multiple reports in Cognos Connection.
  • Involved in design and development of joins, filters, calculations and conditional variables in Packages within Framework Manager.
  • Created my own PL/SQL queries in form of Materialized View, Views, Stored Procedures on front end utilities like TOAD and SQL* Plus
  • Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
  • Worked closely with the business users to build the models and delivered based on the sign-off
  • Worked extensively using Hints to Achieve the Performance and Tuned SQL, PL/SQL Queries and Stored Procedures, improved the performance of the reports.

Environment: Cognos 8.1(Framework Manager, Report Studio, Query Studio, Metric, SSIS, Studio, Analysis Studio, Transformer) Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, MS Excel, JavaScript, PL/SQL, Java, XML, Tomcat, Oracle 8i, Toad 9.7.2, Clear Case, Quality Centre, UNIX, Quick Test Pro, Clear case, Windows 2000/XP, MSOffice/Excel/Visio

Confidential

Cognos Developer

Responsibilities:

  • Analyzed & defined customer requirements/ specifications and offered solutions to fit the customer’s need.
  • Use Cognos Impromptu to create Catalog files, create IMR/IQD and Cubes using Cognos 7 EP Series, Impromptu and Transformer. Schedule the cubes.
  • Applied appropriate client/database server balancing for the reports.
  • Created User Classes that reflects the business hierarchy and provided security.
  • Designed Catalogs, Reports and IQD’s using Impromptu Administrator.
  • Created standard filters, calculation, prompts, and conditions.
  • Published reports to the upfront web portal to provide accessibility to the staff.
  • Created cascading prompts in Impromptu reports to help users refine their search.
  • Created Drill-Through reports to provide users with more detailed information.
  • Created List Reports, Crosstab Reports and Drill through Reports.
  • Published Impromptu Web Reports.

Hire Now