PROFILE SUMMARY:

A Technically Adept and Confident Programmer with Comprehensive Problem solving abilities having 15+ substantial years of experience in design, development and testing of applications with large data sets in a distributed system. using COSMOS SQL Server, SQL Spatial, SSIS, SSRS,HDinsight, Hive, C#, VB.NET, SCOPE, ArcGIS. Worked in Software Design Engineerrole and Business Intelligence Analyst

TECHNICAL SKILLS:

Experience/ Conversant/ Familiar

SQL Server 2014

Integration Services ( SSIS)

Reporting Services (SSRS)

Analysis Services (SSAS)

SQL Server Administration

C#, VB.net

PowerShell scripting

HDInsight, Hive

Cosmos

SCOPE

Excel - PivotTable

Octopus

SharePoint Administration

Geospatial technologies (ArcGIS FMEObjects)

AREA OF EXPERTISE:

Database Technologies, Businessintelligence

PROFESSIONAL EXPERIENCE:

Confidential

Languages/ Technologies/Tools: SQL Server 2015, MSBI, SSAS, SSIS, SSRS, C#, PowerShell, ETL, Excel-PivotTable, SQL server Administration and CosmosScope

Software Design Engineer /BI Analyst

Responsibilities:

• Doing Adhoc data analysis by writing cosmos scripts, consolidating, filtering & analyzing data.
• Responsible for Analyzing the business requirements documents and solution design.
• Created Builds for pipeline runner and Installed Pipeline Runners, Automated Scope Scripts.
• Created COSMOS Scope Scripts as per the Ad-hoc Requirements.
• Worked on creating Budget Re-distributions, creating Actualized Forecasts at daily granularity to establish our revenue and Search targets.
• Created Batch Files to Download from Cosmos VC and use Bulk Control Protocol to dump data into SQL Server DB and automate the process.
• Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations
• Creating an end-to-end Pipelines using cosmos Scope and Store procedures.
• Experience in analyzing execution plan, managing indexes and troubleshooting.
• Developed and executed several optimized queries in SQL.
• Loading data from various sources such as flat files to SQL Server database using SSIS Package.
• Responsible for troubleshooting and problem solving of SQL development and creating back up plans.
• Participated in code review sessions with development and management team members
• Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures.

Confidential

Languages/ Technologies/Tools: SQL Server 2012, MSBI, SSIS, SSRS, Matlab, Hive, HDinsight, C#, ETL, Excel-PivotTable

Software Design Engineer

Responsibilities:

• Designed and developed the Weather application tools for research group.
• Developed data acquisition tools which pull the data from various sources.
• Ensure accuracy of data and representation of data.
• Generate Complex reports for Research team using SSRS and Matlab
• Ownership of Appex Weather Research database
• Optimization and Performance improvements to Data acquisition system.
• Ensuring product delivery as per quality standards
• Get Reference Metar stations into a usable table (a reference Metar is one where WDT provides an exact match Quad Key forecast by Lat/Lon
• Create scope script to validate Cosmos data.
• Code review and performance tuning.
• Coordinating with test team and help them to write test plans
• Ensuring the timely deliverables.
• Engage in cross team communication.

Confidential

Languages/ Technologies/Tools:SQL server 2012, T-SQL, Cosmos, C#, SSIS, SSRS, SSAS, SCOPE, ETL, Excel-PivotTable, Octopus, TFS, Source depot and Confidential Internal tools like BRT, ScopeCopy, CDL

Software Design Engineer

Responsibilities:

• Understanding current system architecture and recommend improvement areas.
• Migrating Confidential DW Pipeline from SQL Server database technologies to Cosmos
• Create scope script to validate Cosmos data.
• Develop complex T-SQL queries and design SSIS packages to load the data into warehouse
• Design, develop and Deploy SCOPE scripts which will run on COSMOS
• Generate Complex reports for marketing teams using SSRS, Excel pivot and Scheduling & Deploying the Reports.
• Implement Daily processing tests and business rules validations.
• Create stored Procedures, User defined functions, writing queries, creating tables and Views etc. that meet business needs.
• Perform data mining activities of gathering and compiling data to make a thorough analysis and to extract the relevant information
• Performance Tuning, indexing Query Optimization, Database consistency checks using DBCC utilities

Confidential

Languages/ Technologies/Tools: SQL server 2008 R2, SSIS, Metal and VSTF

Software Design Engineer

Responsibilities:

• Lead to a team of 3 offshore resources to work on this project
• Understand the existing subject areas, source systems, target system, jobs, deployment processes with minimal supervision
• Design ETL jobs for the DW team.
• Coordinated the development effort with offshore team
• Discover the source data that causes the problems downstream.
• Participated and conducted code reviews, unit and integration testing of the code.
• Analyzed the data models of the source & target systems to develop comprehensive mapping specifications.
• Involved in writing stored Procedures,User defined functions, writing queries, creating tables and Views

Confidential

Languages/ Technologies/Tools: SQL Server 2008, SSIS, SSRS,AMLs and VSTS

Software Design Engineer

Responsibilities:

• Coded the entire pipeline process for conversion of map data using SQL Server Spatial, Geospatial Technologies and c#
• Involved in writing stored Procedures,User defined functions, writing queries, creating tables and Views
• Providing Geospatial consultancy to Confidential
• Analyzing map data from different map data provider
• Design & Develop the plan for conversion of map data
• Completing the tasks as per Milestones and Scrums.
• Coordination with test team to help them write test plans.
• Had to extensively customized map data
• Develop a framework to take user generated content in the maps

Confidential

Languages/ Technologies/Tools: C#, ASP.Net, XML, FME Objects, SQL Server 2005

Project Lead

Responsibilities:

• Study of the specifications provided by client
• Regular interaction with users for requirements
• Designed User interfaces screens
• Involved in writing queries, stored Procedures and Views.
• Involved in coding and unit testing and test case automation.
• Involved in Deployment and presentation

Confidential

Languages/ Technologies/Tools: C#, ASP.Net, XML, FME Objects, Oracle 10g

Project Lead

Responsibilities:

• Participated in design, coding, implementation and maintenance study of the specifications provided by client
• Designed and Implemented code for key modules
• Written stored procedures and user defined functions
• Involved in Peer Review