PROFESSIONAL SUMMARY:

• Being extremely neat, reliable, greatly motivated, able to deal with complicated projects, creating high quality and timely working results.
• Result - oriented technical professional focused on analyzing complex business problems, designing appropriate solutions to business needs and managing business application development and rollout.
• Worked in IT Strategy Consulting and Services Industry for more than 17 years
• Strong collaborative style coupled with “hands-on” IT experience.
• Excellent communication skills and ability to easily adapt to environmental and organizational change, take direction, think fast, and execute with precision.
• Industry expertise in both communications, financial services, and retail as well as experience with start-up businesses. Experienced with Confidential .
• Experience working on an Agile/SCRUM team Technical Skill
• Experience Develop, code, test, and deliver data warehouse solutions

TECHNICAL SUMMARY:

Environment: Windows 3.x/95/98/ME/NT/2000/XP/Vista/2008

Reporting Tools: Microsoft® SQL Server™ 2000, 2005, 2008, 2010, 2012 Reporting Services, Share Point 2010, MicroStrategy 9, Cognos 8.4, 10.2.2, Crystal Reports 11.5, 10.0/9.0/8.5/8.0/7.0 Crystal Analysis Pro, Crystal Enterprise 10.0/8.0, Tableau software, SAP Business Object

Software: Visual Studio (97/6.0/.Net/.Net 2003, 2005/2008), Source Safe, MS Office 95 - 2003, 2007, Crystal Reports (4 years)

RDBMS: SQL Server (6.5/7/2000/2005/2008/2008 R2/2012), Oracle (7.3.2, 8.1.7, 10.1.0)

Databases: Lotus Note 6.5/8.5, MS Access 2003/2000/97

Technologies: Web Services, SOAP, COM, DCOM, ADO, RDO, DAO, OLE DB, ODBC, ActiveX, Win32 API

Methodologies: Web Services and Service Oriented Architecture (SOA), Object Oriented Software Construction (Analysis, Design, Programming), Design Patterns, Use Cases

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Business Intelligence Team Lead

Responsibilities:

• Power BI responsible for design, build and deployment of Power BI Solution and analytical reports from diverse data sources. Experienced with DAX
• Regularly interact with the users ranging from the end user to directors to understand, document and communicate their needs, perform requirements analysis, develop and deliver Data Models, Business Intelligence and data transformation solutions. Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Designed, developed, implemented reports using SSRS, SSIS and SSAS.
• Designed and developed a database to house data from various data sources for all reporting needs with T-SQL proficiency. Optimized SQL stored procedures for performance improvement. Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Create and analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Involved in re-designing or customizing the existing views and stored procedures to suit the reporting needs. Created different type of reports including: cross-tab, conditional, drill-down, top N, summary, form, OLAP and Sub reports.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Constructed data decomposition diagrams, provide data flow diagrams and document the process.
• Identified and documented data quality issues and data patterns.

Confidential, Conyers, Ga

Business Intelligence Team Lead

Responsibilities:

• Migrate, organize and categorize large volumes of data for a highly Implementation project.
• Examining material data sets and drawing conclusions about the information they contain, with the aid of MS Access, MS Excel, AS400, and SQL Server.
• Conducts data cleaning and transformation of data sets to help better understand data and implement result .
• Establish customer product demand and develop productivity improvement proposals from data analysis results.
• Using Legacy System AS400 as a research tool to develop reports based on clients five year sales data.
• Set up Product Attributes data and files for Oracle Configurator using data files created .
• Establish product standards for optimization and rationalizing product cost through data analysis result .
• Conducting Analysis on Large Data sets to prepare for Oracle Implementation.
• Understanding Process Flows and providing analytical solutions to the project.
• Structuring clients Product Architecture and definition which includes formulating Bill of Materials and its attributes
• Enterprise Data Governance Policy and Standards, and Business Information Office and Data Management leadership and understand and explain and apply the Data Management Lifecycle
• Managed deadlines on a daily basis to ensure completion of special projects
• Delivered business oriented reports with subscriptions in Power BI services. Experienced with DAX
• Building Model and Developed number of business oriented reports utilizing Power BI.

