SUMMARY

• 8+ years of IT Experience on ETL and Business Intelligence Applications
• Four years on TIBCO Spotfire
• Experience with SAP Business Objects - Created Business Objects Repositories, Designed Universes, Developed Full Client reports with multiple Data Providers, free hand SQL
• One year experience in Pentaho ETL - includes developing mappings, Defining Job, data and Work flows, Validating and cleansing data, fixing issues related to slowly changing dimensions
• Conducted Gap Analysis, created Use Cases, Work flows, screen shots and Power Point presentations for the Web Applications
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by teams across the deliverables for a project
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default). Proficient in Star schema and Snowflake schema designs
• Knowledge of Metadata management in consolidating metadata from disparate tools and sources including ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis
• Strong understanding of project life cycle and SDLC methodologies including RUP, Waterfall Agile and Scrum
• Excellent knowledge of Business Analysis methodologies and Project Management processes
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills
• Good independent / team working skills and experience, excellent communication skills and customer handling capabilities

TECHNICAL SKILLS

BI / Visualization Tools: Spotfire Desktop, Spotfire Server,SAP BO

Databases: MS SQL Server, Oracle

ETL/Data Integration: Pentaho Suite and SSIS

Process/Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, MI

Sr. Tibco Spotfire Admin

Responsibilities:

• Used Spotfire expressions and OVER statements for calculations
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc
• Used data table properties, property controls, filters, joins and custom functions
• Created Information links, parameterization, defined join rules in Information designer.
• Created Personalized Information links for setting up row level security
• Created Action Controls and wrote scripts using Iron Python. Performed several customizations using the scripts
• Used Lists, tags and Bookmarks to save
• Used Filter Schemes to isolate the filter behaviors on visualizations
• Used Dynamic calculations based on the markings user selects in the visualizations
• Set up Collaboration Platforms
• Applied best practices in dashboard design development
• Participated in scrum meetings on daily basis
• Used Multiple datasources for creating dashboards
• Used Load on Demand and Caching to improve performance of DXP files
• Created configuration blocks in Spotfire and set up guided analysis to carry the filter selections from one analysis to other.
• Migrated the code from Dev to test and to prod after testing.Tested for the Data counts,Data Quality,Spotfire Interface

Environment: Tibco Spotfire Professional 7.0, Spotfire server, Web player, SQL Server

Confidential, Rockville, MD

Sr. Spotfire Admin

Responsibilities:

• Created Information links, parameterization, defined join rules in Information designer.Interacted with users and Gathered, addressed business and technical requirements; translated business requirements into technical requirements and specifications
• Installed Spotfire Server, Databasedrivers, Hotfixes
• Used Load on Demand to improve performance of spotfire dashboards
• Set up Projects, Groups, Users and set up Permissions
• Extensive development experience in creating, modifying Spotfire visualization Dashboards and getting data into Spotfire from different data sources
• Apply the best design practices for analysis and dashboards creation
• Expert in manipulating existing data columns, merge data, add data tables, connect to in-database data, using Bookmarks, Tags, and Lists to capture aspects of dynamic analysis and consider the available aggregation options and expression shortcuts
• Installed, configured and administered the Server environment, including Users, Groups, Licenses, Preferences, and Properties
• Performed daily admin tasks of User Registration, Security Configuration and Usage monitoring
• Optimized Information Links and queries to increase performance design and implementation of global, enterprise class Spotfire environment
• Experienced in tuning long running SQL queries for better performance
• Gathered user requirements, analyzed and designed software solution based on requirements
• Installed Spotfire Server in Dev, QA, UAT and Prod environments
• Deployed Spotfire in clustered environment by mapping server nodes to primary machine
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Participated in business requirement document preparation
• Maintained and updated dashboard reports as required by client
• Analyzed external and regulatory reporting, intercompany and internal management reporting needs of the business process
• Conducted and guided Spotfire BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve steady state for transitioning
• Designed executive dashboards that offers fast and flexible access to all key information across the enterprise
• Maintained user guides and documentation for Spotfire applications

Environment: TibcoSpotfire 6.5, Windows 2008 server, SQL Server 2012

Confidential, Kansas City, Kansas

SAP Business Objects Developer

