SUMMARY:

• 27 + years of professional experience in Requirement gathering, Proof of Concepts, Software design and development in Business Intelligence:
• 8+ years of professional experience in Implementation, Release management, Designing, modeling and architecting data warehouses and business intelligence applications for fortune 1000 companies in Financial, Healthcare, Transportation and Insurance sectors using market leading ETL and OLAP tools.
• 10+ years of experience using Informatica Powercenter 1.7.2, 5.1, 8.1.1
• 9+ years of experience using MicroStrategy 8, 9 and Business Objects 5.0, 6.5, XIR 2
• 10+ years of professional experience in design, developing, editing and updating reports and analysis, Change request, Promotion request and variance analysis.
• Exceptional knowledge in database concepts, building stored procedures and data modeling for data warehouses.
• Excellent problem - solving skills with a strong technical background and good interpersonal skills.
• Marketing Analytics, Financial reports, Project Management in Retail, Banking and Healthcare etc.
• 2 years of professional experience in software design and development in MicroStrategy SDK Development:
• Microstrategy SDK programming for web and Portal integration
• MicroStrategy Web SDK and its customization.
• The Mobile SDK custom visualization and distributing Apple iPad or iPhone applications.
• Development of Visualization SDK APIs and new widgets.
• Import third-party widgets and develop Rich Internet Applications (RIAs)
• Created workflows such as write back applications and dashboards.
• Web Services, Intelligence Server, Office, Narrowcast Server
• Microstrategy Transactional Services
• Integration Manager baseline reports, Project compare, Project Merge before and after upgrade.
• AWS integration of MicroStrategy

TECHNICAL SKILLS:

Operating Systems:  Windows NT, Solaris, UNIX, LINUX, Windows 98/2000/XP, Windows 7, MS-DOS.

Data Modeling Tools:  Erwin 7.3, Oracle Designer 2000,Toad

Project Management Tools:  Microsoft Project-2000, Agile, Scrum, Waterfall, Jira, Service know

ETL Tools:  Informatica Administration, Powermart/ Powercenter 8.1.1/9 and Data junction 7.5. DataStage

RDBMS:  Oracle 9i, 10G, Sybase, Teradata, Netezza, Sql * Loader, Microsoft SQL Server, And MS Access, Toad, SQL Navigator, Embarcadero RSQL742, ARM,Hadoop,Mapreduce,Pig,Hive,NoSQL Analytics, Redshift

Web servers:  Tomcat 3.1, Apache-Jserv 1.3.6, GnuJsp 1.0 Java Webserver2.0 and IIS, AS400,Liferay

Version Control Tools:  CVS, Symphony, SourceForge, Subversion, InfoPath

Web Technologies:  ASP, JSP, Servlet, java, EJB, Vbscript, HTML, Dundas, 3D Graphics, XML, JavaScript, SQL, MTS and Dhtml.Axeda Cloud

OLAP Tools:  Portal Integration, Security, Single Sign On, LDAP, Business Object 6.5, XIR 2,Cognos 7.2,SAP BI/BW

PROFESSIONAL EXPERIENCE:

Confidential 

Sr. Business Intelligence Engineer

Responsibilities:

