PROFESSIONAL SUMMARY:

• Over 12 years of experience as BI data analyst, Business System Analyst, integration analyst , tester and programmer
• Solid industrial practice on several BI/BW architectures: SQL BI stack using SSIS,SSRS and SSAS, SAP BI/BW, BO, Crystal report, Micro strategy with strong ETL, OLAP/OLTP skills
• Conversant with all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Strong technical knowledge in MS SQL Server development including Microsoft Integration Services SSIS ,Microsoft Analysis Services SSAS ,, Reporting SSRS Performance tuning, Designing logical/physical databases and Troubleshooting.
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BIsuite, Reporting and Analytics.
• Involved to work with SSIS for creating staging, target environment in Netezza.
• Proficient data analysis experience using Excel, Power pivot, Access, SAS base, Enterprise Guide, SAS forecasting with business and quantitative acumen
• Process oriented QA/QC analysis cross multiple roles interacted within the context of business/corporate settings by using Visio
• Developed the warehouse using Ab Initio ETL Netezza/Oracle as the database.
• Experienced in finance, supply chain and online ads, ecommerce business to integrate legacy system with various enterprise applications for create dashboards and matrixes to aid business decision making
• Process oriented QA/QC analysis cross multiple roles interacted within the context of business/corporate settings by using Visio
• Created ETL process using SSIS in order to take the data for different legacy system like Netezza, excel, flat file etc.
• Hands on experience on Business Intelligence tools like MSBI 2008 and Tableau
• Extensive experiences in developing Stored Procedures, Functions, Views, Triggers, XML and Complex Queries on SQL Server 2012/2008R2/2008/2005/2000/7.0, Oracle.
• Expert in T-SQL Programming, query optimization and performance tuning.
• Proficient in using SQL Profiler, creating Execution Plan, Performance Monitor and DBCC Commands.
• Thorough understanding and practice on different phases of SDLC in different projects
• Strong RDBMs knowledge using SQL Server, Oracle by TOAD
• Experienced as programmer using VB, PB, PL/SQL, JAVA, XML,VBA, ANT script
• Call center solution consultant experience in Edify IVR , CTI and Helpdesk integration
• Industrial practice on Cosmo, Scope, Greenplum and knowledge of Hadoop, Hive and mapreduce structure and hierarchy of big data
• Experienced using IBM mainframe/zOS, TSO, JCL, Adreport, Mocean, ASP.net, Apropos, Remedy, Nuance, Genesys

Technical Skills:

MS SQL Server 2012/2008 R2/2008/2005/2000/7.0, Analysis Services SSAS , MS SQL Server Integration Service SSIS , MS SQL Reporting Services SSRS , Microsoft Access 2007/2003/8.0, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Erwin Data Modeler 4.2/4.1/4.0, VB6, Microsoft Products MS Word, MS Excel, VSS, MS Access, MS Powerpoint, T-SQL, PL-SQL, HTML, XML, Crystal Reports 8.5, MS Visio 2003, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

BI Data Specialist and Report Developer Confidential

• Tools and platforms: SSIS, SSRS, SQLserver, Greenplum, Cosmo, Scope, Adreport, MoCean
• Confidential communication service provider and well known for its telecommunication software with the same name Skype. It provides video calls, IM on multiple operation systems and devices including traditional classic desktop client and mobile applications. This project is to integrate different data set of various formats: csv, data warehouse and enterprise data platforms, streamline the process and provide professional report to aid business decision-making and gain business insight from the data
• Defined and obtained appropriate data for Ad-hoc analysis requests and perform analysis for data of non-structured format from multiple systems to provide insight on user behavior for business to scale possible marketing and sales opportunities
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Excellent report creation skills using Microsoft Reporting Services SSRS . Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data Wrote queries to generate reports for analysis of data Used table control, matrix control to create cross tab reports handled sub reports and defined query for generating drill down reports in SSRS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQLServer Agent job.
• Worked with development teams in the design of physical databases and in modification.
• Created and Designed Data Source and Data Source Views Using SQLServer Analysis Services 2008R2 SSAS .
• Created and Configured OLAP Cubes Star Schema and Snow flex Schema using SQLServer 2008R2 Analysis Services SSAS .Designed cubes with star schema using SQL Server Analysis Services SSAS .
• Using Aginity Workbench Explain SQL and make changes to the Netezza databases to improve performance
• Designed and developed visualization and analyses in Tableau.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services SSAS .
• Integrated various data source to provide business user data solution to support business by complete view of user impressions used by management to make decisions without introduced errors and with pre-cautiousness on data restatement
• Created and maintained reports, report templates, QA/QC processes for field sales team with improved delivery trend visibility and early detection for bugs and errors in delivery
• Leveraged available BI toolsets, data platforms to develop and deliver BI dashboards and datasets on-time to stakeholders regularly
• Optimized process of work flow by reducing merging steps, paralleling activities, efficient time management, programmed business rules to improve the productivity
• Analyzed the user segmentations based on consumer dataset on virtual clusters with various classification for better online ads targeting

