Over 10 years of experience in IT and Telecom Industry; Microsoft BI (MSBI), Oracle, IBM and Informatica platforms; development of conceptual, logical, and physical data models; data profiling; data cleaning; data warehouse and OLAP concepts (Kimball, Inmon); dimensional modeling (star, snowflake, 3DNF); good understanding of canonical data models; extract, transform, and load (ETL) strategies; SSIS, SSAS, SSRS; T-SQL and report development; performance tuning; IBM Data Stage and Master Data Management (MDM); Writing QualityStage jobs for profiling and cleaning; Informatica ETL; UNIX and Windows Environment; Data Extraction from SAP ERP, Oracle, Terradata, Mainframe, Siebel CRM; Writing queries and developing cubes in SAP BW; Large systems integration; .NET development; analysis of business and technical requirements and mapping them to implementation strategies and design (SRS/SDS); deployment; documentation; support; project sizing, team management, onsite/offshore co-ordination

Independent BI Solution Designer / Architect @ I currently provide consulting services to the Data and Business Intelligence teams of leading Telecom Company in Canada. My services include providing conceptual solutions, software architecture designs, system requirements specifications (SRS), system design specifications (SDS), high level (HLD), low level designs (LLD), complex data analysis, desiging data warehouses and data marts, developing ETL and Reporting strategies, providing development support and operational support to various projects in the area of data integration, data warehousing, business intelligence, data analytics and reporting. I work with a slew of technologies that includes Microsoft BI Stack (SQL, SSIS, SSAS, SSRS), IBM Platforms (DataStage, QualityStage, MDM), Informatica ETL tools, Microstrategy, Analance and other reporting tools. I interact with business stakeholders and technology specialists, understand complicated business requirements and effectively translate them into workable technical specifications. I have hands-on development experience in various platforms to get my hands dirty if need be and fire fight complex situations. I am known for going above and beyond the call of duty to solve problems and deliver solutions on time. From March 2015 to Present (10 months) Data Architect / Technical Lead @ • Lead data architect and technical prime for over 5 major data warehousing and reporting projects • Responsible for designing and developing data models, data marts • Developing Canonical data models for integration of multiple systems • Orchestrate data profiling and cleaning strategies • Ensure data quality and governance • Requirements gathering • Responsible for System Requirements and Design specifications • Lead the developers in onsite for ETL and Report development • Advanced SQL development • Data Extraction from SAP tables, queries and cubes • Development of SAP queries and cubes • Data Extraction from Mainframe systems using JCL jobs • Designing, Developing and Deploying DataStage ETL jobs in UNIX environments • Loading data into IBM MDM Data Models through DataStage and Web Services • Developing QualityStage jobs for data cleansing and deploying in ISD to be available as Web Services • Designing, Developing and Deploying SSIS ETL jobs in Windows SQL Server environments • Deployment of reports to SharePoint Servers • Excel Web Services • Maintenance and Monitoring of Large Production Systems – High Available, Load Balanced • Workflow automation using schedulers like SQL Server Agent, Rundeck for UNIX, etc • Co-ordinate with offshore development leads • Oversee deployment activities • Conduct code reviews and performance tuning • Supporting critical reports for executives and customers of Bell • Support marketing activities in North America by showcasing the product and reporting capabilities (Provide Proof of concepts and demos to various TELCO and other industries executives/decision makers) • Report to Project Manager with project status and development activities • Provide sizing, timelines and costing estimates for typical BI projects From March 2011 to March 2015 (4 years 1 month) Toronto, Canada AreaETL and BI Programmer @ • Been a key resource for entire data development life cycle for over 10 reporting projects • Play a vital role in data warehouse designing • Perform Requirements analysis with BAs and business users • Dimensional modeling using star and snowflake schemas • Design and develop ETL jobs using SSIS – connect to various systems (CRM, ERP, Ad-hoc etc) • Create and Process OLAP cubes using SSAS • Design and develop SSRS and Excel reports – Scorecards, Dashboards, KPIs and Tabular reports • Code synching • Environment migration – author build books, deployment to UAT and Production • Provide support for critical jobs and reports – monitor jobs on a daily basis • Documentation • Train junior resources • Data Quality Assurance From March 2008 to February 2011 (3 years) Product Developer @ • One of the senior programmers in the development of a BI tool called Analance • Technical evaluation of relevant products in the market and feature evaluation • Identification of appropriate technologies and supporting tools required • Prepare all UML diagrams - Sequence, Database, Class and Use Case diagrams • Development and Unit Testing of the tool - OLAP Reports module • Packaging and Release • Software used: ASP.NET, C#, Java Script, HTML, XMLA, SQL Server From March 2007 to February 2008 (1 year) Senior Application Developer @ • Design, code and test new web software applications • Enhance existing systems by analyzing business objectives, preparing a design document identifying areas for modification and improvement • Maintain existing software systems by identifying and correcting software defects • Develop stored procedures to perform back end operations • Investigate and develop skills in new technologies • Create technical specifications and test plans • Create new and extend existing operational documentation • Lead/mentor junior developers and share knowledge • Software used: ASP.NET, C#, SQL Server, HTML, CSS, Java Script From March 2006 to February 2007 (1 year) Junior Application Developer for Bell Canada @ • Learn .NET technologies • Create prototypes and models for design and testing • Design, develop and test specific modules • Write SQL queries and stored procedures • Prepare unit test cases and perform integration testing • Create new and extend existing operational documentation • Software used: ASP.NET, C#, SQL Server, HTML, CSS, Java Script From March 2005 to February 2006 (1 year)

Bachelor of Engineering (B.E.), Computer Science @ Hindustan College of Engineering, University of Madras, Chennai, India From 2000 to 2004 Higher Secondary @ Kaligi Ranganathan Montford Matriculation Higher Secondary School, Perambur, Chennai, India From 1998 to 2000 Senior Secondary Leaving Certificate (SSLC) @ Sri Venkateshwara Matric Higher Secondary School, Tiruvallur, Tamil Nadu, India From 1988 to 1998 Vengatesh Parasuraman is skilled in: Data Warehousing, ETL, Business Intelligence, Microsoft SQL Server, .NET, OLAP, SSIS, SSRS, SQL, C#, Web Services, Teradata, ASP.NET, VB.NET, Master Data Management