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.
• Worked in rapid Agile environment, in creating work items, bug fixes and estimation of tasks.
• 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/2008R 2/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:

Technology and Tools: MS SQL Server 2012/2008 R 2/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, Agile environment, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

BI Data Specialist and Report Developer

Confidential, Palo Alto, CA

Tools: and platforms: SSIS, SSRS, SQLserver, Greenplum, Cosmo, Scope, Adreport, MoCean

Responsibilities:

• 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.

BI Analyst

Confidential, Calgary, AB

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

Responsibilities:

• 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, Calgary, AB

Tools: and platforms: Asp.net, XML, HP service manager, Astiva, Capterise, InfraRed

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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