Candidates About

PROFESSIONAL SUMMARY

• Over 9 years of experience in all the phases of Development Life Cycle involving design, development and analysis and testing in various areas of .Net and database development.
• 1+ years of experience in Microsoft Power BI and 2+ years of experience in Tableau
• 2 years of work experience in working in big data technologies
• Strong development skills using ASP.Net, WCF, WPF, ADO.Net, WF, ASMX, LINQ, AJAX, CSS, Entity Framework using VS 2005, VS 2008, VS 2010 and VS 2012.
• Experience in writing Data Access Layers using ADO.net entity Frame Work and LINQ to SQL.
• Expertise in application development using ASP.NET MVC 3.0/4.0 Framework.
• Expertise in installing, developing and deploying on application/web servers such as IIS 5.0/IIS 6.0/IIS7.
• Fair amount of experience with scripting in PERL and Java script and statistical programming in R.
• Experience working on various Relational Database systems (Oracle, Sql Server, DB2) and Flat files.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers, Temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement. 
• Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Experience in developing ETL for supporting Data Extraction, transformations and loading using SSIS.
• Strong knowledge of .Net Framework 3.5, 3.0 and 2.0. Extensively used libraries for writing custom code when developing expressions in SSRS and SSIS.
• Strong experience in EDI onboarding domestic and international trading partners including FTP/SFTP, MQ, AS2 and VAN configurations  
• Strong experience in Master Data Services features including hierarchies, granular security, transactions, data versioning, and business rules.
• Extensive experience in map creation of ANSI X12, EDIFACT, XML and Flat File EDI transactions 
• Areas of Expertise: Development, testing, implementation and maintenance of EDI, ETL
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions using Erwin.
• Experienced in Developing SSAS Cubes and Deploying and Processing SSAS objects.
• Good knowledge on creating the MDX cubes, Designing, and Building the Dimensions and cubes with star schema.
• Good knowledge in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects. 
• Hands on experience with SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS) and Crystal Reports for report, generation, and integration in to .NET applications.
• Experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Experience in using Visual Source Safe (VSS), Clear Case, SVN and TFS for version controlling.
• Good knowledge on R-Code and SAS code used for data mining and data analysis as part of Big Data.
• Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

Education and Certifications

• Masters in Information Science and Technology from Missouri University of Science and Tech, Rolla.

TECHNICAL SKILLS

Dot Net Technologies:                                  AJAX, ASP.Net, ADO.Net, WCF, WPF, LINQ, ASMX.

Frameworks:                                                 ASP.Net MVC 3.0/4.0, Entity Framework, Agile Framework

BI Technology:                                              SSIS, SSAS, SSRS, Power Exchange, Pyramid Analytics

RDBMS:                                                               Oracle 11g/10g/9i, MS SQL Server 2016/2014/2012/2008/2005, DB2, MS Access

Languages:                                                          SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl, COBOL, DB2, SAS, R, HTML5, XML, WSDL, XSLT, CSS, JavaScript, Perl Scripting

Operating Systems:                                           UNIX (IBM AIX/HP-UX/Sun Solaris), Win XP/ NT/ Vista/7

Utilities/ Tools:                                                   TOAD, SQL* Loader, Visual Studio 2005/2008/2010/2012/2016, SOAP UI, Altova XML Spy - XSL/XML programming, Microsoft Power BI , Tableau.

Version Control:                                            VSS, TFS, GIT, SVN

PROFESSIONAL EXPERIENCE

MWI Animal Health, Boise, ID                                                                               January 2017 - Present

Role:   BI Consultant

Responsibilities: 

