SUMMARY

• Over 8+ years of IT experience as Data warehousing (RDBMS), ETL and Reporting Developer (SSIS, SSRS, SSAS, and Power BI), AWS Architect & Developer/Administrator and VSTS Build and Release.
• In - depth knowledge in AWS cloud services like EC2, S3, RDS, VPC, Cloud Formation, Cloud Front, Route53, Cloud Watch, Ops Works, IAM, SQS, SNS and SES.
• Design and implement solutions for monitoring, scaling, performance improvement, and configuration management of systems running IaaS/PaaS/SaaS applications
• Quickly troubleshoot and resolve network, hardware, software and performance issues, including rotating on call emergency response
• Well versed in DNS, Load Balancing, SSL, TCP/IP, networking and security
• Experience in application configurations, packaging, building, automating, and managing
• Experience in Auto and manual scaling in AWS
• Participate in architecture planning sessions with development team
• Experience in creating Technical, high level and low-level design documents
• Experience in creating the SFTP, FTP connections for copying/pasting files between servers
• Scheduling the Jobs using Cron tab
• Experience in extracting data from SAP
• Experience in working with different analytical functions in SQL
• Good experience in handling terabytes of data and good at analyzing the data related issues
• Extensive understanding of Transactional and Dimensional Data Modeling, Data Ware house concepts and Designing Star schemas & Snowflake Schemas for OLAP Systems.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 (version, flag and time).
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process.
• Excellent troubleshooting/Production Support skills and user interaction.
• Experience in reading data from and writing data to XML/JSON files.
• Working/handling with Agile team and attending stand-up's, Scrum Meetings
• Experience in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
• Experience in SSRS, SSAS, SSIS and T-SQL for developing complex Stored Procedures.
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and communication skills.
• Strong Knowledge in Creation of ETL design document and mapping sheet document.
• Having good experience as team lead and led the team with team size 3-5.
• Experience in processing and loading of data in Redshift
• Experienced in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
• Worked on Power BI and prepared dashboards using SSRS reports to make it more attractive.
• Willingness and ability to learn new technologies and concepts

TECHNICAL SKILLS

Operating Systems: RHEL/CentOS 5.x/6.x/7.x, Ubuntu/Debian/Fedora, Sun Solaris 7/8/9/10, Windows Server 2003/2008/2010

Build/Automation Tools: Ansible, Chef, Jenkins, Maven, TFS, MS Build

Languages: SQL, .Net, yml

Databases/Monitoring: Oracle 10g/11g/12c, IBM DB2 UDB 8.0/7.0/9.0, SQL Server 2008/2012/2014/2016 , MySQL, Redshift, Elastic Search, Nagios

ETL/DW Tools: SSIS 2005/2008/2008 R 2/2012/2014/2016 , Snap Logic, Arc Sync, Informatica

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Conceptual, Physical and Logical Data Modeling using ERWIN data Model

Web Technologies/Programming Languages: HTML, .Net, Angular

Web/App Server: Apache Tomcat, IIS, Application Server

Scheduling Tools: Control-M, Autosys, Task Scheduler & redwood

Version Control Tools: GIT, SVN

MS Office tools: MS word, MS Power Point, Ms Excel

Virtualization Tools: Virtual Box, Docker, Vagrant

BI, Reporting and other Tools: SSRS, SSAS, Power-BI, Customer-360, ARC 5.0/6.0/6.2

Ticketing tool: Salesforce, HP ALM, JIRA, Zoho, TFS

Bug Tracking Tools: JIRA, Rally, TFS

Methodologies: Agile, Water Fall, Extreme Programming.

PROFESSIONAL EXPERIENCE

Confidential, Ok

Computer Systems Engineer

Responsibilities:

• Design and implement solutions for monitoring, scaling, performance improvement, and configuration management of systems running SaaS applications
• Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon, star schema, snowflake schemas, and normalized and de-normalized data models)
• Leads the integration of the data warehouse with a modern, leading business intelligence platform
• Leads in designing and revising data model for data warehouse, and Metadata and data dictionaries across the enterprise
• Responsible for the designing the advanced SQL queries, Procedures, Functions, and Views
• Analyzes and documents “as-is” and “to-be” scenarios (processes, models, use cases, plans and solutions)
• Perform code reviews, evaluate implementations, and provide feedback for tool improvements
• Quickly troubleshoot and resolve network, hardware, software and performance issues, including rotating on call emergency response
• Well versed in DNS, Load Balancing, SSL, TCP/IP, networking and security
• Configured AWS Virtual Private Cloud (VPC), Transit Gateway and Database Subnet Group for isolation of resources within the Amazon RDS MySQL DB cluster, AWS-Dynamo DB and AWS-Redshift.
• Used Build tools like maven for building and deploying artifacts such as WAR from source code.
• Created monitors, alarms and notifications for EC2 hosts using Cloud Watch.
• Designed data mapping with Table creation scripts for Red Shift DB.
• Performed Health checks for applications before moving to production
• Worked on SSIS/Snap Logic ETL tool to process the data from oracle DB to S3 to Redshift
• Worked on power-BI reporting tool.

