SUMMARY:

• Over 12 years of experience in IT with hands - on software development experience in Data Analysis, Database Design/Redesign, Development, Data Modeling, Dimensional Modeling and Data Conversion on SQL Server in both OLTP & OLAP, and RDBMS & NoSQL environments.
• Over 1 year of experience in Go Programming Language (golang).
• Good experience writing web applications and RESTful APIs using Go Programming Language.
• Experience with Google appengine APIs and web application hosting on Appengine.
• Experience with writing unit test code in Go for the web applications.
• I have good understanding the core packages like http, templates.
• I have good knowledge of concepts of web programming like HTTP, REST
• Good experience with projects in Health Care Insurance, Finance, Telecom domain.
• Have end to end experience of product development from the requirements specification stage till acceptance testing and go-live.
• Also working on a Hadoop Big Data POC for the client, involving HBase, Hive, PIG.
• Involved in Designing databases and preparing technical design documents.
• Extensively worked on Microsoft SQL Server 2005/08 using TSQL Queries Stored Procedures, Functions, Indexes, Triggers, Dynamic SQL, Views, Error Handling.
• Proficient with reporting tools like Microsoft SQL Server Reporting Services, Actuate Reports, Seagate Crystal Reports, QlikView and ETL tools like SSIS, Informatica and Scribe.
• Have experience in developing various kinds of basic reports like Table, Matrix, Graph, Drilldown, parameterized, linked, drill-through, sub reports using SSRS.
• Have experience in developing complex interactive analysis reports using QlikView.
• Extracted, transformed and cleansed data using DTS, SSIS as well as in TSQL using bulk insert, BCP in/out.
• Developed SSIS ETL Packages using SCD, Merge, Lookup, derived column, data conversion transformations.
• Efficient in performance tuning complex T-SQL queries, stored procedures. Good experience in reading and understanding execution plans of T-SQL queries and fine tuning queries.
• Quick learner and always willing to learn new technologies and accept challenging assignments.
• Efficient in analyzing and solving the critical issues.
• Ability to work in a team environment as well as independently. Self-Initiator/ Self Starter.
• Techno savvy & always have appreciable thirst for knowledge.

TECHNICAL SKILLS:

Programming Languages: Go (golang), SQL, Assembly Languages, CCloud:Google AppEnginedata interchange formats:JSON, XML, Protocol Buffers

Scripting: VB Script, HTML, JavaScript

Data Technologies: SQL Server, MySQL, Hadoop, Pig, Hive, HBase,Google Datastore NoSQL, mongodb

Data Modeling tools: MS Visio, ERWin

Reporting Tools: SSRS, Actuate Reports, Crystal Reports QlikView

ETL Tools: SQL Server DTS, Scribe, SSIS, Informatica

CRM/ERP: MSCRM3.0, Sugar CRM, MS Dynamics AX.

Operating systems: MS DOS, Windows, Ubuntu, Mac OSGithub, SVN, SSAS

PROFESSIONAL EXPERIENCE:

Confidential, PA

Software Engineer

Responsibilities:

• Involved in understanding the existing API.
• Designing & developing the RESTful API endpoints using Go programming language.
• Worked on the distributed environment involving multiple copies of services running on various servers.
• Worked on the creating multiple services interacting with each other using RESTful endpoints.
• Writing automated unit test functions in golang to cover the API code.

Environment: Golang, GitLab, MySQL, Jenkins

Confidential

Application Designer and Go Lang Developer

Responsibilities:

• Involved setting up the project from scratch (from the stage of idea)
• Preparing the project mission and wiki documentation
• Developed the web application prototype using Go Language
• Written unit testing code in Go to test the functions.
• Deployed the project to Google Appengine.
• Currently expanding the prototype to scale and enhance the features and UI. and then planning to release the documents and Confidential . started adopting Google’s Material Design UI principles. the code currently lives

