Technology Lead Resume
Dallas, TX
SUMMARY
Highly energetic and self - motivated IT professional with great analytical & problem-solving skills and more than 13 years of profound working experience multiple domains with expertise in MS SQL Database Development (SSRS, SSIS, SSAS), PowerBI and .Net Software Design
TECHNICAL SKILLS
- C#
- ASP.Net
- VB.NET
- VBA Macro
- LINQ
- Web services
- XML
- Entity Framework
- Crystal Report
- StimulSoft Reporting
- PowerBI
- Power Shell
- SSIS
- SSRS
- Azure Data Factory
PROFESSIONAL EXPERIENCE
Technology Lead
Confidential, Dallas, TX
Responsibilities:
- Working as an onsite team lead for data and reporting team.
- Development effort estimation, planning and staffing of resources.
- Developed automation process to improve system performances.
- Identifying the impact of all proposed system changes.
- Involved in a data migration activity from PEGA to an operational data store.
Tool: Used: VSTS, PEGA, SQL Server 2016, TSQL Scripting, SSIS, SSRS, ETL, BIDS, SQL Data Tools.
Technology Specialist
Confidential
Responsibilities:
- Worked in Case and Matter Management System project. Field and data analysis, data cleansing, data corrections, designing data migration plan.
- Utilized PowerBI to create a dashboard that depicts critical KPI’s.
- Developed scripts using Windows PowerShell to automate data and document extraction from different data sources.
Tool: Used: SQL Server 2016, C#, TSQL Scripting, SSIS, ETL, PowerShell.
Senior Technical Consultant
Confidential
Responsibilities:
- Worked as a TSQL Consultant for a major state government project.
Tools: Used: Microsoft SQL Server 2016/2017, C#, GIT, TSQL Scripting, SSIS, JIRA, Confluence, Crucible, TSQLt Unit Testing Framework
Technical Services Consultant
Confidential
Responsibilities:
- Involved in multiple large-scale data migration projects
- Developed multiple complex reports for large enterprise clients using SSRS, SQL Server, and TSQL, StimulSoft Reporting.
- Involved in multiple large-scale data migration projects where -
- I was the main technical person leading the project from day 0 to Go-Live in production.
- Managed successful migration of critical production and contingency servers with no impact to business.
Tools: Used: SQL Server 2008/2012/2016 , C#, VB.Net, StimulSoft Reporting, TFS, SSRS. SSIS, Azure Data Factory, Data Quality Services (DQS), JIRA, Confluence, Salesforce.
Technical Data Analyst
Confidential
Responsibilities:
- Developed reports using SSRS 2008/2012, PowerBI, Qlik Sense.
- Designed and created an interactive dashboard, using SSRS, consolidating information from multiple independent systems into one cohesive monitor. This reduced the manual effort of a business team by 50%.
- Analyzed and presented geographic data using Google Map API, JSP, Java. The map visualized the different performance metrics all over Australia.
Tools: Used: MS SQL Server 2008 R2/2012, Visual Studio 2010/2012, Java, JSP, Oracle Apex, SSRS, SSIS, SQL Query, GIT, PowerBI, Click Software, Qlik Sense
Technical Consultant
Confidential
Responsibilities:
- Mainly worked for a new Retail Ready Meat plant which Confidential started in 2015.
- I was mainly involved in modifying and fixing issues the core planning System using MS Excel, VB Macro. Developed SSIS packages in order to import data from different operational systems.
- Developed an end to end process to build an Operational Reporting System (ORS)
Tools: Used: MS SQL Server 2008 R2/2012, Visual Studio 2010/2012, C#, ASP.Net, Entity Framework, SSRS, SSIS, BIDS, GIT, MS Excel, VBA Macro, MS Access.
SQL Database Developer
Confidential
Responsibilities:
- Involved in multiple large scale migration project where I performed source data analysis and designing mappings for data extraction.
- Developed an automated document generation process using C#, Ecrion XF Designer and XF Rendering Server. It is used to generate document in different format dynamically from any data source using visual templates.
- Developed a customized data and file extraction tool to extract data from Symmetry CRM.
Tools: Used: MS SQL Server 2008 R2/2012, Visual Studio 2010/2012, C#, ASP.Net, Entity Framework, SSRS, SSIS, SQL Query, BIDS, Redgate SQL Toolbelt, TFS 2012, Ecrion XF Designer
SQL Database Developer
Confidential
Responsibilities:
- Designing and developing scripts, installation procedures, and systems including source code control and issue tracking