SUMMARY:

• 12+ years of extensive experience in Data Analysis, Business Intelligence, development and Design. Application Development, Implementation and Maintenance in Salvage, Financial, Insurance, Healthcare and Auto.
• Software Design and Development with extensive experience in Power BI, Microsoft Reporting services including SSAS, and SSIS.
• Proficient in Python, JavaScript, CSS and HTML.
• Expertise in working with Client/Server applications using SQL Server, Oracle.
• Extensively used SharePoint for reporting and collaboration needs.
• Expertise in Developing and publishing reports of type Power BI, SSRS and Business Objects.
• Ability to understand long - term project development issues at all levels, from interpersonal relationships to the details of coding scripts. A strong team member with good Communication and Analytical skills.
• Implementing Data Science using Python libraries like NumPy, SciPy, MatplotLib, Pandas and PySpark
• Proficient in developing SOAP and RESTful Web Services .

TECHNICALSKILLS

Operating Systems: Windows, Linux

Software: Microsoft BI full stack, Power BI, SharePoint, Businessobjects5.x/6.xXIr2/XIr3Dashboard

Programming: SQL, Python, JSP, CSS, HTML

Databases: SQL Server 2016/2012/2008 R2/2005, Oracle

Database skills: Data Science - Python, Stored Procedures, Database Triggers, and Packages.

EXPERIENCE:

Confidential, IL

Solutions Architect

Responsibilities:

• Building Power BI Datasets and Reports.
• Setup auditing capabilities for Power BI system.
• Performance tuning at database, SSIS level.
• Conducting daily status meeting with Onshore and Offshore team.

Environment: SQL Server 2016/2014, Teradata, SharePoint Office 365, Power BI, SSIS, SSRS

Confidential, IL

Solutions Architect

Responsibilities:

• Migrations of SSIS packages from SQL 2012 to SQL 2016
• Upgraded SSRS 2012 to SSRS 2016 and added new KPIs and mobile reports.
• Performance tuning at database and SSIS level.
• Using Github as Source Control system.
• Replaced the existing UC4 system to trigger SSIS packages to load data from Exchanges.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published reports and dashboards to Power BI service and maintained the refresh schedules and flow of data into the related data sets
• Imported data into power BI dashboards and did mild shaping of data using Power Query inside of Power BI

Environment: SQL Server 2016/2012, Github, SSIS, SSRS, Power BI

Confidential, IL

Solutions Architect

Responsibilities:

• Build SSIS Packages along with Powershell scripts.
• Building auditing capabilities for BI system.
• Performance tuning at database, SSIS and SSRS level.
• Setting up BI Mobile application using ROAMBI.
• Using TFS as source control system and TWS for scheduling needs.

Environment: SQL Server 2016/2014/2012 , Power BI,TFS, Python 3.4, SharePoint 2013, SSIS, SSRS, SSAS, Tableau, Tivoli Workload Scheduler, MoveIT

Confidential, IL

Solutions Architect

Responsibilities:

• Maintain the Enterprise date model repository using Erwin ModelMart software.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Identified and defined Fact relationships in SSAS.
• Used Power BI Rest API for real time streaming.
• Implemented SOAP and REST APIs to bring data from cloud systems.
• Converting all MicroStrategy reports to SSRS reports.
• Setting up proper auditing and monitoring for SSRS Reporting.
• Implement performance tuning and monitoring of ETL jobs.
• Creating Dashboards using Performance Point Service in the SharePoint interface.
• Using PHP web service to write and read data real time.
• Most of the SSRS reports developed involved concepts like linked reports, clickable Maps and Drill Down features.
• Meeting with BI user group and coming with a road map plan for additional reports.

Environment: SQL Server 2016/2012/2008 R2, Python 3.4, SharePoint 2013, Power BI, Tabular Model, SSAS, SSIS, SQL Server Management, PHP, Github, Office 365, Visual Studio 2015

Confidential, IL

Senior Developer

Responsibilities:

• Installation and setting up of SSRS in SharePoint integrated mode.
• Building SSAS and report model. Also developed Business Objects universes.
• Setting up BI Mobile application using ROAMBI.
• Writing stored procedures mostly involving the concept of Change Data Capture and developing SSIS packages.
• Security setup at the SharePoint level and SSAS.
• Administrating the BI system. Managing security rights of over 700 users.
• Extensive use of Customized query to develop reports.
• Developed SSRS, Web Intelligence, Crystal and Desktop Intelligence Reports.
• Proper understanding of the ASAP system.
• Integrating Crystal reports with .net application.
• Maintaining the Microsoft Reporting and Business Objects Server.
• Automating the cleaning process of old instances from the BI system.
• Using SQL Server Management tool for verifying the report data and SQL Job setup for SSAS processing.
• Migration of Reports between different environments of BI system.
• Administration for SharePoint 2010. It involved Security, service creation and content migration.
• SharePoint 2010 support activity, which involved creation of sites, workflow and templates.

