SUMMARY

• Over 10+ years of experience in Software Development Life Cycle (SDLC), like Requirement Analysis, Design, Development, Testing, and Implementation
• Over 6+ years of experience in Microsoft SQL Server Business Intelligence Development (SSIS, SSRS, SSAS) in Production, Development & Staging Environments, along with around 3 years of data visualization using Power BI, Tableau
• Over 3+ years of experience in Golang. Excellent coding and problem - solving skills with ability to work as Developer
• Proficient with REST API’s, Web Applications and microservices
• Good experience with Golang drivers to perform operations such as CRUD and writing complex queries with SQL Server, Pl/SQL, Mongodb
• Worked on communication protocol like gRPC using Protocol buffer (Protobuf)
• Hands on experience with continuous integration and automation using Jenkins
• Hands on experience with version control tools such as SVN and GitHub
• Experience with container-based deployment using Docker, working with Docker images, Docker-registries and Kubernetes
• Good hands-on experience in designing, developing, implementing, and deploying applications on cloud using AWS, Azure
• Strong Communication & Management skills with Excellent Role-playing capabilities
• Expertise experience in design, development and implementation of BI Solutions (ETL & Reporting & Analysis services) using SSIS, SSRS, SSAS, Microsoft SQL Server 2016/2012/ 2008 R2/ 2008/2005, T-SQL, MDX, Power View, Power Pivot, Power BI, Tableau
• Vast experience in creating complex SSIS packages, SSRS reports, Building SSAS Cubes, creating SQL Stored procedures, User defined functions, writing complex MDX
• Expertise in Designing, Development and Deployment of Reports (SSRS) for the End-User requests using Web Interface & SSRS
• Expertise in Performance tuning, Optimization by using SQL Profiler
• Designed, developed, implemented, and supported Power BI, Tableau dashboards
• Expertise in writing complex DAX functions in Power BI and Power Pivot, created Dax Queries to generated computed columns in Power BI
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS) using SQL SSRS 2005/2008 / 2016
• Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security
• Experience in the integration of SSRS Reports using various web parts into Dashboards and Sharepoint
• Excellent T-SQL programming skills in writing complex queries to Create and Update Database objects such as Tables, Views, Stored procedures, Triggers and User-Defined Functions
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas

TECHNICAL SKILLS

Languages: Golanguage

Scripting: Python and UNIX Shell Scripting

RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, Oracle 10g

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS), Power BI, Tableau

Analysis Services: SQL Server Analysis Services (SSAS)

Data modeling Tools: MS Visio, Rational Rose

Web Designing: HTML, CSS

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio

PROFESSIONAL EXPERIENCE

Confidential

Golang Developer

Responsibilities:

• Designing & developing RESTful API endpoints using Go programming language
• Written a lot of middleware code using Alice library for chaining using decorator patterns
• Written authorization middleware layer in Go
• Worked on a sharding algorithm in Go to distribute the load between the available backend server instances
• Worked on creating multiple microservices in Go interacting with each other using RESTful endpoints, using JSON as data exchange format, and Protobuf for internal communication
• Worked with various Cloud Service Provider API (AWS, GCP, Predix) to integrate them with our microservices
• Worked on migration projects, rewriting existing PHP, Java, Python applications into Go micro services, piece by piece
• Written go code and deployed to AWS lambda function to make use of the serverless features provided by AWS
• Written caching layer to save the hot data in Redis to improve performance
• Worked with Cassandra service API to persist the time series data
• Created database SQL scripts to interact with the SQL databases like Postgres, MySQL database to store the intermediate and persistent metrics data
• Written Go code to read and write data to various NoSQL databases like Redis, MongoDB
• Written data migration scripts in Go to move legacy data into the new database systems
• Written dockerfile to prepare the docker image for the golang microservice
• Responsible for setting up Jenkins CI/CD pipelines for all the Go repos. and written Jenkinsfile scripts to automate the build and deployment on commit
• Written shell scripts to deploy services to cloud
• Contributed the reusable code to the common shared library
• Involved in Test Driven Development. Written automated unit test functions in golang to cover the API code

Confidential, Madison, WI

Golang Developer

Responsibilities:

• Gathering requirements from the different departments of the organization
• Involved in implementation of procedures for gathering the requirements from clients for solution demonstrations
• Developed new RESTful API services that work as a middleware between our application and third-party APIs that we will used using Golang
• Using GO, developed a microservice for reading large volume of data(millions) from PostgreSQL database
• Experience writing data APIs and multi-server applications to meet product needs using Golang
• Experience in writing the HTTP RESTful Web services and SOAP API's in Golang
• Designed configurable REST APIs on demand using Go. Worked on numerous go frameworks like gin, revel, beego
• Integrated Jenkins to git where the build triggers automatically when we push a pull request for CI/CD
• Worked on CI/CD tool Jenkins to automate the build process from version control tool into testing and production environment
• Experienced in using Go technologies on UNIX and Linux platforms
• Good understanding of Design Patterns, Multithreading and GO containers. Well versed in using Channels and goroutines
• Containerized applications using Docker: Created docker files, built docker images for microservices to run on Kubernetes platform
• Created docker image for microservices files to orchestrate applications using Kubernetes
• Proficiency in multiple databases like MongoDB, Cassandra, MySQL
• Produced and Consumed Restful Web Services using Postman Rest Client, Swagger UI, to interact with different applications from third-party tools
• Worked with Business users and stake holder for gathering business requirements and Convert the Business Requirements into User Stories using JIRA

Confidential

Golang Developer

Responsibilities:

• Involved in implementation of procedures for gathering the requirements from clients for solution demonstrations
• Introduced to Golang while working within a project
• Wrote microservices using Golang
• Build Restful API by building Node JS Server in the back-end to handle requests sent from the front-end jQuery Ajax calls
• Experience in developing User Interfaces using ASP.NET, AJAX, HTML, CSS, JavaScript, jQuery
• Strong working knowledge of Database Programming using SQL and Stored Procedures
• Developed a RESTful web API using Spring Boot. Spring Data is used to communicate with the Mongo DB
• Developed Web Services SOAP/HTTP, SOAP/JMS, and SMTP using SOA technologies such as SOAP, WSDL
• Developed of web modules and middleware components using AWS and spring integration
• Developed server-side software modules and client-side user interface components deployed entirely in Compute Cloud of Amazon Web Services
• Used Continuous delivery/ Continuous Integration tools Docker, Jenkins to deploy our application to AWS
• Strong Experiences in creating and consuming XML Web Services and having knowledge of SOAP, soap header and soap exception
• Developed and maintained stored procedures, User Defined Functions, Indexes, Views, Tables, and Relationships on SQL Server
• Developed RESTFUL/WCF Web services, APIs, and other back end components
• Involved in Unit Testing and Integration testing in development environment and ensuring application is according to specifications

Confidential

Senior Database/BI Analyst

Responsibilities:

• Designed the architecture of Integration Services (SSIS) and Reporting Services (SSRS)
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Designed SSIS Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Designed and developed ETL using SSIS, to bring data from heterogenous systems into staging server
• Applied medium to complex level ETL transformations
• Developed reports using SSRS, Power BI, Tableau, and created High Level Dashboards
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Developed various 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