Technical Project Lead/ Senior Consultant Resume Seattle, WA - Hire IT People

SUMMARY

Versatile and seasoned IT Professional offering over 9 years’ experience software/ database development and business intelligence (BI) wif frontline clients including Microsoft, Expedia, BestBuy and Dow Jones.
Hands - on experience in development of TSQL, Power BI development, C#, test plans and project plan.
Adept at preparation of Project Documentation, BRDs, Functional Specifications and Test Plans, besides in-depth understanding of the Software Development Life Cycle.
Demonstrates an understanding of business needs, translate it into defined technology solutions, and "stay the course" to implement it, while anticipating and identifying where change is needed.
An excellent communicator wif keen analytical ability, continuous learning skills and proven ability to work wif technical as well as non-technical teams, in onsite as well as offshore models.

COMPUTER SKILLS

Project Management: Certified ScrumMaster, MS TFS (Team Foundation Server), MS Projects, Clarity, JIRA

Process Mapping: Pega System, MS Visio

Methodology: Agile and Waterfall methodology

Languages: C#, ASP.NET, Java, VB, VB Script, VBA, DHTML, XML/ XSL

Database: T-SQL, P/L SQL, SQL Server, SQL Profiler, Sybase Power Designer, MS Integration Service

Design Tools: MS Visio, SharePoint Designer, Dreamweaver, MS PowerPoint

BI Tools: MS Power BI, MS Excel, Powerview, MS Integration Services (SSIS), MS Analysis Services (SSAS)

Others: Smartsheet, MS Dynamics CRM, MS Office (MS Word, Excel, PowerPoint), MS Visio, Apptio

PROFESSIONAL EXPERIENCE

Technical Project Lead/ Senior Consultant

Confidential, Seattle, WA

Responsibilities:

Implemented reports using various tools such as Power BI, Excel Power View, SSAS, Apptio and Dynamics CRM.
Performed data analysis for designing reporting solutions using TSQL views and stored procedures.
Oversaw testing activities to ensure dat deliverables match requirements and involved wif deployment of the solution in production environment.
Wrote test plan, test cases and automated scripts in TSQL to execute testing for a critical financial system.
Implemented a Dynamic CRM Online solution as a Project Manager.
Closely collaborated wif business teams to gather business needs and prepared Functional Documents (FRD) and Technical Specification Documents.
Performed query tuning, troubleshoot live reporting issues wif SQL profiler and debugged SSIS packages.
Provided direction and support to a team of offshore developers in development of BI reports.
Identified project risks and potential performance bottlenecks and provided TEMPeffective solutions for resolution of issues, wif focus on meeting project timelines.

Confidential, WA

Software Design Engineer II

Responsibilities:

Monitored the performance of the application and provided live application support, wif emphasis on speedy resolution of bugs and performance issues. Utilized SQL profiler and SQL Trace File, besides implementation of other debugging strategies.
Provided technical direction and support to a team of 5 developers, integration and migration of a .NET case management system wif Pega Process Management System. Utilized Pega (PRPC 5.3) for process and workflow improvement/automation.
Prepared data models and involved wif database design and development, and used SSI and in-house ETL tools for data extraction.

Software Engineer

Confidential, Minneapolis, MN

Responsibilities:

Worked on enhancement of a Financial News Feed System (using C# and T-SQL) dat fed data from external sources, transformed data and displayed it on the Confidential .
Developed, improved, and extended existing code bases using T-SQL, C# and ASP.NET.

Data Analyst

Confidential, Bloomington, MN

Responsibilities:

Implemented large-scale, personalized cross-channel marketing campaigns forcustomer base of millions, in Oracle using P-SQL.
Worked closely wif marketing teams to define the high-level project requirements as well as granular system level requirements.