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 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 SS integration.
• Create Data base instances of different Databases including Hadoop and Redshift
• 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

Responsibilities:

• 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

Responsibilities:

• 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
• 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

Responsibilities:

• 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 Confidential 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.
• Gather requirement to create each business case to cover data validation to show changes as in sublease project with respect to different criteria’s.
• Test cases and user acceptance with respect to different criteria of the project for example: Returns, Salvaged cars, Causality and other various factors
• Data validation and source to Confidential mapping of data.
• The successful POC leading into a full project implementation.

Confidential

Sr. Infrastructure Administrator

Responsibilities:

• Migrations, Metadata Management, User Management, and Project move, Project Merge, Package Creation.
• Object Migrations, Documentation, SharePoint Repositories, Migration of Reports and Dashboard
• SDK look and feel configurations.
• User Profiles, Created Projects, DB Instances, Duplicate Projects, Monitoring the Health of I-Servers.
• Server maintenance. MicroStrategy War files, Patched, Create Cases and Deployment, Upgrades, Health Center. Enterprise Manager
• Intelligent Cube Publish and Monitoring, Weblogic
• Mobile server configurations to support mobile reports.

Confidential

Sr. Systems Engineer

Responsibilities:

• Enterprise Manager Reports
• Health center reports and monitoring
• Clean up Environment with objects deletion, clean-up of Logical
• Tables, Schema update, Migrations, Documentation SharePoint
• User Groups, User Profiles, Projects creations, DB Instances
• Duplicate Projects Project merge
• Monitoring the Health of I-Servers
• Server maintenance and patches and Deployment

Confidential

BI-Administrator and Designer

Responsibilities:

• Participated in the complete implementation, process, and strategies for the
• Development of cores solutions and guiding principles and SDK.
• 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 and Interpersonal 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.
• 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 / Informatica Admin

Responsibilities:

• 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
• Confidential 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

Confidential

Sr. Software Developer

Responsibilities:

• Change Request, Create, Update, Edit, Metrics, Hierarchy, Prompts,
• Teradata, SQL queries for remedy ticket management in EDW.
• Unit testing for performance analysis, Variance Analysis, ECAT, Performance tuning
• Create Report information pages, Sample reports, Create and Update
• Promotion request in DEV, TEST, QA, PROD environments,
• Narrowcast server, Distribution of reports, scheduling
• Create project plan and implementation
• Analysis of Source data and data validation
• Source to Confidential design document
• New product registration through EU and FDA regulations
• ETL Design, developed mappings, workflows and schedule to load EDW
• Unix shell scripts for event watch
• Log in defects in and manage review, Issue, Resolution trackers

Confidential

Project Lead/ Solution Architect

Responsibilities:

• Analysis of Source data, designing of data mart, creating Transformation Specs
• Design logic for ETL Process
• Designing Cognos reports and cubes
• Project Plan and work packets to offshore team

Confidential

Project Lead/Administrator

Responsibilities:

• Manage Administrator functions like Created Folders, Users and Privileges
• Manage Repository like Creating, Copying, Backup and Restoring.
• Performance Tuning with respect to CPU and Memory usage
• Develop and configure sources, targets, Mapplets and Mapping transformation.
• Design import procedures in transformation
• Manage Active and Passive Transformation.
• Developed programs to create sources to targets mapping
• Developed programs to run the sessions of Informatica
• Integrating MicroStrategy in Mozart
• Created Facts, Attributes, Templates, Cubes, Filters and Metrics
• Develop Reports according to the new requirements

Confidential

Solution Architect Marketing Analytics

Responsibilities:

• Design Mapplets and user defined external procedure and advance external procedure transformations.
• Designed and architect the daily load process.
• Developed programs to Generate control scripts
• Developed programs for identifying Fast load scripts, Multiload scripts and to load data in respective tables

Confidential

Sr. Process Engineer

Responsibilities:

• EParadigm collects data from Insurance companies and hospitals in the form of flat files
• ETL design to store and manipulated data in a star schema to produce various reports that are hosted on the web for Hospitals and insurance companies.
• Created sources, targets, Mapplets and Mapping transformation-using Informatica
• Developed programs to run the sessions of Informatica
• Eclipse data management and load into tables
• Quarterly Variance Reports Using MicroStrategy Desktop and web