Environment: SQL Server 2012, SQL Server 2008R2, SharePoint 2010, Python 2.4, Tabular Model, SSAS, SSIS, Team Foundation Server, Roambi, Business Objects XIr2, Designer, Info View, Web Intelligence, Windows XP Professionals, SQL Server Management

Confidential, MI

IT Consultant

Responsibilities:

• Converting BO reports to SSRS Reports.
• Solely responsible for developing the universe based on TeamConnect enterprise.
• Comprehensive understanding and analysis of TeamConnect Enterprise system.
• Making sure the classes and the objects arrangement in the universe satisfies the ad-hoc reporting needs. Classes and objects arrangement in the universe reflected the hierarchical arrangement of data in the TeamConnect graphical user interface.
• Use of derived tables for specific reporting needs and implementation of security.
• Created users and groups and granted them permission depending on the usage level.
• Extensive use of methods like multiple linking of data providers and union query for report development.
• Using tools like Oracle SQL Developer to check the authentication of the report data.
• Use of oracle functions to keep different time zones into consideration.
• Generating Master detail, Cross tab and Vertical reports.
• Using custom SQL to populate the List of values for the prompts.
• Detecting cardinalities, loops and checking the integrity of the universe.
• Used Materialized views for the better performance of the reports.
• Time Zone Issue: All the reports needed to show the date depending on the time zone the user is present. I created an oracle function which would display the date; depending on the time zone the user is present. The users were prompted for the time zone they are in right now, and the report dates used to display according to the time zone.
• Security Implementation: There was a set of security rules in the TeamConnect enterprise. I implemented this security in my universe using a derived table, taking into consideration the security tables.
• Report performance slow: Materialized views were created to improve the performance of the reports.
• Filter LOVs: Use of nested prompts to filter the List of Values. This enabled the user to choose the required value from a shorter list of values.

Environment: SSRS 2005, Business Objects XIr2, Designer, Supervisor, Info View, Web Intelligence, Oracle 9i, Windows XP Professionals, Oracle SQL Developer,

Confidential, Brook Park, OH

IT Consultant

Responsibilities:

• Interacting with Business Users and Business Analysts to understand and document the requirements and Built reports using XIr2 Suite.
• Detailed analysis of data and understanding the workflow of Anti Money Laundering system.
• Worked on three universes, which are related to different workflow stages in the Anti Money Laundering.
• Used Enterprise authentication for assigning user IDs and passwords.
• Defined different Groups in CMC. Provided different access levels to the groups.
• Implemented granular security like Object-level Security and Row-level security.
• Extensive use of derived tables for few of the reports.
• Worked closely with the DBA for putting indexing in few of the tables for better performance of the reports.
• Made sure that proper implementation of Business Objects is done by getting together with the clients and making a Capacity Planning to make sure the server usage is distributed equally. This increased the performance of the report considerably.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
• Created, managed and formatted standard reports, master/detail reports and cross tab reports.
• Created URL link in Xcelsius project, using opendoc function. The opendoc parameters were specified in the Excel sheet. Using this method we were able to display Webi reports in the swf format.
• Imported data from Excel sheet and created pie-charts, bar charts and gauge using Xcelsius..
• Report Response slow- Added index with the help of DBA and used derived tables for better performance.
• Extensive meeting with clients regarding the proper deployment and working of reports.
• Resolved problems like user security and changes in the reports due to migration to newer version.
• Supporting customers in running the Business Objects report.
• Implementation of best practices in Business Objects. Made sure the universe deals with most of the report requirements instead of dealing it in the Business Objects report level.

Environment: Business Objects XIr2, DB2, Designer, Info View, CMC, Web Intelligence XIr2, DB2, Windows XP Professionals, DbVisualizer, Xcelsius

Confidential, Madison, WI

IT Consultant

Responsibilities:

• Involved in gathering requirements from Regional Managers and designed reports as per the business requirements with the help of Business Analysts.
• Created users and groups in the CMC Central Management Console and grated permissions based on their usage levels.
• Involved in security migration from Business objects 6.x to Business Objects XIr2. Applied user, group, and role level security at the object level, to documents, categories, folders, universes, connections, applications, and even servers and groups of servers.
• Created webi reports and linked these webi reports via live office to excel and then used the live office connector in xcelsius to fetch the data.
• Involved in creating and publishing reports on the web using the Info View in Web Intelligence.
• Developed Insurance reports using Crystal Reports XI.
• Created Master Detail and Cross Tab reports to view different types of bills and claims under different regions as per type and date.
• Checking the data after the ETL loads and coordinating with ETL developers and architect/designers.
• Involved in user sessions and assisting in UAT (User Acceptance Testing). Validated the data of reports by writing SQL queries in TOAD against ODS

Environment: Business Objects 6.1b/XIr2, Crystal Reports XI, Web Intelligence 6.x (Reporter, Info View), SQL, Oracle 9.x, Application Foundation XIr2 / 6.5.1, Designer, Reporter, Supervisor, DB2, Windows XP Professionals, Visual Basic, TOAD, Xcelsius, Business Objects Live Office.