Summary

• Over 18 years of experience in Information Technology in project management, development, SAP Business Objects, Business Intelligence in Health care, Finance, Insurance, and Pharmaceutical companies.
• Over 14 years of Business Intelligence development and support for clinical, financial Lawson HR, Payroll, Finance, Supply Chain, AP and GL and Manufacturing Applications
• 8 years of experience in SSIS, SSAS, SSRS and Database Administration. 8 years of Data modeling experience using ERWIN and complete understanding of Embarcadero. 12 years of experience in SAP Business Objects Administration of about 1000 user accounts using windows Active directory security model. 12 years of BI experience in Hospital with 15000 employees using SSIS, SSAS SSRS and SAP Business Objects. 4 years of experience in Business Objects Universe design, WEBI reports, and dashboards development. Excellent knowledge of developing Oracle/SQL database tables, views, procedures, triggers and maintenance. Microsoft certified in SQL server. SSAS Tabular model.
• Completed training with Big Data-Hadoop Map Reduce, PIG, HIVE, Flume, Sqoop
• Database: Oracle 11g, SQL Server 2005, 2008, 2012, MS Access, FoxPro, and Sybase.
• Data Modeler: ERWIN, Embarcader
• Data warehouse: Informatica, SSIS, SSAS Multidimensional, Tabular, Power Pivot
• Reporting: Crystal Reports 2008, 2011, Business Objects XIR3 4, WEBI Reports, Dashboards, and SSRS
• Programming Languages: Visual Basic 6.0, VB.NET, Java, Java Script, HTML, ASP, PL SQL, and good understanding of XML and HL7 interfaces.

Experience:

Confidential

As a Consultant responsible for design and development of Chat-iQ data warehouse staging tables, ETL, data mart using SQL Server 2014 and also designed and developed Chat-iQ Cube using SSAS In-Memory Tabular model for Analysis and Performance improvement. Responsible for Security design, Power view reports in SharePoint and MS Office 2013. Also assisted in Server configuration and installation of 2014 SQL server and SS Data tools

Confidential

• Architecture and development of ETL process, data mart and cube for Nissan Certified and pre-owned vehicles
• As an Architect/Senior BI Developer consultant participated in gathering technical specifications, documentation, worked closely with BA for business requirements and stake holders for review and approval. Created Physical and logical design, discussed with IT Management various best practice and performance. Designed staging and data warehouse database. Worked on ETL process SSIS and Cube development using Analysis Services SSAS . Developed test scripts for testing, deployment from Development to Model and Production. Completed project on time working closely with BI team and Data base team. Created knowledge transfer documentation for production support.
• Reviewed the existing Mobile services ETL process and Cubes, and advised suggestions to modify some of the stored procedures and also advised to process the cube partition s .

Confidential

• Architecture and development of data mart for Data validation from Lawson ERP data with Lawson cube daily after processing the cube, notify all the stake holders for data accuracy
• As a consultant Architect/Senior BI Developer participated in gathering technical specifications, documentation, collaborated business requirements with stake holders, discussed with IT Management about the infrastructure and software requirements for the best practice and performance. Designed the 2 Terabyte current databases for staging and data warehouse. Worked on ETL process SSIS and Cube development using Analysis Services SSAS using industry level best practices, calculated measures, perspectives, Many to Many, support tasks, test scripts, deployment from Development to QA and Production. Completed project on time working closely with BI team and Data base team. Documentation using BI documenter, standard SDLC processes and procedures. Knowledge transfer to support teams and business Managers and users. Used SSAS Power Pivot and Power view reporting
• Premium Hyperion Project- Validated the servers analyzed the conditions to improve the system performance. Participated in Stake holders meetings, migrated the databases, identified the dependencies, involved WEB Team and BI Team, worked with change management process, followed the industry best practices for risk analysis, backup and restore. Conducted user trainings, communicated the documentation to the business users for existing and new reports. Implemented and documented the project successfully.
• Involved in the performance tuning of the database.
• Payment Portal: Improved the existing SSIS ETL process performance by 10 hours from 13hrs to 3hrs of the data base 80 million inserts and 9 million updates from SQL data base to Oracle database of 500 million records for a payment portal application on a bi-weekly basis.
• Reports developed using SSRS, SharePoint and Power view
• Designed and developed stored procedures for better performance
• Analyzed the requirements and re-architecture the calculated measures, created new groups in an existing Lawson BI cube

