Data Analysis and Data Visualization / Story Telling • Developed and maintained decision support dashboards with data cubes to monitor key performance indicators (KPI). (KPIs) for senior management and different target audiences. • Produced several outputs with data needs and reports for accreditation and supported in several research on 911 and properties data. • Analyzed large datasets using SQL and SSAS, identifying key trends and patterns to inform business strategy. • Collaborated with cross-functional teams to deliver data-driven recommendations. • Conducted detailed analysis of business processes, identifying inefficiencies and recommending optimization strategies that reduced costs. • Delivered presentations to stakeholders, translating complex data insights into actionable business strategies.Data Integration and mining • Automated data pipelines, resulting huge improvement in data reporting accuracy and timeliness. • Automated, stored and maintained years of pre-calculated data extracted from multiple sources • Completely integrated with GIS systems • Created and maintained a comprehensive data governance program that ensured compliance with industry regulations and improved data quality by 30%Application development and Support • Developed business application using Visual Studio.net (C#) with SQL Server to cover all the business needs related to (FBC) Fire Benefit Charge business processes. • Provided support to more than 5 agencies for FBC application and data change management processDBA and SQL Developmemt • Developed backend structure of the FBC application with all processes and procedures • Managed / Maintained multiple local and cloud DB Servers • Made sure data availability and disaster recover ability • Backup strategy implementation

Managing 60 production, Disaster recovery site and test environment servers with SQL 2005, 2008 R2, 2012 and 2014 versions.  • Established and maintained policies, standard operating procedures, and associated documentation for user interaction with the database environment. • Indexes optimization enhanced 60% of performance of the SSRS reports • Implemented backup strategies • Derived performance through optimized memory management of the servers • SQL Server performance monitoring • Developed and Implemented RMS, GP, ADP integration using GP Integration manager, SSIS and SQL scripts. Research and Development • Automated cashier user creation process based on HR (ADP application) hire through SQL scripts and SSIS. • Developed SQL data-mart that provides the ability to loop through all the database servers. • Automated SSRS reports deployment • Automated / Configured Email in all SQL DB servers for events / triggers / subscribed reports • Developed Analytical cubes on all major applications data • Upgraded existing SharePoint 2010 sites structure to version 2013 successfully. • Installed/customized MS CRM for businesses verticals (Foundation, Donor services and Workforce development). • All types of reports converted to SSRS. • Implemented GP out of the box analytical cubes solution and prepared several reports. • Digital dashboards highlighting KPIs.  Business Applications Administration & Support  • Administering and Managing MS Great Plains. • Administering existing purchased analytical cubes solution RAMP  • Administering SharePoint 2010. Trained and prepared SharePoint 2010 site admins group. • Providing support on many business applications including RMS, Black-baud Raiser-Edge, ADP.

Analysis and Design • Analyzed business tasks and created plans. • Developed business systems and/or procedures required by the business plans • Developed ERD, DFD and perform technical analysis, querying, updated statements • Developed and updated stored procedures and views • Analyzed and Fine Tuned the existing SQL databases • Analyzed the needs and helped in selection of business application manpower and scheduling system called Tele-Staff. • Implemented applications: Financial systems, Microsoft Dynamics GP and other technical solutions.SQL Development • Data change management and automation on several projects • Helped management in research and brainstorming meetings on data and finding information quickly at the spot. This research was regularly done to make sure the percentage of fire charges for citizens were correct and proved with evidence. Developed Business Intelligent (BI) and decision support Reports • Upgraded MS Access based application by moving the data structure to SQL Server. Improved the table structure and added several tables to accommodate more departments and information. Made it a multi-user secured application. This covers the complete citizen appeal process, customer services and change management with citizen’s applications for different approvals like burn permits. • Provided an efficient reporting method using SQL stored procedures by bringing the business logic out of the reports and made several reports • Improved the performance of the reports by adding indexes and fine-tuned the database, tables and column properties.Business Applications Support- Provided support on all business applications including Fire RMS, FLP (First Look PRO) and CARES.

Responsibilities and Achievements:• Analyze existing data structure, document and fix the problems• Produce MS CRM requirement analysis documentation and present a plan for next phase implementations• Build operations, Financial, Production, Inventory and Sales key performance indicators (KPI) reports with SSRS.• Design and improve/fix existing Corporate Conceptual Analysis Services Cubes• Document and develop complex SQL Stored procedures, Triggers and Queries for various purposes including improving the performance and fix the integration of systems (GP, Retail Management and Time and attendance system).• Analyze and design the indexes to improve the performance of reports. Achieved 70% improvement)• Build decision support reports for management based on data from Microsoft Retail Management System, Great Plains and reports on combination of both the systems.

Supported the BPO (Business Process Outsourcing) and ITO (IT Outsourcing) concepts With 4 reporting departments (IT, Contact Center, Training and Administrations)IT• Ensured the short term and long term IT plans aligned with the goals of company and increase in sales.• Worked on IT developmental programs to help the organization growth and to make sure the entire company is equipped with latest tools that can help them perform better.• Lead planning, organizing, controlling and management of all the IT employees, operations as well as quality and all the issues and projects pertaining to information technology• Ensure develop and build custom software solutions and deliver the product in time Call Center• Set and meet performance targets of speed, quality and efficiency• Track and measure team productivity and quality results for staffing forecasts• Ensure appropriate staffing, training, development, and performance of a service unit focused whilst monitoring the effective use of time and resources to ensure operating at maximum efficiency• Forecast and analyze data against budget figures on a weekly/monthly basisTraining• Established Independent entity, delivering customized business courses• Ensured quality training provided to Call center and customersAdministration• Ensure personnel mentoring and provide critical reports to highlight issues in running projects• Build report center to deliver internal and project reports to all customers in a timely manner

Managed functions within a company dealing with the • Product Planning, Marketing, Project Management, Training and Implementations for CRM, SQL Server & SharePoint.• Presales Technical consultancy

Business Analysis• Analyzed several business requirements and supplied solutions for Humansoft as well as customers. Management• Managed assigned “Support Zones” by maintaining balanced workloads and provided status of assignments.• Documented and maintained policies and procedures related to group tasks and responsibilities.• Prepared project plans, including objectives, costs, benefits and timelines.Customer Relationship• Provided the quality of services in solution implementation phases. • Provided Monthly/weekly statuses reports to the customers for projects and support instancesLeadership• Selected quality people for quality services. Trained them to handle the bigger and difficult tasks. Prepared leaders and good resources for the organization.Presentations• Provided training, Presented in customer meetings and also in many events and seminars