Vikas A Email & Phone Number

Portland, Oregon Area

• Sourcing, Data modeling, ETL, Loading, Processing, Cube Development, Data visualization, Auditing, Data validation, data mining.• Designed ETL architecture using SSIS for overall data transfer from the source server (CSV, Excel, Web Api, Oracle, SFTP) to the Enterprise Data Warehouse.• Responsible for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations. • Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.• Redesigning and enhancing existing packages and jobs.• Evaluating and preparing POC’s for the new technical advancements in area of database and Business Intelligence.• Created and applied business rules in MDS to reflect the business logic in different entities.• Designed and built Tabular model using SQL Server Analysis Services (SSAS) with dimensions and built daily partitions on fact tables.• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with DAX, developing reports using DAX and T-SQL.• Writing complex DAX queries to create required calculated columns and measures, named set, advanced KPI'S.• Implemented Row Level security in SSAS tabular cube and specified User level of access through DAX queries.

Duluth, Minnesota Area

• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.• Created SSIS Packages to integrate data coming from Text files and Excel files.• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.• Created various InfoPath forms and published them to SharePoint sites for Business Analysts to provide their weekly/monthly mappings of various products based on clusters and regions.• Created SharePoint lists as data feeds for the InfoPath forms.• Created a BI Semantic Model connection in SharePoint data connection library so that individual users can access the SSAS model using the connection and create ad hoc reports. • Implemented Drill through capabilities by installing BIDS Helper and making required code changes to the cube project.• Interacted with Pyramid Analytics product development team to discuss product bugs and suggest new features that can be implemented.

Greater Detroit Area

• Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL stored procedures, user defined functions (UDFs) for data analysis.• Developed complex web forms using ASP.Net server-side scripting with C#, .NET Framework 3.5• Involved in developing ASP Web Pages using VBScript.• Web form’s input validation using the ASP.Net Input Validation Controls and dynamic features using Ajax, JavaScript and MS Enterprise Library.• Created ASP.NET User Controls and custom controls for code reusability and to reduce the complexity of user interface design.• Design and implementation of Security Model, Policies and Procedures.• Performing query plans and making sure every query is using appropriate useful Indexes• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.• Used ADO.NET Entity Framework for access to SQL data sources.• Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration.• Loaded flat and Excel files into Access database and developed SQL scripts to create desired queries (views) for data analysis.• Created package with different data sources (SQL Server, Oracle, Flat Files, Excel files, etc.) and loaded the data into target tables by performing various kinds of transformations using SQL Server Integration Services (SSIS).• Utilized various data flow transformations like lookup, row count, data conversion, Merge Join, multicast, conditional split, sort, aggregate to migrate data between different data sources as per business requirements.• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.

Kansas City, Missouri Area

• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.• Utilized VB Scripting, C#, WCF, Web Forms for developing the codes • Responsible for creating the .NET builds and making sure the builds are migrated all the way up to the Production Environment.• Web form’s input validation using the ASP.Net Input Validation Controls and dynamic features using Ajax, JavaScript and MS Enterprise Library.• Designed the UI for some modules of the application using ASP.NET controls.• Used SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.• Enhancing and deploying the SSIS packages from development server to production server.• Scheduled SQL jobs to run SSIS packages on a daily, weekly, monthly basis using MS SQL Server Integration Services (SSIS). • Created Excel including pivot tables, macros, and lookup functions to format a data set from the various SQL sources.• Created complex stored procedures, triggers and user defined functions using joins to apply business rules to data imported using SSIS packages.• Deployed SSIS packages from Dev/Staging/Prod using SQL Server table configurations. • Implemented logging and error handling in SSIS using Event Handlers. • Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Hercules

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle databases).• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.• Used For-Each Loop Container, Sequence Container, Script task, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.• Created and modified various Stored Procedures used in the application using T-SQL.• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008/2008R2 (SSAS).• Used scripts and variables, email notifications for ETL process using Data Integrator.• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.• Designed Cubes with Star Schema using SQL Server Analysis Services 2008/2008R2 (SSAS). • Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Hyderabad Area, India

• Designing and developing SQL Server 2005 Database, Tables, Indexes, Stored procedures, Views, Triggers.• Design/Build Extract Transform Load procedures in SQL Server Integration Services• Worked on creating SSIS packages to upgrade SQL Server 2005• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).• Designed and created Report templates, bar graphs and pie charts based on the financial data.• Developed several types of complex reports like Drill Down, Drill through, cross tab reports.• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.• Designed the packages to extract data from SQL databases, flat files and loaded into Oracle database.• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.• Developed user defined financial reports to provide on demand financial data analysis using SSRS• Performed data conversions from flat files into a normalized database structure.• Developed numerous ad-hoc reports using SSRS for day to day financial reporting• Installed and configured the components required to integrate SSRS with MOSS Enterprise Edition• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server