• Deployed SSIS packages across development, test and production environments using project deployment model 
•  Improved the performance of the slow running queries by using performance tuning. 
• Created SSIS Packages by using different kinds of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast). 
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping. 
• Involved in requirement gathering and IT testing 
• Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs. Also to trigger emails about the failure using Email task.
• Worked in creating stored procedures, views, materialized Views. 
• Used task factory components and transformation like Update batch transformation, Null Handler Transformation, Surrogate Key Transformation, Advanced Email and SMS Task in SSIS packages 
• Designed OLAP cubes with star schema and multiple partitions using SSAS. 
• Created reports from cube using MDX. 
• Created Charts, Tabular, Matrix, Drill Down, Drill Through, Cross Tab reports using Tableau. 
• Developed report specifications, created and modified reports using Tableau 
• Deployed and scheduled Reports using SQL Server Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status 
• Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application. 
• Experienced in agile environments
• Trained teammates in using JIRA/Confluence. 
• Experienced customizing JIRA projects with various schemas, complex workflows, screen schemes, permission schemes, and notification scheme

Environment: SQL Server 2016, SSIS, SSRS, SSAS, Tableau, PLSQL, Visual Studio, TFS 2016, Jira, Confluence

CareFirst BlueCross BlueShield, Baltimore, MD                                                  August 14 – December 2016

Role:   BI Consultant

Responsibilities: 

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers. 
• Analyze EDI Remittance and Revenue Cycle Process to make improve business process and reduce accounts receivables.
• Strong experience in Master Data Services features including hierarchies, granular security, transactions, data versioning, and business rules.
• Support and troubleshoot GE Centricity 5.1,5,3 BAR applications. BAR and EDI Interfaces for EDI (270, 271, 834, 835,) Analysis Hyland Onsite EDI Payment interface.
• 834 EDI Testing includes the member enrollment, termination, Member changes, member void and member reinstatement via 834 file. 
• Wellness testing is an UI based testing. The members who has active medical product in CareFirst are eligible to opt Wellness program. Two separate vendors needed to be tested with different package options. 
• Facets upgrade testing involves the entire application testing of Healthy blue, 834 EDI, E, and B job after the Facets upgrade. Need to validate the existing features remain same. 
• E & B job testing includes a list of jobs testing in order to validate whether the list of process are working as expected.
•  Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot). 
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages. 
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations. 
• Experience in using several control flow tasks sequence container,
  • For Loop, For Each Loop, ActiveX Script Task, CDC task in SSIS 2012, data flow task, Bulk Insert Task, Execute SQL, File System Task, FTP Task and Script Task, Several Data Flow Transformations Look Up, Cache transformation, Checksum transformation, Conditional Split, Derived Column, Row Count, Script Component, Merge Join and Union All.
• Cleanse Data while loading and write logic to perform different kinds of transformations like Derived Column, Conditional Split, Lookup, Data Conversion, SCD's, CDC (Change Data Capture) etc., 
• Extensively worked on CDC (Change Data Capture) at the database level and used control flow items SSIS 2012 CDC(Change Data Capture) task, CDC Split task into INSERT, DELETE and UPDATE in SSIS 2012. 
• Participate in modifications of batch and on-line programs, jobs, procs for multiple maintenance and enhancement projects to improve on-line and batch functions of the system. 
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle. 
• Created BioXL reports using Pyramid Analytics.
• Created Dashboards using BioPoint in Pyramid Analytics.
• Worked with Pyramid Analytics team for product version updates.
• Worked on Maintenance and migration on reports between different Pyramid environments (dev,test,prod).
• Developed complex Stored Procedures and views to generate various Drill-through reports, ad-hoc SQL scripts, parameterized reports and linked reports using SSRS. 
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas. 
• Maintain existing EDI processes by creating and reviewing daily processing reports. 
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008. 
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose. 
• Identified the dimension, fact tables and designed the data warehouse using star schema. 
• Developed Multidimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS). 
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches. 
• Developed the Sqoop scripts in order to make the interaction between Pig and MySQL Database
• Created calculated measures and dimension members using multi-dimensional expression (MDX). 
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports. 
• Expertise in writing Multi-Dimensional Expressions (MDX) to create calculated measures and calculated members (dynamic) in time dimensions. Implement role base security based security using allowed set/ denied, set in MDX and Custom data for windows/web-based users. 
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges. 
• Created Views to reduce database complexities for the end users. 
• Developed MapReduce jobs in java for data cleaning and preprocessing. 
• Collecting data from various source systems. 
• Segregate the data into Structured & Unstructured data 
• Took active involvement in analysis, design, coding and testing batch and online programs, creation of batch job streams and schedules for processing multiple transactions. Created many Report pages with different report views using Power BI 
• Created Dashboards using Power BI and deployed into Office 365 
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments. 
• Practical understanding of the Data-modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. 
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries. 
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases. 

