SUMMARY

• Over 10 years of experience in Analysis, Design, development and implementation of IT solutions.
• Expertise in all phases of Software Development Life Cycle (SDLC) using Traditional and Agile Methodologies.
• Involved in Data Modelling, Star Join Schema Modelling, Snow - Flake Modelling, FACT and Dimensions Tables, Physical and Logical Data Modelling.
• Experienced with mentoring TeraData Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing.
• Extensively worked on BI Launch Pad and Infoview to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Implemented 3 full life cycle implementations on BO following ASAP Methodologies which involves Blue Printing, Realization, Production Support, Testing, Requirement analysis, End User documentation and Reporting.
• Hands on experience in Business Objects 4.1 and migration from Business Objects XI 3.1 to Business Objects 4.1.
• Expertise in Business Objects XI 3.1/3.0/XI R2/6.x/5 (Designer, CMC, Desktop Intelligence, Web
• Intelligence and Info View, Import Wizard, Report Conversion tool, Publishing Wizard, CCM).
• Expert in creating multifaceted Ad-Hoc reports using Business Objects, Web Intelligence, Desktop Intelligence, Webi Rich Client.
• Experience in SAP Dashboards and Crystal Xcelsius to create interactive dashboards by using QAAWS and Live Office .
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
• Expertise in Power BI, Power BI Pro, Power BI Mobile. Expert in creating and developing Power BI Dashboards into rich look.
• Experienced in working with Business Managers, Architects, End users and all the stake holders in documenting requirements, providing estimates, creating High and Detail Level design specifications.
• Expertise in Designing Universe on different relational databases such as Oracle, Teradata, SQL Server, DB2, and Sybase.
• Having experience in gathering and analyzing the requirements from end-users and trained users in Business Objects for Ad-hoc reporting.
• Strong experience in training end users to create, modify and customize their own Reports and dashboards using BI Launch Pad, SAP Dashboards, Info View and Web Intelligence. Expertise in translating report requirements into detailed report specifications.
• Expertise in retrieving data using Business Objects Universes, personal data files and free hand SQL methods.
• Expertise in using Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Dev, QA and Production.
• Experience working with AD (Active Directory) Groups, Row Level Security, and Access groups Security.
• Hands-on experience in installing Business Objects server products in multi-node cluster environments using APACHE-TOMCAT and WEBLOGIC - WEBSPHERE as Web and Application Servers.
• Diversified experience in implementation of Business objects in Finance, Health, Sales, Retail, Production and Insurance sectors.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals/teams at all levels.

TECHNICAL SKILLS

Reporting Tools: Business Objects 4.1, Power BI, Business Objects XI3.1/XIR2/6.x/5.x (CMC, Designer, Reporter), BI Launch Pad, SAP Dashboards, Web Intelligence XI/6.x, Info View, Dashboard Manager, Voyager, Xcelsius, QAAWs, Live Office and Crystal Reports XI/9.0, Import Wizard, Report Conversion Tool, SDK,SSRS,SSAS.

ETL Tools: Teradata Utilities, Informatica 7.1, BO Data Services (BODS), BO Data Integrator BODI 11.7.3

Operating Systems: Sun Solaris 8/9, Unix and Windows NT/2000/2003/XP.

Languages: C, C++, SQL, PL/SQL, Visual Basic 6.0, UNIX Shell scripting, XML, VB, ASP

RDBMS: Oracle 11g/10g/9i/ 8i/, TeraData, SQL Server 2000/05/08, DB2, MS Access, MySQL 5.0, Sybase 12.0

Servers: Web Logic Application Server 6.1 / 5.1, Web Sphere 4.0.2, TOMCAT 3.2.1

TeraData Utilities and tools: BTEQ, FastLoad, MLoad, FastExport, SQL*Loader, Exp/Imp, TeraData SQL assistant, TeraData Manager, TeraData Administrator, TeraData

