SUMMARY

• An accomplished and versatile system professional, with considerable experience in enterprise data management and application development.
• Spent 2 decades on delivering extremely robust and efficient Information Management Solutions, on - time and on-budget. Inspiring leadership skills with an innate understanding of team dynamics and intrapersonal relationships, building winning teams that take pride in their accomplishments.
• Outstanding ability to define business functions as generalized metadata, enabling systems to provide long-term stability and reliability.
• Over the years learnt on absorbing and synthesizing a wealth of detail into a unified, coherent vision and communicating that vision to a diverse audience.
• Innovative process improvement and streamlining and team building is my niche skillset.
• Senior Application and Data Architect with significant experience and knowledge in database design, architecture, application architecture in information security, IT Risk, Operational risk domains.

TECHNICAL SKILLS

Enterprise Solutions: Full Microsoft BI Stack comprised of SQL Server, SSIS, SSRS, SSAS; Power BI, Tableau, ProClarity, Performance Point Server;

Messaging: MS SQL Service Broker; MSMQ; MS Biz Talk; Web Services

Databases: SQL Server 6.0 to 2016, Oracle 7 to 12; Sybase 10/ASE 11, DB2/400, Cassandra, Hbase

Project Management and Design: Visio, Erwin, Power Designer; Team Foundation Server, SVN, GitHub;

ETL Tools: DTS/SSIS; Informatica powercenter; BCP; Oracle SQL * Loader

Reporting Tools: SSRS; Cognos Impromptu, Crystal Reports, BO, SQL Reporting tools

SDLC methodologies: Agile / Waterfall

SDLC tools: VSS, PVCS, TFS Version control systems, sharepoint/PTS Powershell, Python, C#, ADO.Net, ASP.Net, Visual Studio.Net, Sharepoint Integration, VBA script, Excel, Access, Microsoft Project, UML, Visio, JAVA, UNIX, Office Suit Automation and VB Scripting in Powerpoint/ Excel/ MS Word /Access/ Sharepoint, R statistical package, SAS

PROFESSIONAL EXPERIENCE

Senior Data Architect

Confidential, NJ

Responsibilities:

• Designed and developed Share point BI solution from scratch, with SSRS Reports and dashboards
• Conducted several Proof of concepts based on the fusion center threat analysis business requirements
• Fusion center’s Cyber intelligence center successfully completed with global threat monitoring stations
• Architected target structured and un structured data loads in to SQL servers
• Redesigned windows PowerShell solution into C# solution using SQL stored procedures to enhance performance and security.
• Developed and Maintained ASP based intranet solution for changes and bug fixes.
• Designed, developed and consolidated multiple legacy databases onto a single database that uses various departments’ data.
• Data feed from API, SFTP, HTTS, Push etc. Fraud, Risk, Vulnerabilities, threats, physical security, audit logs Data formatting like CSV, XL, TXT, SQL. Designed & Developed SFTP based xml flat file data extraction process from FTP server, Bloomberg proxy Index NAV’s processing and FTP them to Credit-Suisse Zurich processes.
• Architected MDS/DQS solutions to cleanse and maintain data and mentored Users to maintain clean data through Excel.
• Designed and developed SSIS packages to refresh databases of new data structures and old structures to initial sync, and delta loads in both directions in migrating each application one at a time. Development of SSIS package for dynamic email sending to customers as an alerts based on business & data rules (Active Alerts)
• Worked with Enterprise Risk management team to share data flows to help Risk analysts.
• Performance tuning in the Production Environment using performance Monitor (Perfmon) tool, SQL Profiler, Query Tuning Wizard and Index Tuning Wizard.
• De-normalizing the DB objects in reducing the unused DB relationship as per the ask.

Senior Application Architect

Confidential, NJ

Responsibilities:

• Application design and database design and architecture.
• Establish Development, Collaboration and Communication processes across the global development teams.
• Implement and manage the agile development practices based on enterprise resources availability.
• Guiding Agile project teams to achieve a high level of performance. Performing all agile project management activities.
• Code management: Configure and manage Source code version control management system (TFS) Branching/ Merging/ Code conflict resolution/ build /Deployment, Code review process. Setting Coding standards.
• Estimation and planning, scope, issue and risk management, defect tracking, providing weekly status reports.
• Managing offshore projects and teams in Kolkatta, Pune and Mumbai, India.
• Load testing and vulnerability testing
• Production support activities: Application production support, production issue fixes and release cycles.
• Resource management and planning including: Resource Utilization Monitoring / Optimization, Performance Management and technical and personal improvement plan and business process improvement.

Senior Application Architect

Confidential, New york, NY

Responsibilities:

• Project/Role: As hands on Project manager managed all the cycles of the web applications for a media management company.
• Responsibilities: Analysis of client need using UML modeling including use cases, class, collaboration, sequence and deployment diagrams using Visio. Used design patterns and assigned responsibilities to the classes. Normalized the database, created stored procedures and used DTS packages to move the data from text files. Developed log and exception files to record transactions. Used Java, ASP.Net tools to develop the applications using role based authentication. Custom controls were developed to show the images of the hardware items and details.
• Tools and Technologies: Java, C#, ASP.NET, ADO.NET, Visual Studio 2003, SQL Server 2000, T-SQL, Internet explorer, HTML, and JavaScript running in a Windows 2000/XP/2003 environment, Crystal Reprots/ SQL Reporitng/ Data Extracts, Visual source safe version control.