PROFESSIONAL SUMMARY:

• 15+ years of experience in Business Intelligence with an expertise in Data analytics & Visualization. Looking to work in environment that provides the opportunity for me to apply my knowledge of data capture, management, analysis, research and policy making in solving various problems.
• Seeking a challenging role as a Business Intelligence Specialist and Data Analytics position in a highly technical company where my skills in Development Tools, Report developments and Database skills will be utilized for quality service to the company.
• A very skillful leader with proven ability to work under a high - pressure business environment. Outstanding communicator with excellent written, verbal and interpersonal skills.
• Data analysis/profiling/modelling, SSIS /Data Warehousing, CRM Sales Force Automation, ETL process, Master Data Integration, Logistics, Sales & Finance Reporting
• Change Management, Vendor Management, Requirement gathering and analysis, Solution Assessment, knowledge of SDLC, IT Project co-ordination, Strong Client Facing skills, Business Process and systems development, Strong analytic and problem-solving skills, Technology implementations
• Extract, transform and load using Sync sort DMX.
• Worked with Data Visualization tool like Tableau.
• Worked with Data Profiling tool like DQ Analyzer.
• Expertise in SQL/T SQL, Stored Procedure development and SQL Tuning.
• Proficient in creating, enhancing and debugging simple to highly complex SQL queries, Stored Procedures triggers etc.
• Prepared process flow design, data modelling, effort estimations, and established end-to-end data flow mechanism as per project SDLC.
• Very good analytical skills. Has been involved in Data analysis, Pattern Identification, Data Quality investigations.
• Good experience in Data Management, Data Migration, Data integration, Data Profiling Strategy preparation and planning
• Good team player, systematic and disciplined performer with effective interaction and communication skills, hardworking, and committed to achieve project goals.
• Experience in multiple domains such as Capital market, Banking, Finance, Insurance, Telecom etc.

TECHINICAL SKILLS AND CORE COMPETENCIES:

Database: Microsoft SQL Server (2005, 2008 & 2012), IBM NETEZZA, DB2, MongoDBSQL Lite, MS Access, SAS

Language: R, C#, Python

Scripting Language: Regular Expression, HTML, CSS, XML, XQuery

Data Analytics Tools: Hadoop, Hadoop MapReduce, Hive, Pig, Spark, etc.

Machine Learning Software: IBM Watson, Weka

ETL: Microsoft SQL Server Integration Service (SSIS 2005, 2008 & 2012), SAP BODS V

Analysis: Microsoft SQL Server Analysis Service (SSAS 2005, 2008, 2012)

Data Analytics & Reporting Tool: Microsoft SQL Server Reporting Service (SSRS 2005, 2008 & 2012), Crystal Report 8, 10 & XI Release II, TIBCO SPOTFIRE 6.0, Tableau 10 & IBM Cognos Reporting SAP Business Object Suite 4.0 including Dashboard Designer (Crystal Xcelsius), SYBASE Power Designer, Advance Query Tool (AQT)ATACCMA Data Profiling Tool Special expertise in T-SQL, MDX (Multi- Dimensional Expression Language) SAP Certified Professional for HANA

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Developer & Reporting Specialist

Responsibilities:

• Designed conceptual data model based on the requirement, interacted with non-technical end users to understand the business logics.
• Modeled the logical and physical diagram of the future state, Delivered BRD and the low-level design document.
• Discussed the Data model, data flow and data mapping with the application development team.
• Helped developing Power Designer document, Conducted Unit testing, coordinated the production deployment and resolved Post implementation issues. Provided Maintenance & Support of the existing applications.
• Major ETL development using SSIS 2012
• Strong Framework designed
• Configurable package framework
• Specific pattern designed for different packages
• Excessive use of Expressions in control to customize the specific needs.
• Transaction support in ETL in case of failure of package during insert/update operation
• Script writing using C#
• Event controlled package in case of any failure.
• Custom logging mechanism in package.
• Custom reports are designed to generate automatically when package is completed.
• Project deployment model pattern designing
• Package testing/debugging during development
• Analytical reports development using Tibco Spotfire 6.0
• Gathering requirements for the design of TIBCO Spotfire visualizations.
• Involved in development activities of Spotfire.
• Designed and developed flows
• Worked on the template creation on the Tibco Spotfire 6.0 version
• Independently designed, visualized and implemented a solution.
• Translated specifications into TIBCO Spotfire visualizations.
• Effectively communicates to Internal and External Stake Holders.
• Involved in activities related to gathering interview questions, updating the interview questions from client.
• Understanding Functional Requirements and scope of the document.
• Mentoring team members and new joiners in application knowledge and scope.
• Interacting with client in team Meetings and reviewer meetings.
• Customizing the reports as per customer expectation.
• Designing queries for ad hoc reports
• Netezza database.
• Performing Data analysis and testing on the data to help development process.

