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

Sr. Data Analyst/BI Developer

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
• 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
• Works on Information designer to design and optimize the information links, custom SQL for the project, worked closely with the database team to get the best performance in data load time in Spotifre rganizing the End user views/tabs and designing the user experience with all the security measures the project requires data security on different user roles and access level writing scripts in Iron Python to manipulate data and extend the functionality of different visualizations
• The project requires worldwide user access using Spotfire Web Player, customizing, managing and enhancing functionality of Web Player to achieve performance constraints
• Administering/Organizing development in Spotfire using Library Administration, user access and Folder administration
• Customizing and controlling Visualization by use of Text Areas and controls such as Drop down lists, Icons, Buttons and Iron Python scripts
• Customizing Filter schemes and providing user customized filters as per visualization and data
• Designing Code migration, and managing Code migration in between Development to QA and QA to Prod environments

Tools: used: TIBCO Spotfire 5.5, Oracle EDGE2 Database,, IronPython, MS Share Point

Confidential, NC

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 TerraData, BigData.

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 executive reporting, managing users, updates and backup and recovery
• Design and implement the reporting portal for high level decision makers using multiple reporting tools
• Design, implement, and collaborate Visualization, portals, Dashboards for managers, executives and CEO
• Designing the End User portal and Management information portal for decision makers
• Creating executive reporting using Summary/Detail views, Bar Charts, Pie Charts

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

Confidential, North Brunswick, 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.