Environment: SQL, PL/SQL, T-SQL, Vb.net , C#, Map Reduce, Hive, Pig, Sqoop, Microsoft BI (SSIS, SSAS and SSRS), Oracle 11g/10g, MS SQL Server 2012/2008, SVN, Sql Developer, Visual Studio 2008

Missouri University of Science and Technology, Rolla, MO                                                     August 13 – July 14

Role:  Sql developer/ ETL Developer

Responsibilities: 

• Collecting requirements from business users and transforming them into logical and physical database designs. 
• Create and maintain clearly written technical, user, and system documentation. 
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity. 
• Created complex queries, which involve usage of Joins, Sub-queries, Functions, Temporary tables etc. 
• Involved in Performance tuning and Query Optimization of Stored Procedures and queries using execution plan and profiler. 
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables. 
• Working with complex SQL, Stored Procedures, Triggers, cursors, and packages in very large databases from various servers. 
• Designed SSRS 2008R2 reports with Cascading and Multi-valued Parameters 
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources. 
• Involved in using transformations for loading data from source to destination.
• Designing and implementing a variety of SSRS reports such as Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements. 
• Creating reports for users in different departments using web-enabled reporting by SQL server reporting services and Share Point. 
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data. 
• Design report models based on users requirements, explain and train users to use report builder to generate their own personalized reports. 
• Created tables, stored procedures in SQL for data manipulation and retrieval, Database Modification using SQL, PL/SQL, Stored procedures, triggers, Views in MS SQL.
• Written Stored Procedures functions and views to retrieve the data.
• Created User Interface using ASP.Net.
• Involved in integration testing the Business Logic layer and Data Access layer.
• Used technologies like C#, ADO.Net, JavaScript, HTML, XML and Tiles for Presentation tier

Environment: SQL, PL/SQL, T-SQL, Vb.net , C#, Microsoft BI (SSIS, SSAS and SSRS), Oracle 11g/10g, MS SQL Server 2012/2008, SVN, Sql Developer, Visual Studio 2008

Telstra, Melbourne, Australia                                                                                                November 11 – July 13

Role:  Sql developer/ ETL Developer

Responsibilities: 

• Created PL/SQL scripts for processing data, applying business rules and loading them onto the target for reporting on the front end. 
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, remove the junk characters from the file before loading them into the base tables. 
• Modified several UNIX shell Scripts according to the changing needs of the project and client requirements. 
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to perform DDL operations for new enhancement in the application using TOAD. 
• Created indexes on the tables for faster retrieval of the data by eliminating the full table scans. 
• Created UNIX scripts calling DB objects for invoking SQL*Loader to load data from flat files obtained from various sources every day. 
• Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL Developer. 
• Used SQL Server Analysis Services (SSAS) to create cubes with various measures and dimensions for report generation. 
• Developed Aggregations, partitions based on calendar quarter for cube to improve running performance and business needs. 
• Involved in developing initial load/incremental load ETL Packages, Staging Data ETL Packages, Package Test Script, and Report requirements/Unit Testing Document and synchronized these packages/ Document into Team Foundation Server (TFS). 
• Developed Store Procedure in T-SQL to replace existing SSIS packages in ETL process and gained better Performance. 
• Involved in creating Jobs, SQL Mail Agent Alerts and Schedule SSIS Packages. 
• Deployed and Configured ETL Packages and coordinated with broad Database Administration team to schedule the package in SQL server agent. 
• Partitioned the fact tables to enhance the performance. 
• Created records, tables, collections (nested tables and arrays) for improving Query performance. 
• Performed performance tuning using EXPLAIN PLAN, SQL*TRACE and AUTOTRACE. 
• Extensively involved in using hints to direct the optimizer to choose an optimum query for execution plan. 
• Used Bulk Collection for better performance and easy retrieval of data. 
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger. 
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. 
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. 
• Coordinated with the front-end design team to provide them with the necessary Ref cursors and External tables and the necessary insight into the data. 
• Participated in change and code reviews to understand the needs of the components. 
• Enhanced existing Oracle forms & reports as per change request. 
• Developed UNIX Shell scripts to automate repetitive database processes. 
• Performance tuning of Oracle Databases and User applications. 
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation. 
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions. 
• Upgraded Oracle 9i to 10g software in different environments for latest features and tested databases. 
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs. 

