SUMMARY:

• 8 years of IT industry experience encompassing wide range of skill sets, roles and industry verticals exhibiting strong technical and leadership skills.
• Demonstrated expertise with a track record of managing multiple complex IT projects in Healthcare, Retail industries.
• Extensive experience in Business requirements gathering, analysis and implementation of DW and BI processes, Business processes improvements and Customer relationship management
• Good experience in Agile Scrum project environment in Data warehousing and BI projects.
• Experience in various roles as ETL developer, Data Analyst, Quality Analyst, Business Intelligence Analyst in Agile Scrum Lifecycle projects.
• Cross - team cross-functional working experience in large scale organizations.
• Interface directly with clients to determine high-level business requirements initiatives, provide process flows, and liaison with software development staff when necessary.
• Automated and streamlined core manual operations such as data loading, Vendor Management and integrate processes, data, and systems to increase agility and drive greater visibility of project performance.
• Involved in various phases of complete Software Development Life Cycle for the past 6 years.
• Extensive working experience with multiple teams in different time zones both in US and Overseas.
• Excellent project coordination skills.
• Excellent Communication and troubleshooting skills with great ability to adapt to new technologies in real-time environment.
• Analytical thinking to foresee potential data issues, risk mitigation, proactive communication, damage control are the biggest strengths.
• Work output is of consistent high quality, accurate and on time. Can be depended upon to complete a task even if it requires extra time/effort
• Adaptable to constant changes and consistent challenges in work environment.
• Good working experience on DW technologies - Informatica, Microsoft Business Intelligence(MSBI- SSIS, SSRS,SSAS), SAP Business Objects XIR2, Pentaho
• Good working experience on ITSM Enterprise Management Solutions - Remedy, Atrium CMDB, BPPM, HP OMW, HP Service Manager, CA Spectrum
• Experience in Qlikview /Qliksense, Tableau, ROAMBI, Data visualization technologies.
• Very diligent and can be depended upon to complete a task even if it requires extra time/effort.
• Excellent documentation skills for ongoing and future business and IT practices.

TECHNICAL SKILLS:

Business Intelligence and Datawarehousing: Microsoft Business Intelligence (MSBI), Bussiness Objects XIR2, Informatica 9.1,Pentaho, SalesForce

Data Visualization: Qlikview, RoamBI, Tableau

Databases: SQL server 2005/2008, Oracle 9I, Exadata, MySQL

Administration: Tableau, Qlikview, Business Objects, Informatica, SAS

Operating Systems: Windows 95/98/2000/2003/ XP/7, Unix, Linux, HP RISC, HP-UX Itanium

Application/Web Servers: IBM Web Sphere, Apache Jakarta Tomcat, Jboss, weblogic

Web Services & XML: XML, SOAP, WSDL

WORK EXPERIENCE:

Confidential

BI Analyst

Responsibilities:

• Developed ETL mappings for EPOS and REWE data based on the business rules defined by client.
• Worked on performance improvement at both the ETL level and Database level by finding the longest running jobs/transformations and scripts.
• Worked closely with Client Success manager for requirements gathering, ETL code development, Unit testing and deployment into Prod environment.
• Actively involved in complete Agile Scrum methodology project life cycle in the Design, coding, and testing of DW data model and all related documentations.
• Very actively involved in Agile Sprint meetings for transparency, maintain up-to-date status, track timelines and faster ROI.
• Very prompt analysis, review and resolution of data issues reported by client.
• Worked in Cross team cross functional environment that consists of both IT technical and Business teams.
• Worked very efficiently in an Onsite-Offshore model to provide successful hand-off on a daily basis with colleagues working in different time zones.
• Successful project implementation and delivery because of the close working relationship between the development and business and client management teams.
• Created ER models and data models for loading retailer’s data received from various external sources like Nielsen etc.
• Created reusable mappings using mapplets, mapping parameters and variables.
• Involved in migration of ETL Code to different environments from Dev to UAT and then to Production.
• Involved in data migration from Dev/QA/UAT to PROD database systems.
• Involved in successful data loading and data validation of LAND, LNK, CNF,PRS database layers.
• Successful Database and Tableau refresh using Confidential Harmonizer technology.
• Very careful project Coordination to achieve client satisfaction by rapid, continuous delivery of useful BI reports
• Involved in capturing audit information and successful/failure job runs and user information for future auditing and analysis.
• Delivered working BI reports frequently (in days and weeks rather than months).
• Able to welcome late changes in requirements due to strong advocacy of Agile Scrum methodology.
• Regular adaptation to changing circumstances based on client’s needs.
• Involved in design and review of Technical design specification documentation.
• Involved in design and review of Functional design documentation.
• Involved in design and review of Data Dictionary for various KPIs defined for Confidential .
• Involved in design and review of KPI mapping between Confidential and various data sources ( Nielsen, TPM, Salesforce).

