Shail bala Email: acabjm@r.postjobfree.com Mob : +1-480-***-**** Summary: Experienced IT professional offering 5.9 years of success leading all phases of diverse technology projects MSBI expert having 4 years of relevant experience in EAI/Database/ Data warehousing / Business Intelligence Project Technology/Tools: SQL Server 2005, 2008, SSIS, SSAS, SSRS, C#, Oracle, PL/SQL Sound knowledge of technologies like HL7,EDI, ADAPTER, INTERFACES, Hadoop, ODI, OSB Experienced in writing functional and technical specifications My other Organization activities include: working on different RFPs, Effort Estimations, Capability Showcase, Solution POCs, Performance Tuning, and Optimization Industry/Domain: Healthcare Microsoft Certified BI Developer technical summary: Operating Systems WIN NT/2K/2K3/XP Programming Languages SQL,C#,ASP.NET, Core Java, E-sql, J2ME,t-sql OLAP Tool SQL Server 2012/2008/2005 Analysis Service (SSAS) ETL Tool SQL Server 2012/2008/2005 Integration services (SSIS) Reporting Tool SQL Server 2012/2008/2005 Reporting Services (SSRS) Databases MS SQL Server 2k/2k5,2008,2012,Oracle 10g,DB2 Others ICD-10, Hipaa 5010, EDI, HL-7, Team Foundation Server, Microsoft SharePoint Designer 2007/2010,Performance Point Services( Microsoft SharePoint 2010),SSAS Tabular Model, JD Edwards OneWorld XE,TOAD,Crystal Reports,Java Web Servers IIS 5.0/6.0 Portal SharePoint Portal 2003/ MOSS 2007/2010 assignment Details: organization: dell services (Dec'11 - Present) 1.1. Project name: BI2 (Aug'11-Present) Client: DeLL ROLE: Software Development Sr.Analyst Environment Used: SQL Server 2008, SSIS, SSAS, (Performance Point Server) SharePoint2010 Hardware: Intel Pentium O/s: Windows Software: MSBI tools. Project Description: BI2 has been designed to consolidate multiple sources of information into data cubes with the capability of data mash up to measure individual and business unit performances. The data displayed is also presented in a dynamic format so that a team can drill-down or display a variety of views without the need for multiple static reports. Historical reporting will also be available to provide side-by-side comparisons over time. The key design highlights of the BI2 project as follows: Gather data from more sources by using SSIS 2008 (ETL tool) Deliver value through analytical science Improved reporting capability. ROLE: Developer Writing SQL queries and creating stored procedure to populate data mart. Designed High level SSIS Packages to load data from production data sources (SQL Server to data mart into data ware housing server). Designing Star schema, Measure Group, dimensions, and hierarchies. Specifying dimension usage and define relationship between Dimension and Fact table Deployed Cubes on Development environment Designed and deployed the reports using SSRS and Performance Point Server(Microsoft SharePoint Server 2010) Daily Interaction with Client. Acted as a lead and tracked progress to ensure project milestones were completed on time, with the desired results with quality and meeting client expectations. Involved in database development using stored procedures, triggers, views and cursors. Followed the Agile Methodology in the SDLC. Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. Wrote efficient stored procedures for the optimal performance of the system Monitored performance and optimized SQL queries for maximum efficiency. Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data Created indexed views, and appropriate indexes to reduce the running time for complex queries To keep track of data manipulations using Audit functionalities. Generated custom and parameterized reports using SSRS Created reports that call sub reports in SSRS Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs Responsible for creating datasets using T-SQL and Stored Procedures and also involved in Data visualization. Created several packages in SSIS. Custom components for SSIS packages were written in VB.net. Scheduled the packages to keep extracting the data from OLTP at specific time intervals Used various transformation tasks to create ETL packages for data conversion. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities Responsible for rebuilding the indexes and tables as part of performance tuning assignment Details: organization: dell services (JUL'10 - dec'11) Project name: Managed file transfer-dignity health Client: Experian Environment Used: SQL Server 2008, SSIS, SSAS, SSRS, SharePoint2010 Hardware: Intel Pentium O/s: Windows Software: MSBI tools. Project Description: Managed File Transfer solution supports all file transfer activities between applications inside and outside of CHW network which are currently served by existing P2P applications, EDI Scripting Framework, standalone cron jobs, existing ConneXion batch transfers. MFT provides a stable, standardized and scalable framework/platform that will cater the need of developing new batch interfaces for the EHR-Alliance implementation The key design highlights of the Redefinition project as follows: ROLE: Developer Gap analysis, technical specs and functional specs creation. Writing SQL queries and creating stored procedure to populate data mart. Designed High level SSIS Packages to load data into Landing and staging zone from flat files. Designed High level SSIS Packages to load data from production data sources (SQL Server to data mart into data ware housing server). Solution given to develop slowly change dimension in SSIS 2008. Designing Star schema, Measure Group, dimensions, and hierarchies. Specifying dimension usage and define relationship between Dimension and Fact table Deployed Cubes on Development environment Designed and deployed the reports using SSRS 2008 Developed Test Plan and test cases. Extensive experience in Installation, Configuration and Updates of SQL Server. Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert. Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle. Designing and Deployment of Reports for the End-User requests using Web interface & SSRS Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2005/2000/7 with T-SQL. Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams. Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets. Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions. organization: DELL Perot Systems (JAN'09 - Jul'10) Project name: user provisioning-data migration (Jan'08 - JUL'10) ROLE: Software Development Analyst Client: Catholic healthcare west Environment Used: Hardware: Intel Pentium O/s: Windows 2k3 Software: Oracle 9i/10g, SharePoint Designer, Crystal Reports, Javascript, Jasper ETL, PL/SQL, TOAD Project Description: Catholic Health West (CHW) headquartered in Phoenix, Arizona, operates 41 acute care hospitals that span a service area that encompasses parts of Arizona, Nevada and most of California.Each of the hospitals is divided into departments and further sub-departments. The employees and the contractors working for the CHW are assigned to some department/sub-department. There are a number of applications that are used by the department/sub-departments for the day to day activities of the hospital. The user needs to be granted access to these applications so as to perform their tasks. For the purpose of provisioning the users to various applications, CHW is using a product called GateKeeper. The drawback of using this tool is that it provides discretionary access to the users. The User Provisioning solution is aimed at developing a solution for CHW, so that the provisioning of the users to the applications becomes role based. ROLE and Responsibility: Involved in design, development, and maintenance of database related task. Designed data model and involved into writing SQL queries and creating stored procedure. Designed ETL package and Scheduling agent jobs to process ETL Design, implementation and defect fixing Onsite-Offshore coordination Assist team members in technical issues Designing and developing the database application and involved in designing the database structure for an application. Planning for backup and recovery of database information and estimating storage requirements for an application. Creating primary objects (tables, views, indexes) as per the design requirement and assignment Details modifying the database structure, as necessary, from information as per design specs. Responsible for evaluating and implementing database tools, documenting schema, ER diagrams, standards for use, control, maintenance and database updates. Manage/maintain, support, and maintenance agreements, administering all servers in the Web environment, managing database security, overseeing the data backup plan, etc. Monitoring ETL package and sql server agent job on daily basis. Coordinated the work with team across geography to facilitate the operations delivery among medical hospital based End Users, technical teams and development teams. assignment Details organization: PEROT Systems (MAR'08- JaN'09) PROJECT: CHW (ConneXion) Client: Catholic Healthcare West, CHW is a chain of hospitals across US. Environment: H/w: Intel Pentium O/s: Windows XP Tools: SQL Server2005,Oracle, Java 5.0, Java Script. Project Description: The current integration hub at CHW is developed on two message-oriented middleware platforms, which are Neon and Datagate. The project aim is to provide a robust, scalable, and state-of-art integration platform that will replace Neon and Datagate with monitoring products. Role: Involved in design, development, and maintenance of database related task. Designed data model and involved into writing SQL queries and creating stored procedure. 0 Responsible for developing Adapter Scripts (start adapter, stop adapter, etc.) 1 Responsible for implementing the Enhancement Requests in the adapter code. Enhancement of adapter and messaging framework Responsible for defining and implementing Oracle RDBMS code including both DDL and DML. Responsible for understanding and application of stored procedures, functions and Triggers using PL/SQL. Responsible for evaluating and implementing database tools, documenting schema, ER diagrams, standards for use, control, maintenance and database updates. 2 Analyze the requirements of the new interfaces to be developed and prepare Tech notes. 3 Design and development of the interfaces according to the specifications on the WBIMB platform. 4 Preparation of high-level technical specification & low-level design. 5 Code-review, testing and implementation of work-products 6 Unit testing of the developed interface and deployment of the developed interface on the required server. 7 Onsite/Offshore coordination assignment Details PROJECT Name: DOLE LOH (Oct' 07 - MAr'08) Client: Dole Food Company - LA -USA Environment Used: Intel Pentium O/s: Windows 2000 Hardware: Intel Pentium O/s: Windows XP Software: JD Edwards One World B7333 (Peoplesoft Enterprise One), VPN connectivity Project Description: This project is customization and implementation of clients existing ERP JDE Oneworld XE, which has number of branches in USA and Canada. The customization and implementation in existing system will help their management in timely acquiring the information from all the offices located in USA and Canada. Customization and automation in sales & Distribution, Financial Accounting and other modules makes their entire process seamlessly integrated. ROLE: Team Member Analysis, design and development according to the specifications and creating the Requirement Document. Defining Functional - Technical specification, Gap analysis Development and Designing of various applications, Table Conversions, NER, Reports using JDE OneWorldXe development tool set. Xe's different tools like OMW, Interactive Applications, Batch Applications, Data Structures, Business Views, and Table Design. Modification of the existing objects- Interactive application, Batch applications, Tables, and Business Views. Modification of Standard Applications of JDE. Preparation of Test case documents Unit testing of the objects academics: M. Tech From Banasthali Vidyapith in 2007 Bachelors of Engineering from Institute Of Engineering and Technology, Agra, 77.87%. Intermediate from UP Board in 1997 High School from UP Board in 1995 Professional Training and Continuing Education Microsoft Certified Technology Specialist - SQL Server & Business intelligence Development 2008 Certification in German language Sun Certified Java Programmer 1.5 MQ Admin Certified from IBM Awards Spot awards ( Dell Performance awards) in year 2010 & 2011 Bronze award ( Dell Performance awards) in year 2012 Best written Case study award at org level.