Environment: MS Reporting Service 2012, ETL, SSIS 2012/2008/2005 , Tibco Spotfire 6.0 version, TIBCO, Microsoft SQL Server Reporting Service (SSRS 2005, 2008 & 2012), Crystal Report 8, 10 & XI Release II, IBM Cognos Report

Confidential

Business Intelligence Developer & Reporting Specialist

Responsibilities:

• Business analyst provided all the business requirements and understanding.
• Completed SSIS package designing to consolidate data from DB2 and some other sources.
• Converting Existence SSIS package to 2012 SSIS by using new techniques introduced in SSIS 2012 and deployed with project deployment model.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Staging the data before pushing to destination for speeding the process.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005/2008/2012 Business Intelligence Development Studio.
• Redesigning of Reports using Microsoft Reporting Service 2012.
• Migrated 145 Reports from 2005 Reporting Service to 2012 Reporting Service.
• Created Performance Dashboard Reports for clients.
• Writing stored procedures, Functions and Views to bring data from DB2 for Reporting.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of sales based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of sales with respect to customers.
• Initially implemented 2012 Tabular Modal
• Provided a long-term solution to implement UDM on SSAS 2012.
• Created calculated measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 OLAP databases.
• Involved in performing Audits and recovery operations of SSAS objects.
• Used Visual Source safe for repository and maintaining versions.

Environment: Microsoft Reporting Service 2012, SSAS 2012, SQL Server 2008, MDX ) Crystal Report 8, 10 & XI Release II, IBM Cognos Report

Confidential

Business Intelligence Specialist

Responsibilities:

• Participated in project planning sessions to analyze business requirements and outline the proposed solution
• Existing data from diverse data sources were consolidated into a uniform SQL Server database. SQL Server Integration Service SSIS is used for staging, massaging and cleansing of data.
• Robust SSIS packages are designed to handle the performance, exceptions and error logging.
• SSIS packages are developed, tested and promoted to production with complete cycle using developer, QA, Staging and Production servers.
• Data warehouse designed and de normalized data for analysis service.
• Migration of SSIS packages from and lastly migrated in 2012.
• Used star, snowflake, hybrid schema techniques to de normalized data for UDM preparation.
• UDM is designed and tuned to boost performance.
• Write several MDX queries according to business requirements.
• Extensive knowledge of MDX (Multi-Dimensional Expression language).
• Migration of Cubes from is carried out.
• Boosting the performance of SSAS cube using partitions.
• Perspective is applied on the cube to access the appropriated data for specific users.
• Installed and configured software on client and servers.
• Designed, developed and implemented reports to meet fiscal departments reporting needs.
• Writing queries for ad hoc reports.
• Designed and implemented complicated reports and sub reports.
• Develop several detail and summary reports using Microsoft reporting service.
• Modal is created in SQL Reporting service 2008 for business users for analyzing data.
• Complex Dashboards created using different platforms tools.
• Participate in intranet branding of SharePoint 2010.

Environment : SharePoint 2010, SQL Server, SSIS, MDX, Microsoft reporting service) Crystal Report 8, 10 & XI Release II

Confidential

Programmer & Senior Report Developer

Responsibilities:

• T-Sql programmer / web developer and Senior Report Developer.
• Developing web applications using Asp Dot Net 2.0/2.5 (using C# language)
• Member of Development, testing to production phase implementation of projects.
• Reports are developed in version XI of crystal report.
• Using Business Object Info Scheduler to manage the automated reports.
• Ad hoc reports designing.

Environment: T-Sql programmer, Asp Dot Net 2.0, MDX, Microsoft reporting service, Crystal Report 8, 10 & XI Release II

Confidential

Report Developer

Responsibilities:

• Analyze the requirement of the report, write the required stored procedure or query to gather the required data information, which will be used for the report.
• Planning is required for the report, which will improve the performance and execute the required format of the report that included several aspects such as grouping, sorting and filtering of the data, based on summary or detail report.
• Decide the type of the report, Form layout (Standard), Labels or CrossTab.
• Writing Custom functions for the report which are used to display some custom calculations
• Depends upon the requirement inserting the sub report into main report.
• Modifying the record selection of the report if required.
• Customizing of the reports for certain conditions of the report.

Environment: MDX, Microsoft reporting service, Crystal Report 8, 10 & XI Release II, SQL Server