Environment: MS SQL Server Management Studio 2016, Pentaho 7, Tableau, Unix, Java, Confidential Harmonizer, Data Integrator, Workbench, Jira.

Confidential

Cload/C3PI/ODS/SSP Operations Lead

Responsibilities:

• Worked as Business Operations lead for Content and Structural validations of 867 Sales and Inventory data.
• Worked on multiple solutions/projects at Confidential Cload, SSP,SFDC LAND ODS, C3PI.
• Lead the IT activities in loading, processing, validating 867 data publications to multiple downstream systems on Daily/Weekly/Monthly basis.
• Leading Confidential offshore resources and also works hand in hand with onsite Business and IT teams.
• Leading the C3PI data loads monitoring efforts for SAP, CARS, HCOS and 867 loads.
• Showed good project coordination skills while working with FOIM, C3PI, B2B, Offshore teams.
• Solely driven Data on-boarding processes end-to-end for Sales data of various trading partners.
• Worked as a single point of contact for FOIM, C3PI, B2B, Offshore support teams for 867 files data loading, validating, reporting and publications to downstream systems.
• Worked with offshore team to carefully create and configure necessary file specifications so that new sender’s files load into Cload system for content and structural validations.
• Working with C3PI and FOIM teams to make necessary configuration changes in the process of publishing new sender’s data to downstream systems (MCDM, IMS XPONENT).
• Worked with Business Objects, Qlikview, Cload Admins, B2B teams about new trading partner data for necessary configuration changes in their environment in the process to make sure all the data level metrics are available for content review.
• Involved in on-boarding new drug into IT systems (Cload, C3PI, IMS SPP) to make sure the new product’s sales are flowing smoothly into downstream systems.
• Developed processes to identify the erroneous sales data files coming to Cload system and notify both Business leads and IT teams on a daily basis. This helps to immediately notify at what all files have failed in the process of flowing through from trading partner to B2B team to Cload environment.
• Validation and supplementation of XPO data to IMS Health on a monthly basis.
• Understands downstream impact for any issues or errors within our systems which is very crucial for the success of my projects.
• Delivered consistently with highest quality on all deliverable (MCDM publish, Early Publish, IMS Supplemental, Lucentis, WSRs) without breaching an SLA for more than 2 years.
• Maintain crisp and clear communication with different teams so that every stakeholder is on same page.
• Working on Cload workbench application for 867 monthly and weekly sales data loading and validations
• Communicate proactively with corresponding teams in times of any system failure or unexpected downtime.
• Maintaining the list of Trading Partners (SPs, SDs and Wholesalers) whose sales publish to the corresponding downstream systems to ensure none of them get missed during publications.
• Maintained reports in terms of Date of delivery from trading partner, File validation date, File Release date to keep track of any delay either from trading partners(SPs, SDs, Wholesalers) or B2B failure or delay in offshore support or delay in content review in the course of Operations.
• Maintained proper documentation on the challenges and issues faced during the course of operations and shared with corresponding Business and IT teams.
• Worked with FOIM, C3PI, Offshore, B2B teams in the process of fixing UOM inconsistencies.
• Wrote SQL and PL/SQL queries in Oracle database systems.
• Designed and Developed Multiple Qlikview/QlikSense dashboards for multiple business teams requirements.
• Developed and actively involved in accomplishing GSR maintenance and enhancements across Cload, SSP, LAND ODS, C3PI projects.
• Played active role in database upgrade from Oracle 9I to Exadata. This has resulted in significant performance improvement in Qlikview, BO reporting on 867 data.
• Worked on SAP Redwood jobs for creating, scheduling and monitoring SAP, CARS, HCOS, 867 Sales monthly and weekly loads.
• Played active role in a crucial database upgrade from Oracle 9I to Exadata. This has resulted in significant performance improvement in Qlikview, BO reporting on 867 data.
• Played an active role in the retirement of STARS system.
• Played a very important role in Requirements gathering and Function Spec documentation.
• Played an active role in testing Confidential Sales Tracker System (new SRW system).
• Played an active role in the development, testing and implementation of Qlikview dashboards for 867 data validations.

