We provide IT Staff Augmentation Services!

Software Developer / Engineer Resume

Alpharetta, GA

OBJECTIVE:

I am a dynamic professional with over 15 years’ experience in Information Technology and software development, with 7 years in database development and analysis, 6 plus years in quality engineering software design. Extensive knowledge of Data Warehouse design and implementation; Working with OLTP and OLAP in Hospitality and Cinema Industries, small businesses and Non - Profit establishments. I am looking for a challenging position in Database development, analysis and solutions implementation including non-relational database like MongoDB, with a company that desires to innovate and to be at the cutting-edge of creativity. A vibrant agile company where my analytical, problem solving skills and years of application knowledge can be utilized. I also bring to the table, excellent work ethic, great communication skills and tools, and innovative ideas.

SUMMARY:

  • Exceptional skills in database development and analysis using Microsoft SQL Server, MySQL, Microsoft Access.
  • Strong knowledge of Non-relational database, NoSQL and MongoDB, JavaScript Object Notation (JSON).
  • Highly experienced with cloud technology and hosting of IAAS, PAAS and SAAS using Microsoft Azure.
  • Extensive knowledge of Microsoft SharePoint for development, reporting and analysis
  • Great knowledge of Database Analysis and dashboard reporting tools like Power BI, QlikView and Tableau.
  • Database Analysis and reporting using power pivot and pivot tables in Microsoft Excel.
  • About 2 years of managerial skills with several years in a supervisory role.
  • Experienced with C# programming and debugging, refactoring using ReSharper, NCrunch for test analysis, GIT and TFS.
  • Writing Coded UI tests using C# and testing using Fitnesse.
  • Experienced with a host of other UI testing tools including TestComplete, Coded UI, Fitnesse, HP UFT and Non-UI testing and API testing tools like NUnit, Junit, SoapUI.
  • Highly Proficient in executing and managing all data analyst responsibilities such as database design, installation, Configuration and using T-SQL, writing and developing complex SQL queries for dash board reporting and decision making.
  • Strong skills with Software Development Life Cycle methodologies such as Agile and Scrum.
  • SQL Server 7 years, Excel 17 years, Access 5 years, project management 12 years, Data Analysis 7 years, software development and quality engineering 6 years.
  • Experienced with Python and CRAN R as it relates to Data Science.

TECHNICAL SKILLS:

DATABASE: MS SQL SERVER 2012/2014/2016, Azure, MySQL, NoSQL (Mongo DB), MS Access, MS Excel, Power BI, SSIS/ETL, PostGRE SQL, Erwin Data Modeler.

PROGRAMMING: C#.NET, SQL, HTML/HTML5, Python, Cram R, CSS, AJAX, XML, JavaScript, Shell Scripting, Test Complete, Angular JS, WPF, Microsoft SharePoint Developer.

OPERATING S YSTEM / WEB S ERVER: Windows, Mac, Linux / IIS, Apache

CLOUD COMPUTING: Microsoft Azure

A PPLICATIONS: Microsoft Visual Studio, Power BI, QlikView, Tableau, MS Business intelligence/Data Tools (SSIS ETL), Talend ETL, MySQL Workbench, PhPMyAdmin, SharePoint Developer, Dreamweaver, Agile Development

COLLABORATION TOOLS: Atlassian Jira and Confluence, Slack, MS Office (Word, Excel, Power Point, Project and outlook), MS Visio, Microsoft SharePoint

PROFESSIONAL EXPERIENCE

Confidential, ALPHARETTA, GA

SOFTWARE DEVELOPER / ENGINEER

  • Database and data warehouse design, development and business intelligence design using Microsoft SQL server 2008, 2012, 2014 and 2016.
  • Building enterprise level data integration and data transformation solutions in Visual Studio.
  • Building complex data collection (extraction), transformation and loading scenarios (ETL).
  • Dashboard reporting for movie theatres and site managers using Power BI
  • Using entity Framework to implement and run embedded SQL queries with our enterprise solution.
  • Using GIT and Source Tree as the GIT client to check in changes and pull new codes.
  • As part of my numerous Innovation projects, introduced Microsoft Power BI, Microsoft Azure, Microsoft Coded UI to the product and to the Team
  • Lead engineer during the implementation and migration of test environments to the cloud using Microsoft Azure.
  • Implemented development environment and Test environment with Microsoft Azure
  • Created and Implemented SSIS applications to transform and create upload files to third-party clients and their Home Offices
  • Reported development metrics in TFS through Microsoft Power BI to stake holders.
  • Created Dashboards for KPI metric and sales data reports in Microsoft Power BI for clients
  • SharePoint developer and administrator for the Cinema LOB.
  • Developed and created SharePoint reports and WebParts using SharePoint Designer.
  • Writing Queries for Mongo DB, for data aggression on the enterprise solution.
  • Creating JSON files using customized Web APIs and feeding them into Mongo DB through API calls from the server.
  • Transforming SQL records into XML transaction files using SSIS and SSIS jobs, triggers and alerts to export to Home Office on nightly bases.
  • Created SSIS packages within the Legacy Enterprise solution (Cinema HQ) to create weekly CSV files that are transmitted to Movie studios for settlement and Payments.
  • Experienced with using NCrunch for unit testing and test-code coverage within visual studio.
  • Using JetBrains ReSharper for refactoring, code quality analysis, warnings and suggestions.

Confidential, CUMMING, GA.

