EXPERIENCE SUMMARY:

• 10+ years of experience in planning, designing, developing & implementing Data warehousing and Business Intelligence solutions.
• MicroStrategy Certified Project Designer (9.4.1)
• ITIL Certified (Foundation)
• Competent in installing MicroStrategy, SQL Server, SSRS & SSIS
• Hands - on experience in all tools related to the lifecycle of a data warehousing solution, such as data modeling, database, ETL, reporting and visualization tools
• Good understanding of dimensional modeling.
• Requirement Analysis, Design, Development, Migration, Implementation & Support/Application Maintenance
• Worked on Netezza, Teradata, SQL Server as data sources for reports
• Worked on change management tools like Maximo, Remedy and Jira
• Hands on experience in Version One for Agile Project Management and Apache SubVersion as versioning tool
• Led the development of a new analytics asset from concept through to a production ready data warehouse. This asset is now part of Accenture IP and is sold to various Financial and Insurance domain clients.
• History of success in providing responsive and innovative solutions, along with new functionality in enterprise-wide specialized systems, through development of programming codes and software modifications. software engineering and development of robust and scalable BI Solutions
• Seasoned software expert acknowledged for talents in precisely conceptualizing and directing the development and continuous refinement of advanced technology solutions to meet clients' needs
• Record of success in analyzing user system and application needs, determining and evaluating potential solutions, developing system specifications and requirements, and designing solutions to meet business requirements
• Adept at providing post production support, software development life cycle, project management, business process understanding & re-engineering, and procedure development.

TECHNICAL SKILLS:

• MicroStrategy 9.3.1/9.4.1/9.5/10.4
• Google Data Studio
• SAP Business Objects XI R2 ( Crystal Reports )
• SQL Server Integration Services 2008/2012
• SQL Server Reporting Services 2008/2012
• Confidential Quality Centre
• Confidential QuickTest Professional
• CampusVue
• Version One
• T: SQL
• Python (Basic Proficiency)
• R (Basic Proficiency)
• SQL Server 2008, 2012
• Netezza
• Teradata
• Windows
• Linux
• SVN
• SourceSafe
• Waterfall
• Iterative
• Agile
• JIRA
• Maximo
• Remedy

CORE COMPETENCIES:

• Enterprise Application Development / Architecture
• Technology Operations & Project Leadership
• Product Ownership / Automation Test Engineering
• Software Development Life Cycle Management
• Systems Analysis & Business Intelligence
• Database Analysis and Development
• Productivity Enhancements & Cost Savings
• Software Engineering & Coding Best Practices

PROFESSIONAL EXPERIENCE:

Architect & Test Lead

Confidential, Charlotte

Responsibilities:

• Responsible for developing & testing of reports in MicroStrategy; providing in-depth comparisons of the reports in old platform vs. new platform and obtaining sign off from stake holders for the Go-Live of new reporting tool.
• Continued to manage multiple projects, including functional testing of implementations, ensuring compliance with all cost and scope specifications
• Researched and proposed cost effective technical solutions to address business challenges, such as process improvements and governance standards; additionally, managed requirements engineering and business analysis
• Focused on business and systems analysis, emphasis on system implementation in accordance with organizational goal, and communicating/building consensus over critical application/system developments and deployments

Solution Environment : MicroStrategy, Teradata, Actuate, Netezza, Python, Sandra, Informatica

Architect / Team Lead

Confidential, Charlotte

Responsibilities:

• Developed back end business functionalities and managed end-to-end smoke testing of system
• Designed and implemented a scalable and flexible ETL framework, which included audit, balance & control.
• Oversaw and managed application development, system migration, testing and second level technical support
• Managed strategic development of manual and automated testing functionalities for projects and other activities such as software deployment, software upgrade, customer integration, etc.
• Perform all responsibilities of quality management activities such as test strategy documentation, project management, conducting conference calls (meetings) for project progress, acquiring status reports, maximum effort utilization, creating training plans, taking trainings, client interaction and managing the testing team
• Evaluation of the scope & timeline, effort estimation and planning the upcoming releases.
• Planned and started execution of project to use MicroStrategy as the front end for QMT
• Overseeing end to end project management from conceptualization and visualization, technology mapping, budgeting, resource & task scheduling and final execution of projects.
• Responsible for Data Modelling, Database Data warehouse design, ETL & MSTR setup.
• Presenting the BI solution to prospective clients during client visits.

Solution Environment : MicroStrategy, SQL Server 2012, IIS Web Server, .Net, SSIS

Senior Software Development Engineer

Confidential

Responsibilities:

• Served as an onsite/offsite team lead and managed in depth analysis & study of business process/systems, including system feasibility, impact analysis, change management, release management and requirement specification documentation. Implemented solutions, gathered requirements, documented/architected solutions, and managed system transitions.
• Lead a team of developers, specializing in BI / Reporting across CampusVue products. Apart from customization, the team also works on hotfixes and releases of the CampusVue products. Handled projects across Americas (USA, Brazil) and EMEA (UK, Netherlands, Kenya, Botswana, UAE, Saudi Arabia, Kuwait and Lebanon). Co-ordinated offshore teams while stationed onsite in Nairobi, Kenya.
• Creation of reports and custom solutions for clients integrating their systems with our ERP and CRM solutions
• Requirement gathering, design and deployment of reports in client environment
• Data migration from legacy systems to newly deployed solutions, testing and handover to support teams.
• Analyzing Reporting requirements and creating custom reports.
• Analysis of data in Client systems and optimizing the database performance.
• Creation of Report Data models for new clients.
• Creation of POCs for Integration of Confidential products with leading BI tools (MicroStrategy and eThority) based on prospective client requirements.
• Managing the team activities and ensuring deliverables are on target.

Solution Environment : SQL Server 2008, SSIS, SSRS, BIDS, .NET, VSS, Excel, Crystal Reports, CampusVue

Software Developer - BI

Confidential, Fort Lauderdale

Responsibilities:

• Create a new data warehouse to take the server load off of the transactional system
• Reverse engineer all existing Delphi reports and document findings
• Design data model to satisfy all existing and future reporting requirements
• Convert data model design to physical schema
• Create a report model in SSRS
• Create reports using Report Builder and SSRS
• Train users on new reporting platform
• Validate newly built reports with legacy reports
• Converted 200+ Delphi reports to SSRS & MicroStrategy in two projects.
• SQL Query optimization performed for more than 200+ reports.
• Training users in ad-hoc reporting and data visualization.
• Analyzing existing reports. Converting SQL-in- file to Stored Procedures.
• Training clients on Report Manager usage - to view and run reports.
• Identifying costly queries and rewriting queries.
• Building a departmental Data Model for ad-hoc queries.
• Daily interaction with clients to collect requirements and troubleshoot issues.
• Design of BO Universe and creation / migration of reports.

Solution Environment : SQL Server 2008, SSIS, SSRS, BIDS, .NET, VSS, Excel, Delphi

Technical Solutions Rep

Confidential

Responsibilities:

• Interaction with clients to gather requirements.
• Creation of Reports based on end user requirements (Ad-hoc queries)
• Creating stored procedures using T-SQL in SQL Server 2008 and utilizing the features of Business Intelligence Development Studio to create permanent reports.
• Modifying existing reports/queries as per new business requirements.

Software Engineer

Confidential

Responsibilities:

• Analyze the requirements documents
• Translate requirements into effective code.

Solution Environment : Java, Eclipse IDE, SQL Server 2008