Environment: GitHub, Chef, Ansible, Jenkins, Maven, Linux, Docker, Vagrant, AWS EC2, AWS SQS, AWS S3, AWS RDS, AWS Cloud Watch, Jboss, Apache Tomcat, JIRA, Elastic Search, AWS Redshift, SAP BI, AWS ECR, Rally, SQL Server 2012/2016, SSIS.

Confidential

Lead Consultant

Responsibilities:

• Design and implement solutions for monitoring, scaling, performance improvement, and configuration management of systems running SaaS/PaaS/IaaS applications
• Worked on Change Data Capture (CDC) technology to load the incremental data from Source Applications to Target Systems.
• Responsible for the designing the advanced SQL queries, Procedures, Functions, and Views.
• Created Transformations and Mappings using Data Flow Task.
• Responsible for the creation of ETL Mapping Document
• Worked on Deployment Automation to ease the deployment to various environments using PowerShell Scripts, TFS build and release definitions.
• Responsible for the Creation of SOP documents for the deployments.
• Responsible for the creation of Release Documents for each deploymentExperience in developing Cloud Formation Scripts for AWS Orchestration.
• Troubleshooting and performance tuning issues with applications like SQL Server 2012/2016, Oracle10g, and MySQL 5.x.
• Involved and working in Agile Methodology (Rally/TFS), Change management, and Release management.
• Managing EC2 cluster and configuring Elastic Load Balancer with latency/weight based load balancing to server resources.
• Coordinated with different Application development teams in redesigning the architecture and created a hybrid model.
• Worked on SSIS ETL tool to transform the data from source to Red Shift Data Base
• Used AWS Identity Access Management to create users and groups and added permissions to allow access.
• Experience with Apache/Tomcat, Load Balancer (Apache) and expertise in making configuration changes and Web Sphere & Web logic servers for deployments and for hosting tools.
• Bootstrapping the agent nodes using knife and done jobs accordingly using Chef.
• Using Amazon Route53 to manage public and private hosted zones.
• Created multiple dashboards using a Power-BI reporting tool.

Environment: Linux, AWS, Chef, SVN, AWS, GIT, SSIS, SSRS, SSAS, Power-BI, SQL Server, Redshift, S3.

Confidential

Lead Consultant

Responsibilities:

• Serve as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems manage reporting environment including report data sources, security, subscriptions and metadata.
• Owns the development lifecycle and is responsible for managing technical risks throughout the project(s).
• Understands complex database concepts
• Responsible for estimations of the new requirements or enhancements in existing projects.
• Responsible for requirement gathering and creating requirement and technical document.
• Interacting with client on daily basis for status reporting purposes.
• Handling Slowly Changing Dimensions through queries and performance tuning.
• Creating ARC/Jasper/SSRS reports based on user requirements.
• Experience on Data Base modeling and designing.
• Worked on SSIS transformations to extract and load the data into DWH.
• Experience in technical information from sources such as design documents, GitLab, repositories, and vendor documentation for use in documentation activities.
• Experience in Review company tools and accompanying code for accuracy and defects.
• Experience in Implementing Work Item Customizations as needed to TFS.
• Worked on cloud environment, AWS to migrate various applications to EC2 instances created.
• Developed Cloud Formation scripts to automate EC2 instances.
• Handling Slowly Changing Dimensions through queries and performance tuning.
• Creating ARC/Jasper/SSRS reports based on user requirements.
• Sharing the reports on daily basis through reports schedule and alerts
• Owns the development lifecycle and is responsible for managing technical risks throughout the project(s).
• Understands complex database concepts
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables
• Worked on SSIS/Snap Logic ETL tool to process the data from SAP source to S3 to Redshift (Cloud)
• Perform Data Analysis and Data validation by writing SQL queries

Environment: Linux, Docker, Chef, AWS EC2, S3, Auto scaling, EBS, RDS, SVN, SSIS,SSRS, Power BI, SQL Server, Redshif.