SUMMARY

• Motivated hands - on IT professional offering 20 years’ experience in Information Technology, encompassing management, project management, data analytics, business analysis, architecture/technical design, development, testing, and delivery of results-oriented solutions that meet or exceed customer-driven expectations.
• Hands on experience in designing and developing data base driven 3-tier applications using Microsoft Visual Studio and MSSQL Server technologies, with all phases of software development life cycle (SDLC)
• Hands on experience creating development plans, task estimation and risk management.
• Hands on experience in designing and development of database schema, stored procedures and back-end interfaces.
• Hands on experience with data warehousing, data mining, reporting and analysis.
• Excellent analytical and problem solving skills.
• A team builder, player with excellent leadership style and ability to meet deadlines.
• Excellent organizational, interpersonal and communication skills with business and C-level executives.

TECHNICAL SKILLS

Technologies: .NET Frame work- 4.0/3.5 C#, Java, VB.NET, ASP.Net MVC, Web services XML, Net remote services, Win/ Web form GUI development, Telerik and Dev Express controls for .NET

Development tools: Microsoft Visual studio 2012, 2010, 2008/2005/2003 , VS 6.0, Oracle 10,11.x

Hadoop and big data technologies: Pig, Hive, HDFS, HBase, NoSQL, MongoDB

BI/MI tools: SAP Business Objects 3.x, 4.x, SSRS, SSIS, SSAS, Tableau, Crystal Reports

Databases: SQL Server 2010, SQL Server 2008, Database replication, Data modelling, Data warehousing, stored procedures, table design & development

PROFESSIONAL EXPERIENCE

Confidential

Tech Project Manager

Responsibilities:

• Working with development, QA and business stake holders to see that multiple project implementation and delivery is on time and budget, with a strong focus on infrastructure projects.
• Directly responsible for managing scope, cost, schedule, risk, human resources, and communications for the technology side of the project.
• Managing financials, budget forecast and reporting of the status to the stake holders using Clarity.
• Handle the change control process, deployments and post deployment activities.

Confidential

IT Manager/Tech Project Manager

Responsibilities:

• Managed development and delivery of 30+ applications to implement process efficiency saving time and money.
• Managed a team of 5-10 onsite and offsite IT developers. Acted as a development lead, performed code reviews and code analysis to maintain coding standards and use of approved technology.
• Acted as a go-to person for all the data related questions for operational and reporting databases.
• Manipulated, cleansed & processed data using SQL Server.
• Responsible for loading, extracting and validation of client data.
• Wrote SQL scripts and stored procedures for data loads and extracts.
• Monitored automated loading processes.
• Built a data warehouse, did data profiling, data quality and analysis work for complex banking data.
• Analyzed raw data, drawing conclusions based on quantitative analysis and provide recommendations.
• Worked closely with database administrators to maintain operational databases.
• Worked with internal and external audit groups, QC on the audit findings.
• Worked with the business and IT BA-s to develop scope, objectives, requirements documents, technical requirements and suggested innovative solutions.
• Worked with the architecture team for developing solutions to multiple projects, dependencies and managed risk. Ensured compliance with SDLC approach.
• Wrote deploy documents to promote applications to multiple environments.
• Acted as a liaison between banking operations, retail banking group and IT to prioritize and implement applications according to the business needs throughout the SDLC life-cycle.
• Managed the project budget, IT spending and allocations.
• Coordinated with QA, UAT and release management groups for project deployments. Reviewed and helped with QA test cases and planning.
• Worked with infrastructure group to setup multiple application environments on optimal infrastructure.
• Worked with director of DR to develop business continuity plans and application recovery plans.
• Worked with vendors to manage upgrades and patches of their applications.

Confidential

Sr. Software Developer

Responsibilities:

• Single handedly managed all the requirements, design and development of .net applications for banking workflow.
• Developed multiple automated processes to eliminate manual labor and saving processing costs and time.
• Wrote extensive XML web services, web service consumers and complex SQL stored procedures and queries to set up data transfer between the two major Confidential databases.
• Responsible for checking the data accuracy of and integrity.
• Implemented complex algorithms to calculate commissions for Confidential advisors quarterly reports.
• Setup database replication from production databases to reporting databases.
• Help business analysts with the random queries, pull ad-hoc reports.
• Trained developers and users on these systems.