Tools: ER Studio, Erwin 4.1, TOAD, SQL* PLUS.

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Lead Teradata/ETL Developer

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Developed the Financial Universe using Information Design tool (IDT) and Web Intelligence Reports.
• Designed new Web Intelligence reports using sections to include all State, County, District, Section, Supervisor and case worker reports in one report.
• Involved in Performance Tuning of reports against the TeraData for faster queries.
• Involved in developing the highly tuned SQL in TeraData and Oracle database environments.
• Used TeraData utilities such as Fast Load, MultiLoad, BTEQ, OleLoad and TPump
• Tested and migrated universes and documents across testing/production repositories.
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.
• Worked extensively with SQL*Plus, TeraData SQL Assistance for writing user defined queries in the process of testing the reports in UAT (User Acceptance Testing) stage.
• Developed the Dashboards using Xcelsius and SAP Dashboards tools and Implemented dashboard concept for the first time in Confidential .
• Have used both QAAWS and Live Office for developing the dashboards called Book of Business where users can able to see Current, Previous and Next Month progress on Dashboard.
• Developed Power BI model used for Children services reporting of MiSACWIS System.
• Designed and documented the entire Architecture of Power BI POC.
• Investigate and resolve performance issues with BO Reports (canned and ad-hoc) in a timely and efficient manner.
• Troubleshoot reporting issues and contribute to development efforts using SQL and BO as a query generating tool.
• Contributing to the team effort and output by interacting with users and the team to improve timeliness and quality of results. Responded to the BO end users in a timely manner to answer their questions and resolve issues.
• Performed regular integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Extensively used Business Objects functionality like Aggregate Awareness functions on summary tables, custom Hierarchies, custom LOV files, pre-defined conditions, user’s objects and formulas in the creation of universes.
• Identified existing performance issues related to the Federal reports, that way they can be rectified and eliminated with the new design.

Environment: Tera Data V2R12, Information Design Tool (IDT), Web Intelligence, Xcelsius 2008, QAAWS, Live Office, TeraData SQL Assistance, Business Objects 4.1, Power BI, Business Objects XI 3.1, SQL Server 2008, PL/SQL, Windows 7/XP.

Confidential, Burlington, MA

Sr. TeraData/ETL Consultant

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Worked on existing Accounts Payables, Accounts Receivables, Purchasing, General Ledger Universes and did the required modifications.
• Involved in Performance Tuning of reports against the TeraData for faster queries.
• Involved in developing the highly tuned SQL in TeraData and Oracle database environments.
• Developed Admin tasks like creating Repository and Development instances, managed BO Users like adding new users, creating, new groups, applying row level security etc.
• Created new classes, objects and made structural changes to Universes in Designer to include new objects, updated tables and joins. Also handled testing and debugging of Universes after enhancements and modifications were made.
• Created complex universes by employing various techniques including loop detection, prompts, conditions, classes, objects, dimensions, measures, details, joins, cardinality, keys, data integrity, LOVs (list of values), aliases, derived tables, multiple contexts, and hierarchies.
• Performed regular integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Built a logic to print out error messages and send email alert on each failed attempt to Data Services Administrator
• Maintained a Audit fact table to log audit, balance and control information including job start, end times, total records inserted, total records updated and total records rejected used validation transformation to define the logic to load yellow records with alert and reject red records with error
• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
• Expanded Physical Data Model (PDM) for the OLTP application using Erwin.
• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.
• Linked universes used Aggregate Awareness tables and resolved connection issues for multiple domains.
• Tested and migrated universes and documents across testing/production repositories.
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.
• Identified existing performance issues related to the financial reports, that way they can be rectified and eliminated with the new design.
• Designed Crystal Reports for product, customer, and vendor details. Created financial crystal reports for the upper level management using formulas and formatting according to end user needs.
• Worked extensively with SQL*Plus, TeraData SQL Assistance for writing user defined queries in the process of testing the reports in UAT (User Acceptance Testing) stage.

Environment: TeradataV2R12, TeraData SQL Assistant, Universe Design, Web Intelligence, Business Objects XI 3.1, Oracle 11g, Crystal Reports 2008, SQL Server 2008, PL/SQL, Windows XP.