Responsibilities:

• Spearheaded the Business Objects 6.5 to XI 3.0 migration project. Designed and implemented the roadmap for migrating Business Objects the deployment from 6.5 to XI 3.0
• Interacted with users and Gathered, addressed business and technical requirements; translated business requirements into technical requirements and specifications
• Created scripts for Oracle Tables, Indexes, Users, Roles, views and Stored Procedures and Functions using SQL,PL/SQL
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Prepared operation instruction manuals to business users
• Set up best practices for all Business Objects development and administration
• Prepared Test Data and Validated programs and the reports against the oracle 9i database
• Created, and optimized Business ObjectsUniverses for Financial, Procurement and Fixed Assets using Designer
• Performed Administrative tasks like Setting up user profiles, assigning rights and privilegesfor groups, setting up Categories using Central Management Console
• Created Financial, Procurement and Fixed Assets reports and Xcelsius Dashboards.
• Created HR Reports like Grant Certification, Leave Accruals, W2 Audit, Payroll, CIGNA, Retirement Projections, Pension Enrollment etc
• Use advanced Business Objects techniques to present data including contexts, drill downs, hierarchies, advances functions, predefined conditions, prompts
• Tuned Universes, created Contexts and Aliases for resolving Loops, Fan Traps, Chasm Traps, and checked the Integrity of the Business Objects Universes
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure
• Created Indexes and Summary tables for improving the performance of reports
• Designed and Developed Datamarts using Star Schema and Snow Flake Schemas

Environment: Business Objects (Designer,Desktop Intelligence,Central Management Console, Web Intelligence, Xcelsius, Websphere), Windows 2003, oracle 9i

Confidential, Cary, NC

Pentaho Developer

Responsibilities:

• Developed DDL scripts for creation of tables, indexes, views and other Oracle Server objects.
• Used Pentaho Data Integration/Kettle to design all ETL processes to extract data from various sources including live system and external files, cleanse and then load the data into target data warehouse
• Provide enhancements and maintenance support to current application.
• Designed pilot system using Pentaho Kettle for ETL enhancements and Pentaho BI Server for publishing the Pentaho Reports on user funds transfer measures.
• Used several transformations in Kettle to cleanse, validate and improve quality of data before loading it into target schemas.
• Dealt with SCD type 2 and multi-level hierarchical dimensions.
• Created various ad-hoc reports using Pentaho Analyzer to allow users to generate reports on the fly by dragging and dropping dimensions onto rows and/or columns and dropping one or more measures to get the results.
• Used various types of inputs and outputs in Pentaho Kettle including Database Tables, MS Access, Text Files, Excel files and CSV files.
• Implemented miscellaneous transformations in Kettle Spoon Designer including Database Lookup, Database Join, Calculator, Generate Rows, Mapping Transformation, Filter Rows, Dimension Lookup/Update, Add Sequence, Add Constants, Row Normalizer and Row Denormalizer.
• Used SQL Loader to import bulk data in Oracle tables from data files of different formats including fixed record, variable record and stream record format.
• Created and scheduled Various Daily running and Month end SQL Jobs, using SQL Server Agent to perform various ETL operations.
• Generated reports using SSRS 2005 as per business requirements.
• Performed data extraction and migration activities for populating test (or non-production) and customer databases.
• Wrote UNIX shell Scripts for file validations and scheduling Data Stage jobs and for preprocessing and post processing of the files.
• Created SQL scripts for tuning and scheduling.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimized long running SQL queries.
• Performed development support, documented reviews and test plans.
• Created and maintained Indexes for various fast and efficient reporting processes. monitored the error log for any errors.
• Created users and roles in Oracle as well as Windows 2003 Server and maintained proper security procedures by assigning appropriate permission levels to the users.

Environment: Pentaho, Oracle 9i, Crystal Reports 9.0

Confidential, NJ

ETL Developer

Responsibilities:

• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes
• Involved in merging existing databases and designed new data models to meet the requirements
• Create joins and sub-queries for complex queries involving multiple tables
• Use DDL and DML for writing triggers, stored procedures, and data manipulations
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports OLAP reporting, dashboards, and scorecards
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.

Environment: SSIS, SSRS, SQL Server