Data Analyst Stack Developer
Resume:
BALAKUMAR PACKIRISWAMY
********@*****.***
Objective:
Looking for a challenging career with a growth-oriented firm to utilize my technical and management skills gained from private sector and federal government projects. PROFESSIONAL SUMMARY
● Over 15 years of experience in IT industry performed at various levels from Full stack developer, Data analyst, Technical Lead to a Dev manager.
● Have excellent skills in Data Warehouse, Data Lake, Relational databases, Data Migration System & Data Integration, Reporting, Analysis and Software Development and Data Management.
● Experience in designing and managing applications hosted on prem and cloud using C#, .NET, MSSQL and Azure.
● Extensive professional experience in design, development, implementation, and support of mission-critical Business Intelligence (BI) applications.
● Certified Microsoft Power Platform Solution Architect and Azure technologies.
● Experience across entire Microsoft BI suite of products including SQL Server, ADF, Databricks, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.
● Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.
Technical Skills
Framework
Microsoft .NET Framework, .NET Core.
Web/Application/Content Server
Internet Information Service, SharePoint, Power app Programming Languages
C#, VB.NET, Angular, Java
Scripting/Mark-up language
Angular, JavaScript, VBScript, HTML, XML\XSLT, Query UI and CSS Databases
SQL Server, Oracle, and Sybase SQL
Database Tools/Query language SQL Server Integration Services (SSIS), SQL Analysis Service, Azure SQL,PL\SQL, Redgate and AdeptSQL, DAX, ADF, Databricks Tools
Microsoft Visual Studio, AJAX Toolkit, Azure Devops, ServiceNow, Team Foundation Server (TFS), Rational Rose, VSS, TOAD, Infragistics, Aspose, Fortify 360, Github, sharegate 1
Reporting Tools SQLReportingService(SSRS), Crystal reports, Spotfire and PowerBI, PowerPlatform
Project Methodologies/Tools Agile, Waterfall, Rational Suite, UML and Visio EDUCATION:
● Capella University; Minneapolis; MN (MS Information Systems - 2007)
● Madras University; Madras; India, (BS Mechanical Engineering - 1996) Sr Consultant
Alcohol Tobacco and Fire Arms (ATF)/Leidos
Washington DC June 2023 - Present
● Collaborate with multiple business owners across functional units to help define comprehensive business requirements for new development in SharePoint.
● Implemented Successfully ATF SharePoint migration from 2013 to SharePoint 2019/online and angular application migrations from 5.x to 14.x. Integration with Okta for SSO.
● Implemented custom forms/pages, workflows and document library using SharePoint designer and InfoPath.
● Implemented Custom document library and pages using JSOM.
● Designed Dashboard using PowerBI.
● Responsible for maintaining few applications under ESA IV/V program designed using .NET Core, Angular JS and SharePoint.
● Maintained and Designed additional REST API’s as required for the business need using C#.
● Designed custom forms/pages, workflows and document library using SharePoint designer InfoPath.
● Participate in planning sessions with the Architecture team to improve the design of existing systems and provide recommendations for future systems.
● Developed Canvas and model driven Power apps.
● Developed applications in power Apps using CDS, Flow/Power Automate, Excel, Sharepoint online and SQL connectors.
Environment C#, Angular JS, AWS, SQL server 2016, Git, Nexus, Jenkins, SharePoint, PowerBI, infopath, PowerPlatform
Assistant Director/Dev Manager
Ernst & Young
Washington DC April 2014 – June 2023
Developed complex ETL SSIS packages using Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports. Designed PowerBI reports to refresh data from Azure/on-prem data sources using Gateway servers . Implemented Successfully the migration of several on prem SSIS packages to Cloud ADF. Developed complex calculated measures using Data Analysis Expression language (DAX). 2
Implemented Embedded Power BI reports on Custom Angular page using PBI API’s and also managed access of reports and data for individual users using Roles. Integrated PowerApp canvas application with PowerBI, Sql server connector. Designed /Implemented several ADF to manage data, created Azure logic app to sync data between systems like ADO/SNOW.
Designed, Managed and Integrated Tax Applications (IAS, PCS, SALT, Westlaw, K1, (Hedge funds) Wash-Sale, constructive sales, OneSource,CCH and Gosystem) Conduct daily status calls with project team members and resolve technical and project related challenges, address issues and devises strategies to mitigate risks. Responsible for people Management, including interview/ hiring, performance management and coaching team members.
Participate in the selection of external vendors and responsible for managing several external vendors in defining their deliverables schedules and deliverables. Successfully implemented a Program wide Reporting Dashboard using PBI for o Azure Resource usage report which resulting in 5+ million Annual cost savings. o Application Capability usage report saved 15% of the budget and to focus on areas of improvement.
o Data governance report to proactively identify the noncompliance database and applications.
Developed DORA, Story Robustness PBI reports using using Azure Devops (ADO), SNOW as data sources
Expertise in Managing PBI Service Admin portal.
Environment: MS SQL Server 2016/ Azure SQL, C#, Visual studio, PowerBI, Azure Analysis server, Angular, Sharepoint, ADF, databricks and PowerPlatform
(Senior Principal Developer) Data Analyst/Architect Pragmatics- Contractor at Office of Comptroller of Currency (Dept of treasury) Washington DC April 2011 – April 2014
Developed Logical and physical data model using ERWIN and mapped the data into database objects for ETL jobs
Responsible for Maintanence of Bank Examiners tracking applications o Designed using Microsoft ASP.NET MVC C# and sybase db. o Custom Google appliance search and sharepoint search. Implemented Successfully Migration of Sharepoint 2007 to 2013. Responsible for Canary application Biztalk Migration to 2013. Worked with Business Intelligence Manager to plan BI strategies, create BI road map and budget plans to deliver on organizations Business Intelligence needs. Conducted interviews with key business users to collect information on business requirements. Documented business processes and analyzed procedures to changing business needs. Assessed the impact of current business processes on users and stakeholders. Experienced in working with Star Schema and Snow Flake Schema to develop MOLAP Cubes using MS SQL Server Analysis Services (SSAS).
Environment: SSIS, SSRS, MS SQL Server 2012, C#, Visual studio 2012, MS Access, MS Excel, MS Office Access 2007
Manager/Project Architect and Technical Lead (PATL) PricewaterhouseCoopers(PwC), Washington DC Feb 2002 – April 2011 3
Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
Designed and coded the Rollover module using C#, T-SQL and SQL Service Broker. Implemented Sql server broker messaging for Project Rollover process between the subsystems. Led four offshore development team members in addition to onshore team. Designed and coded custom web user controls and WCF Services using C#. Designed API using Java and Documentum Foundation class to iteract with documentum. Designed and created SharePoint web parts using c#. Designed the logical and physical data models.
Designed and created several ETL packages used by SSIS for Deliverables module. Used extensively open xml in databases stored procedures and in applications. Designed and documented the Project Architecture document. Communicating to stakeholders periodically by providing updates on project status. Responsible for Managing development activities and migration effort of the application to support firm standard browsers and Operating System.
Assigns tasks, sets priorities and provide guidance in the completion of tasks, reviews deliverables, etc.
Ensures that functional requirements are met by reviewing the design and requirements documents. Defines and manages the project scope by working with Project Manager Environment: SQL Server 2008 R2/2008/2000/2005, MS Analysis Service SSAS Developer 2008, MS Project, MS Access 2000 & Windows platform. Java Senior Developer
Synygy Inc, Philadelphia, PA June 2000 – January 2002 Responsible of designing and development of applications in Lotus Notes\Domino, Visual Basic, C/C++ and Active server pages (ASP).
Designing and creating databases using Microsoft Sql server and Oracle on various projects. Coordinated with stakeholders and gathered requirements. Trained end-users & documented the functionality of the application & steps involved in application development.
Coordinated with development and support team members and participated in resolving any technical issues faced by them and ensure that it is taken care of properly in time. Designed and created reports using Crystal reports and implemented in the application using(RAS). Coordinated with business analyst and solution managers while gathering requirements. System Analyst
Ram Informatics, Danbury, CT June 1999 - May 2000
Responsible of designing and development of applications in Lotus Notes\Domino, Visual Basic, C/C++ and Active server pages (ASP).
Installed and configured Windows NT, PictureTel software for video conferencing and other medical software's.
Responsible for System Network Administration and to Maintain Domino servers across two domains.
Coordinated with stakeholders and gathered requirements. Trained end-users & documented the functionality of the application & steps involved in application development.
Developer
ITEX Information Technology Ltd, Bangalore, India July 1996- May 1999 4
Responsible of developing codes in programming language C++, Visual Basic 5.0 and Lotus Notesv4.0 of various projects assigned to me.
5
Contact this candidate