• Gather, analyze, and document functional and technical system requirements for enhancements to existing application modules and collect the appropriate level of detail required to and drive towards immediate technical results to solve client problems.
• Application design and system architecture for applications in the customer portfolio.
• Comply with applicable government standards. Application design specifications to evolving requirements and standards using MicroStrategy for a large federal client across a complex data landscape.
• Architect/re-Architect Data Schemas to allow for efficient MicroStrategy reports and dashboards
• Develop new applications, modules, functionality, and features using the MicroStrategy SDK.
• Develop enhancements and defect fixes to existing applications and modules.
• Support the performance optimization of data aggregation and real-time reporting
• Coordinate the development and migration of new application capabilities for deployment into the government enterprise modules.
• Act as a team member for the development of technical and functional requirements leveraging multiple artifacts and documentation throughout an iterative, agile development lifecycle.
• Leverage strong conceptual and technical knowledge of MicroStrategy 10.2 architecture, software components, design, development, and integration best practices to develop impactful BI solutions.
• Provide conceptual and technical knowledge thought leadership of MicroStrategy 10.2 architecture,
• Software components, design, development and integration best practices across development work stream.
• Led team of developers in the delivery of technical systems and components Ensured on-time, quality release of systems and components provided technical direction to development teams
• Provided IP management leadership and oversight of the software development process Oversaw design of applications from functional and technical specifications Recommended and assisted
• Development of standards and project frameworks and provided guidance to vendors Worked with Business to ensure smooth translation of requirements into applications Worked closely with business stakeholders to determine product prototypes
• Developed and delivered efficient and cost-effective technical solutions to meet customer business requirements Managed and evaluated system enhancements and resolved system issues
• Provided business analysis support and technical support and guidance to customers Provided quotes for estimated development time and costs for clients Liaised with line management on business developments
• Maintained software on Windows, Linux server platforms
• Collaborate with all stakeholders to enable continuous improvement of processes, controls and systems
• AWS servers install on Dev Ops scripts and MicroStrategy installation
• Configure SSL integration.
• Create Data base instances of different Databases including Hadoop and Redshift
• Deploy Web Plugins and trouble shoot Web server and Intelligence server.
• Migrations and creation of metrics and attributes.
• VLDB properties and performance tuning.
• Upgrade and patch the servers as needed.
• New driver installations on servers.
• Service know request and management and assignment of tickets and completion of Tickets
• Create Jira stories and follow on a day to day bases and follow up on subtask

Confidential

Sr. Technology Lead

• Demonstrated ability to manage relationships and project teams.
• Control project variances and change and Worked with various Streams and Program Manager when escalation is appropriate, Managed technical and business risk
• Understand matrix and project organizations to work effectively to resolve project issues.
• Demonstrated ability to work collaboratively with, lead and motivate other employees in a team environment to meet aggressive goals and pre-defined timelines.
• Demonstrated ability to integrate complex, diverse project activities into a total system solution where projects may consist of: new technologies, highly specialized technologies, aggressive timetables, multiple concurrent tasks, tight budgets, and span multiple areas and geographies.
• Provided input from the teams that helps improve the roadmap, marketing and general approach.
• Follow through on deliverables to make sure everyone understands what is expected and timeline Identify, utilize and manage key resources required to meet project objectives.
• Developed data logic, data models and interfaces for QlikView dashboards.
• Developed QlikView user interface knowledge: charts, graphs, tables, expressions, properties, tabs, layouts
• QlikView scripting, data analysis and QlikView data models
• Developed QVDs work with QlikView to provide a scalable, reusable, metadata-driven data layer
• Developed front end applications using QlikView
• Developed Processes to Extract, transform and loaded data from multiple data sources into the QlikView application
• Designed, build, test and debug QlikView solutions based upon specified requirements
• Data acquisition Utilizing source control tools
• Tuned data loads and QlikView application for efficient performance.

Confidential  

Sr. MicroStrategy Solution Architect

• Installed and configured MicroStrategy 9.4.1 software Upgrade on Windows, Unix and Linux Servers
• Lead and guided the project teams to ensure DEV, QA, UAT environments are stable to maximize availability for development and testing.
• Implemented configuration and process changes to improve the reliability, scalability, and supportability of the MicroStrategy environment.
• Educated network/system monitoring teams to ensure that adequate environment health checks are implemented to identify possible issues before they impact users.
• Partnership and accountability with other IT departments like Portal and LDAP teams for MicroStrategy environment integration with their application.
• Incident management to ensure timely resolution of production issues (on-call rotation) and root cause analysis.
• Maintained scripts and documentation related to software licensing, ensuring that the environment remains compliant with licensing agreements.
• Applying patches and hot fixes in a timely manner for a robust and scalable MicroStrategy
• Infrastructure.
• Minor and major release upgrades for all MicroStrategy products (IS, Narrowcast, Web Server, Mobile Server)
• Created MicroStrategy projects in various environments to facilitate development and testing.
• Maintained project Integrity and object level security consistent with project requirements.
• Scan MD, Integrity manager reports, Project merge and Health center to monitor health and maintenance of servers.
• Change management process to migrate MicroStrategy projects and objects between QA, UAT, and Production environments by creating and applying packages and undo packages for roll back procedures.