Confidential

• ETL Architect, development of Total rewards statements for 14000 employees to explain the full value of Pay and Benefits from different data sources using dashboard and bursting using SQL, ERWIN, SSIS, SSAS, and SAP business object
• Designed several ETL processes using multi-platform applications
• Project Manager for the Physician Performance, specifications, architect for the data model, Analysis, Analytics ETL process, Data trends design using Pro-Diver, Dashboard development for the CNO and CEO of the Hospitals using SSIS, SSAS and SSRS and Pro-Driver
• Led multiple projects for all phases of Software development life cycle
• Involved in multiple clinical and Financial applications upgrade projects
• Active team member for ICD-10 codes data warehouse conversion project from Oracle to SQL server 2008
• Team lead for the Lawson 9.0.1 data warehouse upgrade project
• Team lead in Lawson employee and RN retention data warehouse project, functional design and development
• Developed Analytical reports and dash boards for Supply Chain using Business Objects, SSAS and SSRS.
• Data modeler and support for 403B/401K employees' contribution, company matching and basic contribution for 7 years
• Led consultants for development of Data modeling/Business Objects projects for the past 3 years
• Design complex queries, WEBI reports, schedules, views, and stored procedures for Lawson, Kronos, PHS, Physician Referral system
• Re-architect payroll dashboards and data warehouse by working with Controllers and VPs for budgeted and Actual FTEs' bi-weekly schedule for management's review using dashboard builder and live office
• Project Manager for the Installation, implementation and administration of Business Objects Enterprise 10, XI R2, R3 XI 4.0
• Responsible for database design for ETL process and Universe design, development and maintenance
• Developed data mart for Surgery deportment for scan tags for patients, Items, requisitions, PO processing and order placing using SSIS
• Provide user training in SSRS/Business Objects for ad-hoc Business Intelligence reports
• Led to develop bi weekly Lawson interfaces for employees'/dependents' medical, dental, vision and disable insurance, to provide encrypted secured ftp files to insurance providers using .NET

Confidential

• Functional Analyst for Lawson implementation, data mapping, data migration and data mart development
• As a consultant helped in creating data mart using SSIS, Lawson and Business Objects deployment, and security
• Developed test scripts for testing Business Objects functionality and load balance
• Developed complex SQL queries and Views for data extraction
• Conducted client meetings to gather requirements to design the models for reporting purposes
• Administration of security, user accounts using LDAP for Business objects Enterprise
• Application support for the end user issues, for Crystal and WEBI reports from Lawson HR, Payroll, AP, Supply chain and Finance

Confidential

• As an Analyst involved in full life cycle software application development for short and long time advertisement sales using Visual Basic, C , Java Script, HTML, SQL server, ASP and IIS web services
• Implementation and customization of application programming using Visual Basic
• Cost and profit Analysis of purchase and usage from multiple vendors by developing reports for marketing and other management teams
• Design data models using Ervin for Oracle database
• Developed views and stored procedures for reports
• Led reporting team for operational and billing support
• Used informatica for data warehouse and business objects for reporting

Confidential.

• Manager application development and support for a team of 8
• Application customization for Accounts Payable, Human Resources and Finance modules using Visual Basic, Java and Java script, and Oracle
• Developed simple, medium and complex Crystal reports and embedded in Visual Basic application.
• Involved in the full life cycle software development of the product
• Developed Reports for Accounts Payable and Payroll module using business views
• Developed COM components using Visual C for middle tier and business logic for the Ads and discounts for the customers from the partner sites
• Developed Cascading Style Sheets in the web pages
• Developed several procedures for the product development

Confidential

• Database developer for the Pharmaceutical products division
• Developed project plans for the Pharmaceutical product development
• Developed project Methodologies for best practices in the industry
• Forms development using Visual Basic
• Trained in COBOL
• Acts as liaison between IT and products/ inventory departments
• Performed daily Database maintenance and backups.