Environment: MS SQL SERVER 2012, SQL Server Integrations Services (SSIS), SQL Server Analysis Services (SSAS), Team Foundation Server (TFS), SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), T-SQL

Infosys, Hyderabad, India                                                                                                                         July 08– October 11

Role: Dot net Developer / Sql developer

Responsibilities:

• Involved in Full Life Cycle Development in Distributed Environment Using .Net and Entity framework.
• Responsible for developing and modifying the existing service layer based on the business requirements.
• Involved in designing & developing web-services using SOAP and WSDL.
• Involved in the Design, Coding, Testing and Implementation of an application (CONNECT). 
• Involved in the design of the Database and developed Stored Procedures to create it using SQL Server 2005. 
• Implemented input validation using the ASP.NET input Validation Controls. 
• Validating the Web pages with client side and Server side scripts using C#
• Used Cascading Style Sheets for a unified look of the application. 
• Performed validations on Web Forms using .NET Validation Controls and JavaScript. 
• Created tables, stored procedures in SQL for data manipulation and retrieval, Database Modification using SQL, PL/SQL, Stored procedures, triggers, Views in MS SQL.
• Written Stored Procedures functions and views to retrieve the data.
• Created User Interface using ASP.Net.
• Involved in integration testing the Business Logic layer and Data Access layer.
• Used technologies like C#, ADO.Net, JavaScript, HTML, XML and Tiles for Presentation tier
• Used Visual Studio 2008 to build and test around build scripts.
• VSS tool used for version control of code and project documents.
• Responsible to mentor/work with team members to make sure the standards and guidelines are followed and delivery of tasks in time.
• Automating the daily health check process on the production servers.
• Interaction with customers for issue resolving purpose.
• Perform test set-ups to run regression suite.
• Helping the team of 13 by giving KT’s to understand the structure of the existing and upcoming modules involved in the major transformation.
• Customizing the 3rd party software tool (CLICK Software).
• Supporting the application in both L3 (current application) and L4 (3rd party software) levels.
• Supporting the application in attending WAR room (Client Australia location) during CAT phase, Tracking the defects and resolving them within the given timelines and test the release builds.
• Reviewing the test cases for all the major cycles.
• Make the test suite usable by external teams.
• Resolving issues and participating in defect prevention activities.
• Maintaining quality of deliverables.
• Played a key role in resolving the issues related to the third party software, internal to Telstra.
• Interacting with CLIENT’s for defect tracking and resolution, Interface specification documents.
• Preparing design documents and submitting to client within timelines.
• Organized KT sessions to share a better knowledge on the application.
• Customizing the code to resolve the issues in the 3rd party software used in CONNECT application. Customization also includes working on new technologies like Silverlight.
• Resolved many critical issues working on 2 applications simultaneously which resulted in less number of incidents coming to the application queue.
• Built a repository in SharePoint for the team to have all documents related to projects stored and helped team to access all the recurring issues need to be documented.

Environment: VB6, VB.NET and ASP.NET with AJAX, ORACLE, 3^rd Party Software- CLICK, Silverlight 2.0, HPQC, Perl Scripting, SharePoint