Confidential

Sr. Cloud Solution Architect

Responsibilities:

• Install configure MicroStrategy environment
• Client interviews to discuss and understand to deliver the requires reports
• Convert the business rules into meaningful reports for analysis
• Projections and forecasting reports
• Sales and revenue reports with MicroStrategy Ragged Hierarchy
• Create Reports and Dashboard and according to the business KPI’s

Confidential

Sr. MicroStrategy Consultant

• Created Instrumentality Dashboard to see the incremental sales and materialized sales of online as well as in store sales with respect to coupons.
• Comparative analysis to see the top 10 sales and campaign format and bottom 10 campaign formats to target the customers and to forecast future sales.
• Data validation after the dashboard produced the data and the earlier user reports to show the dashboards are reporting accurately by creating test cases.
• Automating the user reports for the client so they have data available to do their analysis on a timely and efficient manner. 

Confidential 

BI-Administrator and Designer

Technologies: MicroStrategy, Netezza, Teradata, Linux, Control M, Clear Quest, JVM

• Participated in the complete implementation, process, and strategies for the
• Development of cores solutions and guiding principles and SDK.
• Designed and developed Business Intelligence report user interfaces (Dashboards,
• Scorecards, Report Services Documents, Grids and Graphs) working closely with the
• Business Intelligence Architect to ensure designed BI solutions meet end user Requirements
• Effectively translated requirements into a solid technical design and solution
• Demonstrated expert knowledge in multiple technical and business areas as well as
• Performing a larger leadership role in the organization.
• Developed installed, and maintained complex business applications using structured
• Development methodology according to corporate standards.
• Demonstrated Expert level communication, presentation, organizational andInterpersonal skills
• Demonstrated Expert understanding of business application or product being Developed
• Demonstrated Expert design/coding skills, testing methodologies and techniques Project planning design, build, test, and data conversion/migration as well as Server maintenance.
• Migrations (Dev. QA and Prod), Setting up new projects, Duplication, War FileDeployments, Creating Cases with MicroStrategy to resolve issues, change and createData base Instances.
• Create Intelligent Cubes Schedules both Event Bases and Time bases. Control M Jobs to
• Automate intelligent cube refresh for Portal and web reports.
• Resolve Migration dependencies and Portal Web issues for intelligent cubes
• Restarts monitor and maintain health of Linux JVM and I Servers.
• Upgrades of MicroStrategy Versions.

Confidential 

Sr. Systems Analyst 

Technologies: Informatica 8 /9, Sybase, Teradata, Business Objects XIR 2, Quality Center, HP OpenView UNIX

• Detail design Documents, Resource allotments, Concept to design
• Performance Tuning, Implementation Plans for Production and ITGs, Help Tickets
• Promotion request for DEV, Test QA and Prod, Prod Installs, Post implementation follow-up
• Documentation for user sign offs through Symphony, Source Forge, Quality center, HP Open view
• Create mappings, Load Data in EDW, Change Data Capture, History, Archiving
• Manage workflows, Informatica repositories; Performance Tuning, UNIX administration of Informatics
• Manage the health of repositories, create folders, Production installs
• Migration of mappings, Sessions, Workflows
• Gap analysis, New development, SRS, BRS, DDS and offshore projects lead
• Teradata Acquisition, Multiload, Fast load, BTEQ scripts to move data for EDW
• Business Object Reports for OTSM measurement and customer facing report and Adhoc reporting
• Informatics support: On call support to monitor workflows and Mappings for Adhoc Reporting and Resolutions
• Help tickets, Extracts, Informatica server maintenance High Availability and Grid environment