SUMMARY

• Looking for a challenging opportunity as Senior Callidus Consultant (Solutions Delivery/ Data Integration /Application Integration / Business Intelligence Systems/Data Warehousing) in DW/DI/BI with around 17 years of IT Experience, 15 Years of DW/BI and Data Analyst in DW/BI reporting and 7 years of ETL Data Integration experience with wide variety of Business Industry, BI tools and application software experience. Strong Experience in AGILE and Scrum Process and Methods.
• 5 Years of Experience in Migrating MS Access DB to SQL server 2008 R2,2012 and SQL server 2014.Build complete Data warehouse solutions end to end in Confidential and Kaiser.
• 4 Years of Financial experience ( Confidential Bank, Federal Reserve Bank, World Savings Bank and AXA financial)
• Sound Knowledge and Experience in Understanding the Business partner needs and transforming Business Needs in to Technical Solutions and BI Reporting Needs. Using ETL, BI Tools and Applications.
• With Strong Background in Data warehouse, Data Analysis, Data Cleansing, ETL development using SSIS, BI tools, Testing, Document Management tools.
• Strong Experience in ArcGIS Geocoding and Geotagging with related to Store Locations Mapping.
• Willing to Learn and Adapt latest tools and Technologies in the current changing Market.
• Extensive background in development on multiple databases. T - SQL (9 years SQL Server, 5 years Oracle PL/SQL, 2 Years in IBM DB2,2 years of Teradata and 2 years of Sybase, 1 year of MySQL and BIG DATA)
• Strong at various Database Join types, SQL Grouping, Use of built-in functions/User defined functions. Modifying/Analyzing existing complex code. Understanding Entity-Relationship and coding using ER diagram. Strong in Figuring out logic from existing code and schemas. (code debug skill).
• Strong data knowledge, assess business needs, elicit and define requirements, develop SQL programming to pull data from multiple systems, and produce data sets, reports and Tableau dashboards.
• Strong Self-starter, flexible, detail oriented, strong communicator, a team-player and able to effectively handle multiple and changing projects/priorities.
• Primary area of expertise and interest in commercial development for the Web development, GUI, Client/Server, RDBMS under Windows NT utilizing strong coding and debugging skills, familiar with OOD/OOP. Strong in BI Reports requirements gathering, SSD, TRD, TSD, Unit Testing and Deployment document creation.
• Strong Experience in extracting data from application tables, developing report prototypes, modifying standard reports, producing/running ad-hoc reports, and automating reports. Strong knowledge working in both OLTP and OLAP data warehouse reporting.
• Skills and Extensive experience on Business Intelligence Reports Development Using Actuate Enterprise Reports, Actuate / BI - XML publisher Developer/Business Objects / Discoverer / Crystal Reports/ Web Focus around 14 years of IT experience including 10 years in DW BI Reports Development which Includes analysis, design, development, testing and technical support of Siebel Analytics (OBIEE), Siebel ICM, Callidus True comp, Siebel CRM, PeopleSoft CRM, Configuration, Actuate erdPro and Actuate eSpreadsheet report (Version 3.0/4.0/5.0/6.0/7.0/8.0/9.0 ).

PROFESSIONAL EXPERIENCE

DEV LEAD

Confidential - Owings Mills, MD

Responsibilities:

• As part of Internal Sales Compensation Implementation managed 10-15 Team of Development, Testing, UAT and Business Team.
• Supported existing Broker Comp and New Implementation of “Sales Incentive” Project
• Gathering the Business requirements from Functional Team to convert functional into Technical Definition to get all the deliverables from DEV, SIT, and UAT to Product Acceptance.
• Used AGILE Methods, Scrum Board, User Story for Process improvements
• Working For data integration /Application Integration from Sources systems Salesforce and PeopleSoft data into Commissions Cloud Application using Informatica ETL.
• Responsible for creation of database in ORACLE and maintaining the database Developed various complex stored procedures, Functions, packages, and triggers in PL/SQL
• BI reporting done using Crystal reports 2016 in Business objects Server and SAP HANA for Sales Incentive Project.
• Callidus Support Web used for Case management solutions For DB access, Informatica data load Access, Reporting Server access and Project related tasks

Environment: Comp Business Rules Definition, Data Integration and BI solutions Confidential Commissions implementations, Complex DB development (Including Stored Procedures, Functions, views, Complex SQL), Crystal Reports 2008/2016, SAP Business Objects, Oracle 11g, SQL server 2012, DB2, Shell Scripts, ODI framework and Service Now

Confidential

DEV LEAD

Responsibilities:

• As part ANTHEM Internal Sales Compensation Implementation managed 20-25 Team of Development, Testing, UAT and Business Team.
• Gathering the Business requirements from Functional Team to convert functional into Technical Definition to get all the deliverables from DEV, SIT, and UAT to Product Acceptance.
• Used AGILE Methods, Scrum Board, User Story for Process improvements
• Working For data integration /Application Integration from Sources systems Salesforce and PeopleSoft data into Commissions Cloud Application using Informatica ETL.
• Responsible for creation of database in ORACLE and maintaining the database Developed various complex stored procedures, Functions, packages, and triggers in PL/SQL
• BI reporting done using Crystal reports 2013 in Business objects Server.
• NetSuite used for Case management solutions For DB access, Informatica data load Access, Reporting Server access and Project related tasks
• As a Senior HealthCare Analyst handling 3 Projects (Local, Telesales and Nationals) simultaneously with focus on Business Gathering, Comp Business Rules Definition, Data Integration and BI solutions