Environment: Oracle 9I/Exadata, Informatica 9.1, SAP Business Objects, Qlikview/Qliksense, Unix, Cload, SFDC, SAS.

Confidential

Business Analyst

Responsibilities:

• Worked with Confidential Sales data in the areas of Service Support, Service Assurance and Server Automation.
• Lead activities for Sales data load and validation before fed into databases for further reporting and analysis.
• Involved in running data load jobs on a daily, weekly and monthly basis.
• Resolved data related issues whenever there are problems with the data coming from various stakeholders.
• Coordinated with various teams in case of any issues or applying any new rules to the existing data load jobs.
• Implemented Delta, Incremental and full load of sales related data into databases.
• Involved in provisioning VMs in Vcenter ESXi server required to install the necessary software as part of this project
• Involved in the installation of products in the areas of Application performance management, Network infrastructure management, Service support modules.
• Installed Microsoft SQL server 2008, BPPM 8.1 and Remedy 7.6.03 on windows virtual environment.
• Configured and implemented both BPPM and Service Desk in Confidential ’s data centre.
• Integrated both BPPM and Service desk for two way communication between both the products.
• Involved in the implementation of Confidential uCMDB, Service Manager, BSM and Configuration manager in Confidential ’s VM data centre.
• Developed view using Confidential uCMDB to managed all the business as well as infrastructure related services and views in the organization
• Managed Configuration items and monitored their performance in our environment in the form of reports and views in Confidential Configuration manager.
• Developed Service view and dashboards based on infrastructure and network related data using BPPM dash board feature.
• Demoed all the features available in these products to the sales, marketing management teams
• Involved in monitoring both network infrastructure, web applications in Confidential environment using BPPM 8.1
• Involved in developing analytical and executive dashboards using Tableau 7.0
• Generated various reports using Microsoft SQL Server Reporting capabilities.

Environment: Confidential Proactive Performance Management 8.1, Remedy 7.6.03, Confidential uCMDB 9, TMART 7.1, Milkbone 3.0( Confidential Customized front end tool), MS SQL Server 2008, Windows 7 OS, Windows XP, VMware Venter ESXi 4.1, Tableau 7.0

Confidential

BI developer

Responsibilities:

• Involved in data loading from multiple data sources to staging environment by creating and running SSIS packages
• Created and executed SSIS packages for loading Confidential sales data from staging DB to Forecasting database(ETL design)
• Involved in creating facts and dimensions based on customer requirements.
• Implemented Delta load/Incremental load of data whenever there is new data coming from the customer.
• Implemented Full load of data based on whenever customer provided new data for loading tables
• Implemented error handling as part of SSIS packages to ensure proper loading of data into staging and from staging to forecasting database while loading erroneous data into Err tables.
• Involved in OLAP related operations using SSAS cubes.
• Involved in implementing write back functionality as part of SSAS for forecasting purposes of Confidential ’s sales data
• Extensively involved in data analysis and very actively involved in troubleshooting data related issues.
• Involved in case conversion of data in the databases as per customer requirements.
• Involved in cube designing using SSAS for OLAP related operations on sales data
• Created Routings packages using SSIS for loading Routings related data.
• Involved in documenting all the project related work - technical design, templates, data loads, SSIS packages sequence execution etc.

Environment: Microsoft Business Intelligence (MSBI) - SSIS, SSRS, SSAS, Microsoft Visual Studio 2008, Microsoft SQL server 2008

Confidential

BI developer

Responsibilities:

• Involved in the installation, implementation, testing and production of ITSM products
• Involved in the complete project life cycle implementation of Confidential APM for Windows
• Involved in the design of data load jobs - Delta, Incremental, Full data load jobs.
• Validated data coming from both numerous vendors before being fed into databases.
• Assessed system downtime and coordinated with numerous teams about the potential impact on systems whenever new BI rules are to be applied.
• Involved in the end-to-end implementation of Confidential Atrium Configuration Management Database(uCMDB) 9.02
• Involved in the end-to-end implementation of Confidential Remedy 7.6.1
• Worked on Confidential Reporter for creating reports on all the nodes, domains and services available in the organization.
• Worked on ITSM suite of applications - Interaction management, Incident management, problem management, Change management
• Worked on Service Catalog and Asset Manager Applications.
• Integrated all the above ITSM and ITIL products used in our environment.
• Developed SQL queries as part of fulfilling database related requirements using MS SQL server 2005
• Worked on VMware vsphere ESX 4.1 client to provision or clone machines in order to setup up dev, testing, staging and production environments.

Environment: Confidential Remedy 7.6, Milkbone 7.6.01,HP Operations Manager(OMW) 8.16, Atrium CMDB(uCMDB) 9.02, Configuration Manager 9.10,Microsoft SQL Server 2005, VMware Vsphere ESX 4.1, Confidential BPPM 7

Confidential

Quality Analyst

Responsibilities:

• Involved in writing test scripts using Microsoft visual C# for automating ITSM applications.
• Solely responsible for writing the automation code for all ITSM web services using Microsoft Visual C#.
• Automated and troubleshooted ITSM application test groups on autodb server.
• Regularly involved in installing new patches on Windows and Linux machines.
• Installed and upgraded the applications in windows and Linux server machines and logged installation defects.
• Performed DVD validations in UNIX on Solaris, AIX,HP-UX Itanium,HP-UX RISC, and windows server machines (involves mounting DVDs on remote lab machines and compare results with initial drop content present across network).
• Validated EPD content on Solaris, AIX, HP-UX Itanium, HP-UX RISC, and windows server machines.
• Prepared test data, logged and validated defects as part of functional testing of ITSM applications
• Solely responsible for performance and interop testing in GSS environment (GSS Environment is used to demonstrate to clients/customers).
• Extensively involved in verifying hot fixes for every patch release.
• Involved in sanity, confidence and full level coverage testing on both fresh install and upgrade boxes.
• Solely responsible for Section 508 testing required by Federal law.
• Solely responsible for web services testing both by automation and manually.
• Extensively involved in logging and verifying defects on Milk bone as part of Regression testing.
• Involved in preparing reports on the results based on various levels of testing.
• Involved in installing AR server, midtier and database servers to setup environment before loading data.
• Involved in loading data by running active scripts using SILK performer as part of performance testing.

Environment: Microsoft visual .NET 2003, AR System platform, ITSM Suite, Perforce CVS, XTestRunner, UNIX, Common Management Database System(CMDB), Oracle, WSDL,SOAP UI, XML, JRE 1.6, Unix, Windows XP.

Java Developer

Confidential, Albany, NY

Responsibilities:

• Developed Custom User interface using JSP, JSTL, CSS and HTML.
• Involved in fixing the defects related to the design and development of Session beans to implement business logic for Entry mats.
• Worked on Java Spring Framework and Struts for web development.
• Implemented Entry Mats unit using JSF framework.
• Involved in creating DB2 database backup from production environment and transfer it to development environment through FTP server.
• Implemented Hibernate in data access layer to access and update information in DB2 database.
• Involved in XML load of products data to address the current backlog.
• Implemented IBM Xerces tool for XML parsing.
• Involved in converting the DB2 database tables in the form of CSV files using reporting tools.
• Performed client side validations using JavaScript.
• Actively involved in customizing CSS, JSP, JavaScript, XML, XSTL files using web sphere commerce accelerator.
• Implemented Apache Ant to compile and deploy files.
• Developed JUnit test cases to for all the developed modules.

Technology: Websphere commerce toolkit v6.1, JSP, EJB, Spring, Hibernate, JSF, HTML, CSS, JavaScript, UML, IBM DB2 v8.1, Websphere Application Server Express v6IBM HTTP Server 6.0, IBM RAD 6.0.1.2 IDE, Websphere commerce Developer 6.0.1.2, Commerce Accelerator tool.