Confidential, Duluth, GA

SQL Database Engineer

Responsibilities:

• Designed, developed, implemented reports using SSRS, SSIS and SSAS.
• Used SAS / SPSS to analyze survey data on differ client.
• Experienced with DAX
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Analyzed survey data o UI dashboard, to ensure the survey programming were correctly implemented and anomalies within the data were investigated and resolved in a timely manner
• Designed and developed a database to house data from various data sources for all reporting needs with T-SQL proficiency.
• Optimized SQL stored procedures for performance improvement. Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Create and analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Involved in re-designing or customizing the existing views and stored procedures to suit the reporting needs. Created different type of reports including: cross-tab, conditional, drill-down, top N, summary, form, OLAP and Sub reports.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Constructed data decomposition diagrams, provide data flow diagrams and document the process.
• Identified and documented data quality issues and data patterns.

Confidential, Atlanta, GA

Senior Business Intelligence Developer

Responsibilities:

• Worked primarily on ETL projects as a Data Warehouse Developer Performed data analysis (which included data modeling, profiling, cleansing, and mapping); developing code in T-SQL for new business logic; and developing SSIS packages. Also involved in report development using SSRS and Crystal Reports and Tableau for data visualization.
• Performed extensive data scrubbing and cleansing to develop new packages and make the data more accurate and consistent.
• Identified data quality issues, including duplicates, mismatches in the columns, inaccurate information, and lack of completeness while implementing a new field with new business logic. Utilized SSIS Data Profiler to check the values and data types.
• Involved in creating the data models and also helped with the conceptual modeling.
• Write T - SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Used agile methodology for the development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Have created star and snowflake schemas in SSAS.
• Developed calculated members and MDX expressions for specific OLAP reporting requirements.
• Optimized and Aggregated cubes with 40% performance for better performance. Processed cube to perform incremental updates.
• Configured TFS 2010 Environment along with Share point Services, Reporting Services
• Involved in Customization of Work Items, Transition Confidential in TFS.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs. Generate KPI for customer satisfaction survey results.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics
• In client application, have issued DAX queries in Power View.
• Made use of DAX to access data directly from a tabular database, by creating them in other client applications.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Worked on deploying and scheduling Reports using SSRS as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning
• Participated in business analysis activities to gather required reporting and dashboard requirement.
• Designed, implemented, and supported a platform providing ad-hoc access to large datasets.
• Used data mining, model building, other analytical techniques to develop and maintain customer segmentation and predictive models to drive the business.
• Translated business requirements into specification that will be used to implement required reports and dashboards, created from potentially multiple data source.
• Designed and implemented BI reporting applications.
• Debugged, and troubleshot BI solutions.
• Provided and assistance to users for adhoc analysis/adhoc request/ adhoc report.

Tableau Developer / Tableau Administrator

Confidential

Responsibilities:

• Worked on full development life cycle within Tableau reporting and developing business requirements, building reports and deploying to test/QA and production environments. This included working with Business Analyst and Business users to understand user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated dashboards with quick filters, parameters and sets to handle views more efficiently.
• Published workbooks by creating user filters so that only appropriate teams can view it.
• Embedded Tableau views in to MS SharePoint.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used MS Excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated Tableau dashboards for sales with forecast and lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.
• Worked on full development life cycle within Cognos reporting framework gathering and developing business requirements, building reports and deploying to test/QA and production environments.
• This included design of Cognos Framework Metadata models to enable report development.
• Worked with Cognos product suite (Report Studio, Analysis Studio, Event Studio, TM1, etc., 10.2).
• Participated in the design and development of procedures in support of standard reporting activities. Maintained standard set of reports, templates, and queries from which customized reporting can be developed. Documented report and query development activities. Worked with functional areas to obtain the required and needed information flows from the appropriate data sources to meet the needs of the business. Designed ad-hoc queries and reports in Cognos 10 Business Insight and Business Insight Advanced Studios.
• Developed and wrote necessary database reporting statements, rules and referential integrity procedures to ensure proper operation. Determined and utilized the most suitable reporting tool from available tools to meet the reporting needs of end users.
• Liaised with business line managers, senior management, and other key business partners to develop management reports that support and track business objectives maintaining consistency across functional areas. Worked with business line managers in development of models to facilitate tactical and strategic planning activities. Provided reporting assistance, as needed to business line managers to support the analysis of monthly performance (i.e. identifying gaps and trends impacting profitability, product management, etc.).
• Worked with the Information and Systems Manager to prioritize business unit reporting and technology requests to ensure proper corporate resource allocation.
• Worked with the Information and Systems Manager on developing long-range information solutions.
• Designed, developed, implemented, and supported Qlikview dashboards. Integrated data sources and databases with Qlikview, and designed and developed data models and backend queries for presenting data.
• Created data queries and reports using Well View, Qlikview. Created custom queries/reports designed for quality verification and information sharing.
• Used SQL, PowerPoint, Excel and InfoView daily to generate various performance reports for analysis.
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data cleanup.
• Set up wells and jobs within Well View; monitor and perform QA/QC of daily Well View data for anomalies.

Confidential, Atlanta, GA

Senior Business Intelligence Developer

Responsibilities:

• Played a key role in developing, implementing and demonstrating the successful project use SSRS, SSAS Designed, developed and implemented reports. Involved in re-designing or customizing the existing views and stored procedures to suit the reporting needs. Created different type of reports including: cross-tab, conditional, drill-down, top N, summary, form, OLAP and Sub reports. Created reports including formatting options such as charting, mapping, grouping, sorting, alerting, field highlighting, drill-down and parameter prompts Involved in re-designing or customizing the existing views to suit the reporting needs. Created parameterized MS chart and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports.
• Optimized SQL stored procedures for performance improvement. Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures. Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems. Involved in manual testing, Functional testing, Regression testing and Integration testing etc. Performed a bridge (Point of Contact) role between the Testing Team and the Business Team by conducting the root cause analysis of the defects logged by test team. Analyzed, designed/developed and Compliance and Ethics Report.
• Analysis Services (SSAS): • Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow moving dimensions etc and created various user roles. • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. • Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems. • Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes. • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports. • Expert in calculating measures and dimension members using Multi- dimensional expression (MDX), mathematical formulas, and user-defined
• Environment: SSIS, SSRS, SSAS, SharePoint, SQL/ T-SQL Developer, MDX, DAX

Confidential, Atlanta, GA

Senior Business Intelligence Developer/Analyst

Responsibilities:

• Played a key role in developing, implementing and demonstrating the successful project using VB .Net, SSRS, SSAS Designed, developed and implemented reports. Involved in re-designing or customizing the existing views and stored procedures to suit the reporting needs. Created different type of reports including: cross-tab, conditional, drill-down, top N, summary, form, OLAP and Sub reports. Created reports including formatting options such as charting, mapping, grouping, sorting, alerting, field highlighting, drill-down and parameter prompts Involved in re-designing or customizing the existing views to suit the reporting needs. Created parameterized MS chart and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports.
• Optimized SQL stored procedures for performance improvement. Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures. Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems. Involved in manual testing, Functional testing, Regression testing and Integration testing etc. Performed a bridge (Point of Contact) role between the Testing Team and the Business Team by conducting the root cause analysis of the defects logged by test team. Analyzed, designed/developed and Compliance and Ethics Report.

Environment: SSIS, SSRS, SSAS, SharePoint, SQL/ T-SQL Developer, MDX, DAX