Environment: Go Lang, Google App Engine, Google Material Design UI, Github

Confidential, PA

Data Engineer

Responsibilities:

• Involved in discussing with the business counterparts to understand the existing SSRS reports in order to do the migration.
• Written the queries and developed reports that validate the data migration. These reports are widely used to QA the data migration.
• Involved in data warehouse changes to support the migration and also with enhancements.
• Involved in peer code reviews & technical design meetings.
• Written the SSIS package to process the SSAS cubes by pulling the data from the data warehouse..

Environment: SQL Server MSBI, SVN, MS CRM 2011, JIRA, Bamboo, Agile

Confidential, PA

ETL Lead

Responsibilities:

• Involved in client meetings to understand the business need behind the TSQL queries
• Participated in design discussions to make the decisions to drive the project in the environment that is always changing.
• Involved in team meetings to create the estimation for the tasks
• Worked on creation of the metadata model (based on the documented mapping document) to create automatic Visio diagram (for the data flow diagrams) by hacking the Visio’s Reverse engineering feature.
• Prepared the technical design document for the migration of the TSQL code to SSIS ETL.
• Involved in meeting and recommend alternative approaches like no-SQL databases and parallel processing to exponentially improve the performance of the ETL.
• Reviewed the team’s Code
• Involved in the process to draw the data flow lineage from the TSQL code.
• Integration tested the code. also involved in development activities
• Involved in development of SSIS Packages to load the data from the source systems into the warehouse
• Involved in analyzing long running SQL queries to improve the performance.
• Involved in optimizing the SQL queries to reduce data and code redundancy

Environment: SQL Server 2012, Visio, SSIS, Agile

Confidential, CA

Data Engineer

Responsibilities:

• Involved in setting up the environment
• Written PIG scripts to load data into Hadoop environment.
• Involved in benchmarking the performance with various volumes and combinations of test data.

Environment: Linux, Hadoop, PIG, Hive, HBase

Confidential, CA

Technical Lead

Responsibilities:

• Attending the regular meetings with clients to understand the requirements.
• Review the code written by team and making recommendations with respect to performance and standards.
• Provide technical guidance to the team.
• Work breakdown and identifying the resources.
• Meeting with team and preparing the design document based on the requirements.
• Responsible for the quality deliverables.
• Designed database as per the client requirements. Created tables and established the relations between the tables as per the database design.
• Designed the SSIS Packages to load the data from the source systems into the warehouse.
• Coordinated with the UI team to ensure proper integration of the code.
• Reengineered the legacy ETL process by designing the enhancements like; handling bad data & adding email notification (failure & success), making logging effective, improving the performance.
• Involved in creating Stored Procedures and Functions as per the Business requirements.
• Involved in creating SQL Patches and Code Changes to fulfill the business needs as the product grows.
• Extensively worked on Microsoft SQL Server 2008 using TSQL Queries Stored Procedures, Functions Indexes, Triggers, Dynamic SQL, Functions, and Views.
• Designed the SSIS Packages to load the data from the source systems into the warehouse.
• Migrated DTS packages to SSIS 2008.
• Involved in SQL Server 2005 migration. Designing a migration plan and testing the plan in local test environment.
• Involved in Data cleaning process. Creating SQL queries for identifying the bad and redundant data in the client database, merging useful information from the redundant data and cleaning the bad records.
• Coding and testing of Stored Procedures.
• Involved in peer code review.
• Involved in writing queries to pull the required data for the reports.
• Created various variety of reports using reporting tools like SSRS, Actuate, Crystal Reports
• Coding user defined functions, batch statements for adhoc requests like adding users, making adjustments to the user data.
• Maintaining database backup and recovering database in disaster scenario.
• Involved in analyzing, coding and testing of Stored Procedures.Involved in creating indexes, optimizing select statements.
• Programming microcontroller using Embedded C.
• Integration testing in lab.
• Field testing the electronic circuits.