SUMMARY:

• Results oriented professional with 7.5 years of experience in developing data warehouse and business intelligence applications
• Confidential Certified in SQL Server 2012/2014 with in depth knowledge of ETL Development, ETL testing, SQL Server Administration, and Business Intelligence Application Development, using T - SQL, SSIS, SSAS, SSRS, Power BI
• Experienced with the Full Life Cycle and Methodology for implementing OLAP (Online Analytical Processing) data warehouses (star and snow flake schemas) and business intelligence reporting systems
• Expertise in administering SQL Server, including backup/restore, database maintenance, user authorizations
• Experienced in database debugging and tuning using the Query Analyzer, SQL Profiler, and SQL Server Debugger
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts
• Experience in building test plan, test cases, regression and User Acceptance Testing.
• Expertise in creating complex SQL queries; helped other testers and business analysts optimize SQL queries and/or optimized tables’ index to aid query optimization
• Expertise in using Python to develop algorithms to improve efficiency of data loads,
• Experience in creating data visualization reports using Tableau
• Generated reports in various formats, Table, Matrix, drill through / drill down, parameterized, linked and sub reports using MS SQL Server Reporting Services (SSRS) and Power BI
• Served as integration lead for third-party software integration; successfully implemented Clever, Common Cartridge, ExactTarget
• Created C# program of checking of activities, errors, job status of prod server

TECHNICAL SKILLS:

Language: Python, Java, Shell Scripting, C#, .Net

Business Intelligence tools: SQL server, Tableau, Tableau server, Confidential Datazen

Databases: SQL Server 2012/2014, MySQL

Data Modeling Tools: DbSchema Visio, Stored Procedures

ETL/BI Tools: SSIS, SSAS, SSRS, Tableau, TOAD

Other Tools: JIRA, Confluence, HP ALM, Jenkins, Commo CartridgeExactTarget (now part of Salesforce Cloud), Clever

Operating Systems: Unix, Linux, Windows 7/NT

Technical Areas: Design/Architect, development, Testing, Tuning, Scheduling

Other skills: HP ALM Jira, Confluence, Test Director, File-Manager, Clarify

Cloud platform: Amazon AWS

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Server BI/SSIS/SSRS/SSAS ETL Developer

Responsibilities:

• Discovery Education is the global leader in standards-based digital content for K-12, transforming teaching and learning with award-winning digital textbooks, multimedia content, professional development.
• Serving 4.5 million educators and over 50 million students, Discovery Education's services are in half of Confidential . classrooms, 50 percent of all primary schools in the U.K., and more than 50 countries.

Confidential

ETL Developer

Responsibilities:

• Work with enterprise wide business and IT senior management to understand data analysis and reporting needs
• Assisted with logical and physical design of the new data warehouse.
• Design and creation of data warehouse fact and dimension tables, views, and stored procedures and triggers
• Used a combination of T-SQL, Stored Procedures, SSIS and custom development to create, optimize and monitor ETL processes to load data to warehouse
• Developed complex SSAS cubes with fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created aggregations, user defined hierarchy for the cubes and KPIs as well as Calculated members
• Used SSRS to create standard and data driven report subscriptions
• Implemented dashboard and reports using Power BI to show real-time nightly job status which helped the team evaluate and solve production problems
• Designed test plans, test scripts, test scenario from business requirements and business use cases
• Used JIRA and Confluence to maintain documentation and defect logging and
• Tuned performance of nightly ETL process, improving jobs’ run time from 6 hours to 4 hours
• Created SQL Server agents to notify support team of alerts and overall jobs’ status
• Created C# program of checking of activities, errors, job status of prod server
• Developed C# application for checking activities for Production Workstation
• Created ASP.NET application that retrieves data from SharePoint using Web Services
• Project used Agile methodology with Scrum
• Moved servers and applications to AWS as proof of concept

SQL Server Administrator

Responsibilities:

• Install/Configure/Troubleshoot MS SQL Server 2012 instances
• Implement Change Management requests
• Monitor CPU Utilization, Memory Pressures, Disk I/O “bottlenecks”
• Lead efforts for Patch Management and automation
• Manage multiple instances of SQL server databases, backups, replication, users and roles
• Implemented Industry Standard Transparent Encryption to all Production Databases

Python Developer

Responsibilities:

• Used Python API to integrate third-party software, including Clever, Common Cartridge, ExactTarget
• Developed custom application to identify delta of data, which improved efficiency of bulk loads to warehouse tables

Tools: &Technologies: Windows10, Linux, MS SQL Server 2012, Tableau Desktop, Python, Tableau Server, Power BI, Datazen, HP ALM, Confluence, JIRA, Dimensional Data Modeling, Python APIs, Web Services (RESTful and SOAP), Jenkins

Quality Assurance Analyst

Responsibilities:

• Worked with Managers to understand quality assurance requirement and making testing plans
• Responsible for the unit testing of various component
• Led a group of team member in creating a test robot for testing the functions of a phone
• Responsible for planning and executing stress testing
• Responsible for running and maintaining automated stability testing using Python
• Responsible for document testing procedures and management system
• Assure ongoing compliance with quality and industry regulatory requirements

Tools: &Technologies: Quality Center, Ubuntu Linux 10.x Git 1.x Python 2.6, Ruby1.x XML

Java Developer

Responsibilities:

• Developed water resource management system: real time monitoring system, decision making system
• Involved in business meetings with business partners to gather requirements about real time water resource management
• Analyzed the requirements on dangerous situation of the water management facilities
• Involved in modulation of the system which is model-view-control design pattern
• Involved in designing frontend pages using dream weaver
• Upgraded Java mail function to send the corresponding technical person an emergency email when dangerous situation happens
• Implemented Struts Action classes for business logic and form bean classes for validation by using Struts framework
• Coded injecting dependencies using Spring Framework to for service layer, business layer and data access layer
• Batched the employees’ information through an excel file and convert it to INSERT command using Python
• Performed in writing SQL Queries to fetch data in database, Stored Procedures to prevent recompiling SQL code and Triggers
• Monitored error logs using log4j and resolved application bugs

Tools: &Technologies: Microsoft 2000, MSSQL 2005, git1.x, Struts2, Spring3, Hibernate3, Dreamweaver 7.x, Tomcat 6.x