SUMMARY:

• 10+ years IT experience
• Strong Problem Preventing and Solving Skills
• Experience in Business Intelligence
• Expertise in SAP Business Objects 4.x/XI R3/R2/R 1/6.5/6.1/5.1
• Working knowledge in Tableau
• Experience in Web Technologies - Python, JavaScript, CSS, HTML
• Hands-on experience in OpenCart and E-Commerce Website Development
• Experience in WordPress website content management system
• Strong background in agile and waterfall Project Management methodologies
• Experience in E-Commerce Business and Management
• Very good understanding of D atawarehouse Concepts, ETL, Data Modeling, Reporting.
• Efficient in SQL Queries and Stored Procedures
• Established A nalytical Capabilities with G ood Problem Solving Skills.
• Excellent Communication, R esolution and D ocumentation Skills
• Proactive Team Player with Organizational and Project Management skills
• Capable of Working in a Team and/or Individually with minimum supervision
• Self -Motivated. and Result-Oriented
• Flexible and versatile to adapt to any new environment
• Strong desire to keep pace with Latest Technologies

TECHNICAL SKILLS:

Business Intelligence Tools: SAP Business Objects

E-Commerce Tool: OpenCart

Website CMS Tool: WordPress

Database(s): DB2, ORACLE, MS SQL Server, MySQL, MS Access

Web/Application servers: IIS, Apache Tomcat

Data Modeling: Star Schema, Snowflakes Modeling

Programming Languages: Python, JavaScript, HTML, CSS, SQL, T-SQL, PL/SQL

Office: MS Office, OpenOffice, LibreOffice, Ms Project

Platforms: Windows 95/98/2000/2003/2008 / NT/XP/7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Wallington, NJ

Technical Lead - Developer - Operations & Project Manager

Responsibilities:

• Planned, scheduled and executed various Web & IT Projects
• Gathered user/client requirements
• Wrote functional and technical specifications
• Led and guided the developers and the technical team
• Built and maintained full fledged e-commerce websites
• Worked in modification, improvement and maintenance of various Python projects.
• Developed and maintained front end user interfaces using HTML, CSS and JavaScript.
• Ran advertising campaigns in Google Adwords, Bing Ads, Facebook and other networks
• Promoted website with social media campaigns
• Worked on Search Engine Optimization (SEO)
• Built website blogs with WordPress content management system
• Found and made agreements with various product suppliers
• Managed customer orders and performed customer support
• Improved sales conversion rates through analysis with Google Analytics
• Implemented Secure Sockets Layer (SSL)
• Integrated various payment gateway systems
• Implemented security systems to avoid credit card fraud
• Sold products on online martketplaces such as Amazon, Ebay and Pricefalls
• Filed state sales tax returns

Confidential, Wallington, NJ

Business Intelligence Consultant / Lead

Responsibilities:

• Gathered user requirements and documented them if/when necessary
• Created SAP Business Objects Webi and Crystal reports
• Used SAP Business Objects Dashboard 4.X to create various dashboards
• Built universes for both canned and ad-hoc reports
• Worked with various BI tools to create reports as per user user requirements
• Installed BI tools on client and server computers
• Trained end users and developers on various BI tools
• Maintained servers and environments and provided support

Confidential, Hanover, NJ

Business Intelligence Lead

Responsibilities:

• Worked with business analyst on user requirements and wrote functional and technical requirements documents.
• Modified and enhanced existing universes, and implemented aggregate awareness
• Created complex Webi and Crystal reports according to user requirements
• Created corporate dashboards to display KPI reports.
• Validated report data through datamart and “Sales Page” CRM front end and back end database.
• Migrated reports, dashboards and universes from Development environment to QA, Staging and Production environments.
• Mapped Windows Active Directory groups and users to Business Objects and set up Single Sign On.
• Created and maintained users, groups, folders in accordance with the requested security model.
• Scheduled reports on daily, weekly and monthly basis through a database trigger file.
• Installed Business Objects XI 3.1 on multiple servers and client machines.
• Upgraded all environments from XI 3.1 SP 3 to SP 5.
• Maintained Development, QA, Staging and Production BO XI R3.1 environments.
• Created Disaster Recovery environment.
• Designed and developed Tableau report and dashboards
• Trained users and developers on Business Objects applications.
• Provided support to resolve users' daily problems with Business Objects.

Confidential, Indianapolis, IN

Business Intelligence Consultant

Responsibilities:

• Met with business users to understand their requirements.
• Created complex reporting and metrics universes with many alias tables, contexts and derived tables.
• Implemented row level security on universes through Security Management.
• Trained business users on Webi and Crystal reports.
• Designed and developed complex Webi reports with multiple data providers, sub-queries, calculation contexts and multiple layers of drill downs.
• Created Crystal reports with cross-tabs, prompts, drill-downs, summary and sub reports.
• Built interactive dashboards on Xcelsius using live office and query as a web service.
• Created metrics and analytics using Dashboard and Analytics tools.
• Created Corporate Dashboard from interactive Xcelsius dashboards, analytics and webi reports.
• Implemented user role security model on universes, reports and dashboards in accordance with the users’ requirements.

Confidential, Edison, NJ

Business Intelligence Consultant

Responsibilities:

• Installed Business Objects on multiple servers
• Set up, configured and maintained in Development, Staging and Production environments.
• Installed service packs and hot fixes, and also different fonts like Japanese and barcode fonts.
• Prepared SOPs (Standard Operating Procedure) for installation processes.
• Monitored performance, disk space, memory and CPU usage in all BO environments.
• Worked with migration teams to ensure that migration from BO 6.5 to XIR2 is done flawlessly.
• Mapped Windows Active Directory groups and users to Business Objects.
• Maintained users, groups, folders and created new ones in accordance with the security model.
• Met with business users to understand and gather requirements and created technical specification documents.
• Created complex universes with derived tables and advanced features like Aggregate Awareness and Security Management
• Created complex Webi and Deski reports with sub queries, multiple linked data providers, calculation contexts, multiple level drill downs and cascading prompts.
• Maintained and modified existing crystal reports and created new ones.
• Scheduled reports for different users either through report bursting or raw level security coming from universe or database.
• Created metrics, analytics and corporate dashboards using Performance Management tools.
• Created analytics and dashboards on Xcelsius using Live Office and Query as a Web Service.
• Conducted report testing and validation.
• Trained users on Business Objects applications
• Provided support to resolve all kinds of problems users encountered with Business Objects