Environment: SAML, Application SOAP API integration connecting Workday/Salesforce, Application upgrade from On-premise to Cloud, Complex DB development (Including Stored Procedures, Functions, views, Complex SQL), Crystal Reports 2013, SAP Business Objects, Oracle 11g, SQL server 2012, DB2, Shell Scripts, ODI framework and Service Now

Confidential - Dublin - CA

Solutions Architect

Responsibilities:

• Worked in Data integration from Sources systems Salesforce and Work day data into Commissions Cloud Application using Informatica ETL.
• Responsible for creation of database in ORACLE and maintaining the database Developed various complex stored procedures, Functions, packages, and triggers in PL/SQL
• BI reporting done using Crystal reports 2013 in Business objects Server.
• NetSuite used for Case management solutions For DB access, Informatica data load Access, Reporting Server access and Project related tasks
• As a Senior IT consultant handling 3 Projects simultaneously with focus on Data Integration and BI solutions.
• Client - Mule soft, Centene/HealthNet, ATT, AETNA, JOC Group, Key Bank, Expedia, Ecolab, Thrivent Financial
• Migrating data from SQL server to Oracle
• Actuate Report Development for KEY BANK and Medical Mutual of Ohio.

Environment: Application SOAP API integration connecting Workday/Salesforce, Application upgrade from On-premise to Cloud, Complex DB development (Including Stored Procedures, Functions, views, Complex SQL), Crystal Reports 2013, SAP Business Objects, Oracle 11g, SQL server 2012, DB2, Shell Scripts, ODI framework and Netsuite

Confidential - Oakland, CA

Sr. IT Consultant/ Solutions Architect

Responsibilities:

• Supporting Kaiser Epic System’s suite of Healthcare products as part of Northern California Compliance (NCAL and SCAL), Privacy & Security Office and CERNER Lab System Pilot Project.
• Worked with Cloud Infrastructure Team to setup the SQL server Database 2014 and SQL server Reporting Server with help of SQL server DBS team following Kaisers Policies, Security guidelines and procedures.
• Created Requirement Gathering Documents, Functional Specifications, Technical data mapping, Data Analysis and Different Use case scenarios of validating the data.
• Did lot of data cleansing in Excel, MS Access, SQL server SSIS and Teradata SQL.
• Completed CERNER Lab System - System Activity Review (SAR) Pilot project with Two Use case scenarios of Proactive reporting for Employees who is accessing Same Household member information and Accessing Same Department Employee information of Patient Electronic Medical records in the LAB system.
• In-depth knowledge of the Clarity data model related to Access Log, Employee, Employee address, Member Address, Patient, Member and Encounter related data.
• Worked on Large volume of Teradata Audit Log data, Resolved Complex SQL issues and given better solutions or the current EPIC Health Connect System Activity review implemented in 6 different regions and Northern California different medical centers.
• Build Pilot reports in Crystal report 2013 and SSRS for CERNER LAB system SAMEHH and SAMEDEPT Use cases.
• Wrote Lot of complex SQL queries in Teradata and SQL server. Migrated large volume data from flat files, Excel, Access and Teradata into SQL server Using SQL server SSIS and Talend SSIS tool.
• Worked on Different Schemas for different types of datasets, given solutions for performance improvements in SQL.
• Ran Monthly NON- Kaiser Employee Crystal Reports in BO Info view and on demand manually. Exported the results in Excel and PDF for business users.
• Completed a Fast paced, Dynamic, High Demanding, Challenging, Complex Privacy and Compliance, Confidential, PHI Data on Privacy Violation System Activity Review Project for Existing EPIC HEALTH CONNECT System and CERNER LAB Pilot Project.
• Optimized complex SQL queries, generated data extracts from various sources, Excel reports and Tableau dashboards
• Automate processes using standard Windows/SQL Server tools, Using SQL server Agent Services.

Environment: SQL Server 2014, SSIS, SSRS, Teradata SQL assistant 13.11, Fast Load, BTEQ, Crystal Reports 2008/2013, Toad for Data Point, Talend -ETL Tool, Remedy for Creating Work orders

Confidential - San Francisco, CA

Technical Project Manager

Responsibilities:

• Worked in Fun and Challenging GREO-IM core team Build and Maintained Full Data Warehouse Database Development of GREO database.
• Transformed Large volume (160 million rows from the Key table) and Quality of Data (Removing Unwanted Characters, Data formatting, Data type issues, Aggregation of data for Different dimensions, Demographic GIS Geocoding data) from different Data sources (Excel, Flat Files, Access, Oracle and other sources) in to Meaningful information to Business Partners to access the Information from the apps built on ESRI ArcGIS Mapping Application, MS Access Store Profile Application, BI tools (Tableau, BIRT) and Custom Web Applications Built on LAMP (Linux, Apache, MySQL, Python) Stack on Amazon Web Services (AWS).
• Migrated MS Access ETL data warehouse in-house applications in to SQL server 2008 R2 Using SSIS.
• Created and Maintained All the database Objects including the Tables, Views, functions, Stored Procedures and wrote Complex Queries for OLTP and OLAP type of data.
• Extracted data from Micro Strategy (EDW -BI) - Traffic on Stores and AUR for Store Profile Report and Applications.
• Extracted Data from IBM Tririga GREO applications weekly. Around 35 to 50 Tables migrated for different tools and applications.
• Used MS SQL Server SSIS extensively Migrated data IBM Tririga data from Oracle, Point of Sale data for Analytics Project, Contribution Ranking Report (Financial data including IRR, IPV), Open Stores report with all financial Information and Lease Action Pipeline reports -Giving Detail Information about each and every store Opened globally with Store Status, Lease type, Store Open date, current Capital Projects and Non capital projects type and Different status information.
• Developed and Build Effective solutions to cleanse the data, Migrated the data for Automation Using SQL server Agent, extensively worked for data Integrity and data Quality.
• Imported, cleansed, transformed, validated or modeled data with the purpose of understanding or making conclusions from the data for decision-making purposes for business Partners.
• Performed data forensics to validate current business rules and investigated potential data integrity issues.
• Resolved technical and functional issues working independently, as part of a team, and with RE field and RE finance Business partners:
• Worked on Excel and MS Access for Data cleansing for Small amount of data. For Large Volume of data used SQL queries and SSIS.
• Build SQL Server 2008 R2 Real Estate Operations Data warehouse from the scratch Using SQL Server Integration Services.
• Automated Daily, weekly, Monthly, Quarterly and Yearly Data Load in to the Data warehouse.
• Data Analytics and Visualization Project, Loaded Yearly POS data in to the Data warehouse. Used SSRS, BIRT, Tableau for Business User Reporting.
• IBM Tririga Real Estate Operations Application Backend Data analysis and Wrote Complex SQL queries to extract the data for reporting needs.
• Strong Knowledge in ArcGIS Mapping applications, Geocoding Needs, Proximity, Trade Area, Capture Rate, Demographic and Data Transformations need for mapping applications.
• Designed and maintained data architecture that accommodates changing business priorities and technological changes. Wrote building data abstraction layers. Stored procedures, triggers and SQL
• Worked with CSSC Team for Collaborative effort to Build a SSIS solutions, Shared the Knowledge and Trained the Team to Save lot of time, money and Energy on resources.

Environment: MS Access 2003/2010, SQL Server 200/2008 R2, Tableau, BIRT, SSIS, Power view, MS SharePoint, PowerPivot, Pentaho -ETL, Talend, SSRS, IBM Tririga Real Estate Operations Application, My SQL, AWS, Toad for Data Point, ArcGIS ESRI, LAMP (Linux, Apache, MySQL, Python) Stack on AWS.

Confidential

Confidential, Pittsburgh, PA

Responsibilities:

• Data Mart - DW / BI - DB2 to Oracle Exadata and Teradata - DB Reporting Application migration POC for Performance and Risk Analysis
• Asset Servicing Client Technology provides development support for Workbench and related information delivery products. It caters to the business needs of the end users across both external Clients and internal Client through different forms of reports generated using reporting architecture which includes WebCR, eReporting and Desktop reporting of data from the CRS / CIW Data Warehouse. Workbench portal is a browser-based information delivery platform. It is an integrated site on the web where clients have access to a variety of intellectual properties, reports, and transaction data provided by Confidential Asset Servicing
• The objectives of this POC is to migrate the existing Data Model AS IS to targeted platform Oracle - Teradata and validate for Performance Improvement for a set of reports which is a representative combination of simple, medium & complex reports.
• Performance improvement in individual long running queries for ‘ad hoc’ execution.
• Validate the scalability with the increase in the data volume and concurrent users.
• Worked closely with team members and client related to database management, database performance tuning, scope definition, business requirements, functional Specifications, architecture, change Management, Impact Analysis, Gap Analysis, Testing-QA and Launch effort for go-live tasks
• Dealt with Data Quality and Data Governance issues.
• Worked extensively on Business Intelligence tools both relational and dimensional data modeling
• Managed 5-member team for client’s DW POC deliverables.
• Converted DB2 SQL query syntax into Oracle 11g and Teradata.
• Worked with Teradata and Oracle team for SQL conversion and 800 Test Instances creation.
• Fixed syntax issues and validated the bench mark Queries for Benchmark testing, Load testing and mixed load testing

Environment: Web sphere Portal, Oracle Pl/SQL Developer, TOAD, Eclipse IDE for Java, actuate 7, Actuate BIRT, Teradata VM ware, Oracle 11g, Teradata SQL assistant for Java, SVN Tortoise source control, Crystal reports and Custom Reporting Applications