Confidential, Atlanta, GA

Senior Business Intelligence Developer

Responsibilities:

• Creator of over 55 production reports that are run daily/weekly/monthly/annually. Created complex account management report, merchant or internal reports that replace their currently used Customer reports. Responsible for creating a variety of reports (ad hoc) as defined by the user’s criteria, using SSRS reports. Reports have sub reports (master- detail), sorting on records, parameters, formulas, summaries, special Fields, SQL expression fields, running total fields, multiple groups and record selection. Generated Reports using Global Variables, Expressions and Functions for the reports. Created linked reports from the initial reports. Involved making changes to the existing reports as per the updated business requirements of the users.
• Involved in developing functional design document and technical design document using the requirements document. Participated in weekly IT status update meetings.
• Used Tangible T4 Editor - The tool allows us to convert RDLs created in BIDS into RDLCs that our framework supports.
• Used BeyondCompare3 setup for VS2010 Reporting Globalizations specification to flexibly support our globalization requirements. RDL-to-RDLC Process.
• Reported Branding and Styling - Covering our specification for custom branding and styling.
• Designed and developed a database to house data from various data sources for all reporting needs High T-SQL proficiency. Experienced in MS SQL DB schema and dbproj-based databases.
• Created Tables, Views, Queries, Stored Procedures, Triggers and User Defined Functions and Alter, Insert Update statements using T-SQL in SQL Server as part of report development.
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2008 and Flat files. Developed functions based on BCP to import data from flat files into SQL server tables and export into XLS files.
• Optimized SQL stored procedures for performance improvement. Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Involved in manual testing, automated testing, Functional testing, Regression testing and Integration testing etc. Performed a bridge (Point of Contact) role between the Testing Team and the Business Team by conducting the root cause analysis of the defects logged by test team. Analyzed, designed/developed and supported Sales, Manufacturing and Transportation Reporting requests for GFN Project.

Environment: SSIS, SSRS, SSAS, SharePoint, SQL/ T-SQL Developer, MDX, DAX

Sales Force Report Developer /Analyst

Confidential

Responsibilities:

• Sales force team analytical and reporting, design and development of compiling and tracking tools and mechanisms for the Grow the Sales Force Department.
• Projects included formulating and generating statistical reports, sourcing, organizing and analyzing company and industry statistics to determine trends, monitoring performance, identifying indicators and tracking programs.
• Identified and developed key indicator tracking, reporting tools and mechanisms to improve production or workflow as required.
• Coordinated and developed statistical tracking and trend analyses on a daily, weekly, monthly and ad hoc basis.
• Managed sourcing and archiving of articles, studies and news items related to company initiatives and interests related to industry, product lines and company business.

Confidential, Duluth, GA

Senior Business Intelligence Developer/Analyst

Responsibilities:

• 7+ years of experience in Health Care environments with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite. Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server … … Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting. In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analysiss. SQL Server … RDBMS database development including T-SQL programming. SQL Server … OLAP database development including KPIs, Data mining, working with changing dimensions ETL implementation using SQL Server Integration Services (SSIS).
• 5+ years of Experience in Crystal Report.
• 2+ years of experience in implementing Business Intelligence, expertise in Data warehousing, Data architecture, Data modeling, using MicroStrategy. Comprehensive working Knowledge with MicroStrategy Desktop, Architect, Web, Narrowcast Server and OLAP Services Environment. Possesses extensive experience in the MicroStrategy Product Suite (MicroStrategy Intelligence Server, MicroStrategy Desktop, Architect, Report Services and MicroStrategy Web) Extensive work on creating and modified MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, users, user groups, security filter etc.) using Micro strategy desktop.
• Very good understanding the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables. Good knowledge of Star and Snowflake schemas.
• Good knowledge and experience in all aspects of Software Development Life Cycle (SDLC)
• Good knowledge and experience in Software Analysis, Design, Development and Production Support of business intelligence application.