DATA WAREHOUSE CONSULTANT

  • Creating ETL process using SSIS to convert legacy client database to Native Microsoft SQL Server Database.
  • Designing and implementing granularity into existing and new Data Warehouse design.
  • Creating indexes and index views and data lineage in Data warehouse
  • Developing and writing T-SQL queries, views, functions and stored procedures,
  • Analyzing existing client’s data to determine what new reporting or insight may be useful for them, using SQL Server Analysis Services (SSAS) and Power BI.
  • Creating and implementation of a viable tabular reporting solution using SSRS and/Microsoft Power BI.
  • Creation and conversion of existing normalized database to a denormalized data warehouse using either star or snowflakes schema and OLAP cube report using SSAS.
  • Helping clients to administer and manage data and reporting security within MSSQL Server and SSRS.
  • Creating database and data warehouse schemas using Erwin data modeler
  • Developing Tablix and Matric report using Report builder and publishing to SSRS.
  • Query optimization and troubleshooting using SQL profiler
  • Using Microsoft Excel, power point and Access to extract and analyze data, creating relevant user-friendly report and presentations for clients.
  • Creation, migration and maintenance of jobs to run several processes including nightly backup of databases at client sites.
  • Planned, Coordinated and administered database systems, including base definitions, structures, documentation and requirements, setting operational guidelines and access within the database management system (DBMS).
  • Successfully upgrade multiple databases and performance tuning, maintenance and training for continuous operation
  • Teaching students how to use SSAS in creating cubes, data sources, views, named queries, dimension and deploying of analysis service project in SQL Servers
  • Training and building their understanding on Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database to prepare them for Microsoft Technology Associate Exam 98-364
  • Teaching students on how to write basic Transact-SQL queries and working with database objects, understand data languages, DML, DDL, DCL and TCL.
  • Explaining Hadoop and its eco system including Spark, Hive, Pig and Oozie.

Confidential, MABLETON, GA

IT DIRECTOR / DATABASE ANALYST (VOLUNTEER)

  • Created the organization’s website using HTML5 and PHP with MySQL database.
  • I have a supervisory role of reviewing, managing, updating and making changes to the website when requested.
  • Organizing continuing education training for other volunteers in all the technical areas of the organization.
  • Creating and generating reports from MySQL database for all community activities organized.
  • Maintained SQL Scripts and store procedures for creation of Database Objects
  • Managed database security and roles for the organization in both MSSQL Server and MySQL Database.
  • Converted all legacy data from heterogeneous database (DB2, MySQL, MS Access, Text files and Excel files) to SQL Server using SSIS (Data Tools Business Intelligence)
  • Created MSSQL Server Jobs to perform weekly backup of the organization’s data using scheduled SSIS packages
  • Created a Reporting Server (SSRS) to store all created reports and managed the access rights with SSRS.
  • Created jobs for ETL and transmission of CSV files to the North America Headquarter of the organization (RCCGNA)
  • Enhanced database performance, performed restores, implemented recovery procedures and handled performance tuning.
  • Conducted database management, performance measurement and performance tuning and query optimization using SQL profiler, SQL analyzer.
  • Developed T-SQL query optimization and ETL strategies.

Confidential Alpharetta GA

QUALITY ENGINEER II

  • Created functional Requirements and Design Documents for Developers and project Managers.
  • Directly responsible for the payment application certification (PADSS) with credit hosts for VISA, Mastercard, Discover and Amex.
  • Implemented automated deployment of product increment (PI) at the end of the scrum cycle, to client sites.
  • Created API documentation for third party online merchants like Movieticket.com, fandango.com
  • Worked with Product owners on Epics and Stories, estimating story points and efforts.
  • Responsible for writing release notes at the end of every release
  • Wrote stored procedures and script for SQL data migration and System upgrades
  • Create SQL server jobs, triggers and alerts managed by SQL Server Agent
  • Configured SQL Server Reporting services and wrote Enterprise level reports for using Active reports and SQL Server Report Builder
  • Developed Behavior driven design test plans using Gherkin format within Visual studio and integrated those tests with Microsoft Team Foundation Server.
  • Developed and Wrote Coded UI tests using C# in Microsoft Test Professional, Test Complete, and Fitnesse
  • Running SQL profiler to debug issues with slow query and data optimization with Management Studio (SSMS)

Confidential, Alpharetta GA

SUPPORT TECHNICIAN

  • Managed a Four-man team with resources in both the U.S and Hyderabad, India.
  • Primary goal was to help the support team meet Service Level Agreement on more difficult issues.
  • Secondary goal was to find trends and correlation in support cases and issues and offer timely solutions.
  • Using Microsoft Visual Studio IDE to debug both C# and VB codes and checking in codes to Team Foundation Server (TFS).
  • Created excel report on issues and performed analysis on application reports using Pivot tables.
  • Fixed field issues related to bad or defective queries, stored procedures and functions in MSSQL Server.
  • Created and fixed T-SQL Jobs, triggers and alert with the theatre enterprise solution.
  • Installed and Implemented SQL Server Reporting Services (SSRS) at client site and fixed active reports.
  • Query optimization, tuning and debugging using SQL profiler
  • Performed system installation and Upgrades
  • Created jobs at client sites for SQL Server database maintenance including re-indexing of tables.
  • Responsible for training new hires for both support and QAs on both the site level application and the Enterprise applications.
  • Received company’s best employee award with a 98% excellence rating for the year and overall support personnel of the year, two years in row.

Confidential, ALPHARETTA, GA

SUPPORT TECHNICIAN

  • Supported the DSL line of products
  • Supported dialup internet on windows OS

Hire Now