SUMMARY

• 12+ years of work experience within USA as Software developer, Analyst, BI Analyst/Designer/Developer, worked on Projects in multinational companies with diverse Platforms and Environments
• Strong knowledge of Data modeling and design of data warehouse from Data Normalization to Data demoralization
• Working and Managing OS i.e. OS/400, Unix, Linux, Windows server
• Expertise in using dimensional data modeling (Star/Snowflake Schema) delivering facts, dimensions, aggregate and bridge tables into staging area and then load into data warehouse.
• Expertise in designing normalized and demoralized structures needed in Star and Snow Flake schema design, building Summarized/Aggregation tables, data conversion from various structures (flat files, relational. Semi structured into Oracle, SQL server, DB2 and MySQL
• Solid understanding and design of normalized (up to 3rd NF) transactional oriented data base system (OLTP) and provided services using AIP/SSPs for application supporting various business users.
• Expertise in solving complex reporting issues by cross tab, slicing, dicing, drill through using TIBCO Spotfire, Crystal Reports, Query/400
• Designing and implementing BI process in diversified data environments using TIBCO Spotfire 4.x, 5.x, Cognos, MicroStrategy and other tools and languages
• Executed the POC in Spotfire 5.5 using on - demand database table and in database aggregation for large databases

TECHNICAL SKILLS

Hardware: IBM AS/400, Intel based servers (Dell, HP/Compaq, IBM)

OPERATING SYSTEMS: OS/400, Unix, Linux, WINDOWS Server 2003/2008

LANGUAGES/UTILITIES/Databases: TIBCO Spotfire, Cognos, MicroStrategy, CrystalReports, Oracle OBIEE, EXTOL EDI Collaboration, Oracle 9g/10g/11g, DB2, Oracle, MS SQL server, MS Office Collaboration, MySQL, SQL PLUS, SQL Developer, Query Builder, PL/SQL, C#, .NET, ASP.NET, R Scripting, IronPython

PROFESSIONAL EXPERIENCE

Confidential

Spotfire Lead

Responsibilities:

• Work closely with Tibco Spotfire Professional, to get the Knowledge Transfer
• During SIT/UAT work with offshore team and UAT team to fix bugs/defects
• Work with Offshore team for development of SDLC Documents (Functional Design Specification, Technical Design Specifications and Work Instructions for the L1, L2 & L3 support
• Work closely with infrastructure team to setup Code Migration from Dev to QA and QA to Prod
• Helping users during Go-Live and support L1/L2/L3 support for high level defects or user access problems to identify problem areas and provide solutions

Confidential

Sr. Data Analyst/BI Developer

Responsibilities:

• Install, configure, maintain, upgrade, TIBCO Spotfire server components, Tibco Spotfire application Data Services, end user environment on Windows and other systems;
• Develop Key Performance Indicators (KPI) to enhance management capability and to evaluate vendor performance
• Administered users and Library Management, access levels, rights and folder structure
• Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures
• Created dashboards and visualization by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas,
• Creating visualization using advanced Heat Map, Trellis, Scatter plots, 3D Scatter Plots
• Creating Dynamic Visualizations using Text Area, Input Field, Lists, drop down lists, Property, Document Properties, Web Links and On-Demand Data
• Use of advanced functions to form complex custom columns and expressions using Binning, Ranking, OVER, Spatial, Property
• Publishing the developed End User Visualization/portals and managing the User Control and Access Level
• Design the portals for Price, stock status, Vendor Performance, Compliance and Promotions
• Executed the POC in Spotfire 5.5 using on-demand database table and in database aggregation using Information links to design visualization for large databases.

Environment: Windows Server, Linux, Tibco Spotfire 4.x,5.x, IBM Cognos, MicroStrategy, Oracle, MySQL, MS SQL Server 200, SQL Developer, Query Builder, ODBC, MS Office, C#, R Scripting, ASP.NET, Java, Java Scripting

Confidential, Dallas, TX

BI Architect/Designer

Responsibilities:

• Detail analysis in understanding business process to create conceptual model to know the MRP system
• Analyzed various metrics such as Inventory, Customer, Warehouse, Purchasing, Sales and Marketing
• Work with the team to design ETL as per BI Requirement communicating the requirement with the ETL Team work with them to finalize the Data warehouse Structures and Granularity of Data.
• Work with teams to design Meta Data, Dictionaries, to eliminate the redundant use of physical data.
• Work closely on structural designing of Data Marts
• Acquiring user requirement for the decision support system and reporting
• Administer and Implement the TIBO Spotfire, managing users, updates and backup and recovery
• Design and implement the reporting portal for high level decision makers using TIBCO Spotfire
• Design, implement, and collaborate Spotfire Visualization, portals, Dashboards for managers, executives and CEO
• Designing the End User portal and Management information portal for decision makers
• Creating Visualization Summary/Detail tables, Bar Charts, Pie Charts, scatter plots, heat maps customizing Visualization using filters, markings, custom columns and custom expressions

Environment: AS/400, Windows Server, VAI 2K, Crystal Report, Tibco Spotfire, Oracle 10g, ODBC, PL SQL, SQL*PLUS, ILECOBOL/400, SQL/400, DB2, MS Office collaboration, MS SQL Server 2003, Java Scripting, ASP.NET

Confidential, NJ

Software Engineer

Responsibilities:

• To maintain, develop, debug, test and document the changes in application system to improve performance and efficiency.
• To manage and maintain ERP/MRP system of VAI S2K on IBM AS/400, generate reports using Query/400
• Designing the Executive Information system using Oracle and Crystal Report
• Design and develop the backup routines, schedule the backup and manage the batch jobs there priorities and time, manage safe restore/recovery of the backup.
• Manage IBM AS/400 Clients dumb terminals or PC using IBM iSeries Navigator or Client Access.
• Managing PC Connections to the database using ODBC.
• Journaling databases to get the safe data entry in case of data connection loss or abnormal termination.
• Managing Database using SQL/400 to generate queries and designing complex reports.
• Managing and administering security (Users and Devices) on IBM AS/400, managing connections, users/jobs in different pools/subsystem on the bases of priority.
• Running jobs/reports in batch, scheduling in different times as per there priority.
• Develop and design the complex reports using COBOL/400 and day to day on request reports on Query/400 and SQL/400.
• Managing Disk space on IBM AS/400 cleaning up old reports, temporary files, and journals to keep the disk clean and available for data.
• Interact with users to find the best way to resolve complex problems and to implement the best solution.
• Performing IBM AS/400 Maintenance and PTFs installation, hardware requirements and update of the system resources
• Managing EDI data and application, generating reports and developing extensions.
• Manage Windows 2k3 servers, users, data space, backup and recovery, Remote Desktop server to give access to remote users so they can work remotely.
• Managing Red Hat Enterprise Linux Server, applications such as Apache server (web Server), mail server (postfix, Cyrus IMAP), and DNS server BIND.