SUMMARY:

• Around 7 years of experience in Software Design, Development, Analysis, Testing and Business Intelligence tools.
• Strong hands - on experience in developing Business Intelligence solutions with the Microsoft Business Intelligence stack, SAP BO, Power BI and Tableau .
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Implemented business solutions through research and analysis of data and business processes.
• Translates strategic business logic into technical report requirements and schema design.
• Experience in Performance Tuning and Query Optimization.
• Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services 2008 / 2008 R2/2012 (SSIS).
• Experience in enhancing and deploying the SSIS Packages from development environment to production server using package configurations.
• Strong SSRS development skills, experience including Tablix, Matrix, chart. Top N, Summary, drill-down/drill-through reports, sub-reports.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Good knowledge in building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Great experience in creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Hands- on Tableau visualizations and dashboards using Tableau Desktop .
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Good experience in Source Systems Analysis, designing Packages with Source-Target Mappings.
• Hands on reporting tools like Crystal reports, SAP Business Objects and Power BI.
• Professional in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) and its deployment.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Excellent data-analysis skills and ability to translate specifications into a working Universe and/or Report.
• Experience in building and retrieving data using Universes, data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in analysis, design and construction of Data warehouses and Data marts .
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Certified in Markit EDM (CADIS) enterprise data management tool.
• Experience with Healthcare, Banking & Finance.
• Strong analytical, administration and problem solving skills, ability to work independently.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS:

Databases:: SQL server 2008, 2008 R2, 2012,2014, Oracle 10g,11g,12c, My SQL, MS Access, NoSQL

ETL tools:: SQL Server Integration Services(SSIS 2008,2008 R2, 2012, 2014), Data Stage 8.x, Informatica Power Center 9.x

Reporting tools:: SQL Server Reporting Services(SSRS 2008, 2008R2, 2012, 2014), Tableau 9.x,10.x, Crystal Reports X, SAP BO XI R2, R3, 4.x,Jaspersoft, Microsoft Power BI, Microstrategy

Analysis:: SQL Server Analysis Services(SSAS 2008,2008 R2, 2012)

Programming Languages:: T-SQL, PL/SQL, R programming, Unix shell scripting

Enterprise Data Management tools:: Markit EDM(CADIS)

Cloud Computing: : Microsoft Azure

Version Control & Other tools: : TFS, SVN, JIRA, Version One, HP Quality Center(QC), MS Office

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

BI Developer

• Worked with Business Analysts to understand the requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, Unit testing, code deployment).
• Involved in creating and maintaining database objects such as tables, indexes, views, stored procedures, and user defined functions in T-SQL.
• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity.
• Actively involved in system performance by tuning SQL queries and stored procedures by using SQL profiler.
• Understanding the client’s requirements and developing the reports in SAP BO and crystal reports.
• Analyzed existing Universe and Database to enhance the existing Universe and created new Universe.
• Worked on Web Intelligence to develop and publish reports.
• Maintained and enhanced existing Universes as per the requirements given by the client.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Worked in migration of universe and reports between environments
• Implemented object level security universe to in corporate security for sensitive information.
• Maintained user security on the BO Reports, Folders and Universes.
• Created different categories to simplify it to the users to locate the reports.
• Generated various report templates for standardizing the reports throughout the organization.
• Developed Tableau data visualization using Bar Charts, Line Charts, Cross tabs, Scatter Plots, Geographic Map, Pie Charts and Density Chart.
• Worked extensively with Calculations, Parameters, Conditional formatting, Background images, Maps, Trend Lines, Statistics and table calculations.
• Effectively use data blending feature to get data from multiple sources in Tableau.
• Building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Published and shared reports to the business users using Tableau server.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Create various support documents like mapping documents, Technical design document, Unit test cases, Unit test results and Deployment plans.
• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data using Crystal XI.
• Developed/Enhanced SSIS packages using Data Flow tasks, conditional split, Derived column, Data conversion, look up, merge, union all, Execute SQL task, Execute Package Task, Sequence container etc.
• Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
• Developed table, list and matrix reports using report builder and BIDS according to the requirements provided by the client. Created reports using sub reports, drill down, drill through, TOP/BOTTOM analysis and conditional formatting features. Also created ad-hoc reports using report model.
• Deploying the SSIS packages and SSRS reports in DEV, QA, UAT and PROD environments.
• Subscribe Reports using SSRS to generate all daily, weekly, monthly Reports.
• Monitoring of scheduled jobs and created alerts to track the status of the job.
• Involved in creating KPI’s in cube and send alerts to users when required.
• Enhancing the Cube Data Source views, Cube measure groups, calculated measures as per the new requirements.
• Created calculated measures using DAX within SSAS models.
• Migrated SSIS packages, SSAS cubes, SSRS report from 2008R2 to 2012 using migration wizard and fixed the issues that we came across after migration.
• Unit testing of migrated data and reports in different environments and collect unit test results.
• Closely worked with on-site team to ensure accurate and efficient implementation of required functionality.
• Reverse Engineering of existing SSIS packages and created mapping sheets that are helpful in the development of Markit EDM project and developed graphical user interfaces in Markit EDM (CADIS) tool that helps the business users in making analytical decisions.
• Participate in scheduled development sprint cycles and targeted performance goals.
• Trained the junior developers in the team to understand the business process.
• Participated in the internal training on Microsoft power BI and Tableau.
• Ensure best practices are applied and integrity of data is maintained through security and proper documentation.
• Used Exception handling to catch and report the errors.