Environment: MS SQL Server 2008R2, SQL Server SSAS/SSRS/SSIS, Netezza MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, Tableau

, ASP.NET, C , ETL, Enterprise Edition, OLAP.

Confidential

BI Support Analyst/Business Analyst

• Tools and platforms: SAP BEX, BW/BI, BPC, SAS forecasting, BO webi, Visio, IBM Mainframe zOS, TSO, SQL, SAS base/Enterprise Guide, VBA, Access, Excel, TOAD, HP Quality Center
• CP Rail is one of the oldest railways in North America it provides coast to coast freight train shipping service for the products to support lives of the residents along its network. The projects are creation and reporting of finance statements, operating statistics for both internal and regulatory bodies
• Identified, developed specifications of technology enhancements to a variety of applications, adhering to IT processes and change management guidelines to reduce budget forecasting by 30 . Verified variety of short term projects/initiatives using standardized methodology to maintain or improve business ability to do reporting within budget scope
• Overviewed monthly outlook cycle IT and customer activities to ensure that business needs are met and that IT can deliver quality reports and matrix within specified/realistic timelines. Ensured that the internal partners/stakeholders are in consensus and monitored change request process following enterprise policy
• Analyzed required data sources and the health of data as it pertains to a reporting solution
• Ensured that business rules are correctly applied and that any changes to current logic facilitate the consistent and timely reporting of accurate data for both plan and actual
• Resolved systemic problems and ensured completion of root cause analysis with cross functional teams. Audited process compliance. Rolled out test plan, test cases and executed test script to meet business requirements. Facilitated and monitored vendor performance to be more efficient for the cash flow project to line up with the reporting condition changes and configuration refractor
• Optimized work flow and data processing to improve the data compilation and reporting efficiency by 90
• Identified possible opportunities to streamline work performance by integrating new software package and using new features to replace the expired legacy middle ware to be sustainable. Prototyped solutions to meet business requirement change and operational KPI reassignment
• Participated in the analysis and definition of functional stats reporting requirement to meet business goal .Supported business users and developers in the creations of reports

Application Support Analyst Confidential

• Tools and platforms: Asp.net, XML, HP service manager, Astiva, Capterise, InfraRed
• Shaw, the leading entertainment and telecommunication company in Canada, provides cable services of internet, phone and TV content to millions of customers. The project scope includes enterprise application analysis on both their functions, performance and upgrading
• Analyzed the work flow engine and gathered user requirement
• Performed trouble shooting and upgraded project time sheet management system
• Executed change request with enterprise SOX compliance
• Documented system analysis
• Worked with other teams to solve system issues

Technical Engineer Confidential

• Tools and platforms: Oracle OC4J, ANT script, WSDL, C , J2EE, Intellestore Hierarchy Storage System, Java, Toplink
• OOCL is one of the world's largest integrated international container transportation, logistics and terminal companies
• Integrated web service framework with logistic project
• Evaluated the functions and system performance of archival storage system

System Engineer Confidential

• Tools and platforms: Edify IVR, Apropos, Remedy, SQL Server, Genesys, Nuance
• ITApps focuses on providing end to end hardware and software customer service center solutions to its banking, telecommunication and utility customers
• Supervised and optimized contact center system performance
• Built demo and prove of concept systems
• Configured system integration
• Provided post sale consulting service

Software Engineer Confidential

• Tools and platforms: VB, PB, Oracle PL/SQL, Crystal report
• Centell is a software company providing information management system to telecommunication companies.
• Provided suggestions on data model as well as data maintenance
• Analyzed objectives and problems specified by system designer
• Built, tested and modified relevant program modules