Sql Server Data
Resume:
Narasimha M Sirisinahal
North Brunswick NJ
ac1r1p@r.postjobfree.com
Sr. Data Analyst/ Sr. Developer
CAREER OVERVIEW
** + years of IT experience with extensive expertise in SQL Server technologies like MS SQL Server suite of products like SSRS, SSAS and SSIS including development, deployment, testing and support.
Experience with software development life cycle (SDLC) and Project Management Methodologies.
Experience in SQL Server Programming, Analysis Services and Reporting services
Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
Experience in data Extraction, Transformation and Loading (ETL) processes using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
Very strong Transact-SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and Functions.
Energetic self-starter with ability to work effectively in a competitive and fast paced environment.
Lead major initiatives in System Migration Processes and Procedures
TFS build automation and deploying code using Release Management 2013
Agile/SCRUM development environment experience
Epic Certified Clarity Extract Transform and Load administration
Epic Certified Data Courier Administrator
Epic Certified Chronicles Install utilities ‘
Currently doing online certificate course in Data Analytics/Big Data from Rutgers University (Data mining and machine-learning techniques, R statistical programming language, Jan ’17 - Dec ’17)
TECHNICAL SKILLS
Languages/Frameworks: C#, .Net2.0/3.5/4.0, WCF, WPF, Visual Basic, Visual Studio, .Net,
.Net Framework, Ajax, JQuery, Entity Framework, JavaScript,, Angular JS
Web Technologies: ASP.Net, ASP, MVC, SOAP, XML Web Services, FrontPage, XML/DTD/XSD/XSLT, HTML, IIS4.0/IIS5.0/IIS6.0, Apache and, Microsoft SharePoint
Front End Programming: .Net, Visual Basic 6.0, VB Script, VBA, Powerbuilder6.0, Developer/2000, C, PL/SQL, SQL*Loader, Basic, Delphi, COBOL and ACUCOBOL
Databases: SQL Server 2016, 2012, 2008, 2005, 2000, 7, SQL Server Enterprise Manager, SSIS, SSRS, SSAS
Oracle 11g, 10g, 9i, 8i, 7
MySQL, SYBASE, BTRIEVE, File Maker Pro, Foxpro2.6 and MS Access
Version Control/
UML Modeling Tool: Visual SourceSafe, Visio, Microsoft Team Foundation Server 2013, Release Management 2013
Data Modeling Tools: Erwin 9
Reporting Tools: SSRS reports, Jasper reports, Crystal Reports and Active Reports,
Business Objects, Crystal Reports, Tableau, COGNOS, PowerBI
Operating Systems: Windows 9X/2000/2003, NT, UNIX, Linux, SINTRAN and DOS.
Hardware: HP 9000, ND- 570 (SINTRAN), PENTIUM PCs, PC LANs (Novell NetWare)
EDUCATION
Osmania University, India
Master of Philosophy in Mathematics
Master of Science in Mathematics
PROFESSIONAL EXPERIENCE:
NJ Housing Mortgage Finance Agency (NJHMFA), Trenton NJ Oct 2014 – Jan 2017
Senior Programmer Analyst/Data Analyst
Responsibilities:
Worked as SQL Developer with extensive use of analytical techniques
Wrote SQL queries and optimizing the queries in SQL Server 2012.
Worked on RDBMS concepts, Views, Triggers, Stored Procedures, Indexes and Constraints.
Performed data analysis and data profiling using SQL on various sources systems including SQLSERVER 2012.
Worked on SQL database development and data migration from legacy systems to SQL Server.
Developed SSIS Packages to extract data from various data sources such as Access database, Excel
spreadsheets and flat files into SQL Server 2012 for further data analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
TFS build automation: deployed releases of code and processes in different environments using Microsoft Release Management.
Development, integration, UAT and production. Automation included .NET code deployment, database scripts and reports.
Built automated test scripts using Microsoft Test Manager and Renorex.
Involved in design and development of Checklist module using ASP.Net, MVS 5 and Angular using visual studio 2013.
Created Adhoc reports using adhoc quarries as per user requests
Created dash boards, reports (power bi) using third party tool
Extensively used Transact-SQL and created stored procedures functions for data migration and adhoc requirements.
NJ Governs conference project using Microsoft Access 2013
Created import module to update registration data into Access Database (Relational DB).
Modified Microsoft access forms and created new reports as per user requirements.
Governor conferences database contains speakers, exhibitors, Sponsors and awards information and schedules
Technologies: Microsoft Release Management 2013, Microsoft test Manager 2015, Ranorex, SQL Server2016, SQL Server2012 MS ACCESS, ORACLE10g, ASP.Net, MVC5 C#, Entity Framework, Java Script, AngularJS,TFS 2013, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, Business Objects, Crystal Reports, PowerBI
Advantage Care Physicians/Preferred Health Partners, Brooklyn, NY Jun 2011 – Oct 2014
Application Technology Analyst/ Data Analyst/Programmer
Responsibilities:
Hedis Project:
Created various Hedis modules Using SQLSERVER2008 procedures such as Hedis_SRT (Disease-Modifying Anti-Rheumatic Drug Therapy for Rheumatoid Arthritis), Hedis_ASM (Use of Appropriate Medications for People with Asthma), and Hedis_BCS (Breast Cancer Screening)
Created Adhoc reports using Adhoc qurries as per user requests
Data Warehouse Project:
Involved in the design, development, implementation, loading, documentation and testing of a large scale, multi-terabyte data warehouse based on Microsoft SQL Server technologies such as SQL Server 2008 R2 database engine, SSRS, SSIS and SSAS.
Identified and captured business rules and requirements to drive the development of the data warehouse.
Wrote complex T-SQL queries for the interrogation of the source data and to insure data quality.
Generated a parameterized/Drilldown SSRS reports. Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2008 for further data analysis and reporting by using multiple transformations provided by SSIS such as data conversion, conditional split, bulk insert, merge and union all.
Crimson Care Project:
Created a crimson care registry module to extract data from Nextgen system as per Crimson specifications.
Used SQL Server 2008 and SSIS
Epic project:
Responsible for implementation of the Epic Clarity, Epic Data Warehouse, Epic ETL, and Business Objects Enterprise products.
Lead for representing the team at change control and other IT services meetings for Epic system go live.
Lead data migration to different environments (POC, TST, REL and PRD).
Technologies: Crystal Reports, SQL Server, MS ACCESS, ASP.Net, C#, ADO.Net3.5, TFS VS2008, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services
Aon Hewitt, Melville, NY May 2010 – Apr 2011
Senior Analyst
Responsibilities:
Documentation of requirements provided by users, creating high level and low level design documents,
designing of prototypes using Visio and providing training to the business users.
Created a module using SQL Server 2008 to provide data to Department of Treasury Office Foreign Assets Control.
Worked on SQL database development Queries and stored procedures and functions ..
Designed a module for CIGARS System for new clients using SQL Server 2008.
Created reports for Gate users using SSRS (Reporting tool).
Created reports for CIGARS users using COGNOS
Created new reporting tool web based system using ProClarity, SQL Server Analysis Services and SQL Reporting Services.
Tracked and monitored production technical issues tickets raised by business users for CIGARS, BIDS, and NNS applications.
Worked with offshore tech team suggesting solutions and coordinating and implementations
Developed Web Based Gate Application using ASP.Net Framework 3.5, MVC, C# and SQL Server 2008
Reviewed the .Net software and debugged the production issues.
Technologies: Cognos Reports, Crystal Reports, SQL Server, i, MS ACCESS, Microsoft SharePoint, ASP.Net, Classic ASP,C#, MVC, ADO.Net3.5,TFS VS2008,SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services
Sedgwick Claims Management Services Inc, Melville, NY Feb 2007 – Mar 2010
Programmer/Systems Analyst
Reviewed existing legacy system: analyzed processes and procedures needed for migration into new system environment.
Recommended and documented migration tools and procedures.
Developed and documented implementation plans; define, identify, and propose solutions to problems
Developed report specifications.
Developed reports in IVOS using JAVA Based JASPER reports and SQL Server.
Performed system analysis and created Janus to IVOS mappings
Provided gap analysis between the 2 systems and provided enhancement requirements for IVOS.
Developed reports using info maker (Power Builder tool) and SQL SERVER 2000
Experience managing relationship with key vendors including: 3rd party affiliate sites.
Production Support: Responsible for complete production support for legacy JANUS application.
Developed new reports for Janus system using Paradox and crystal reports based on user queries.
Developed reports using info maker (Power Builder tool) and SQL SERVER 2000
Authorizing SQL Scripts to inspect and resolve system data issues.
Experience managing / facilitating cross-functional technology teams focused on improving stability / performance
Technologies: Crystal Reports, SQL Server2005 Jasper reports, Paradox, Delphi, MSACCESS, Microsoft SharePoint, ASP.Net, C#, ADO.Net3.5 WPF,TFS VS2008, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services
CoveHill Group, Huntington, NY Dec 2005 – Sep 2006
Programmer/Systems Analyst
Responsibilities:
Installation of CoveMed_BRE /SmartXp
User training and technical support.
Modified Billing Module as per HIPPA requirements using VB.Net and VB6.0
Developed new reports using Active Reports
Created scripts for Covehill Dialer for automaton
Developed Billing History Module using VB.Net and XML
Modified Medicare Password change program as per user requirements
Technologies: VB6.0,VB.Net, C#, ADO.Net, XML, MSACCESS, Active Reports, Crystal Reports8.0, Visual Source Safe, Infragistics third party tool
Infosys International, Inc., Plainview, NY Jul 1997 – Dec 2005
Senior Programmer/Systems Analyst
WSF Monitoring System (WSFMS) (Phase3) Sep 2005 – Dec 2005
●Successful implementation of all phases of Women Sports Foundation Pledge/Gift membership module in storefront application from OO Analysis, design (UML), development, implementation, and training using ASP.Net, C# and SQL SERVER 2000 (website: http://www.wsfecomm.com/shop/)
●Developed ASP.Net pages for Gift Membership
●Integrated Gift Membership with the store front application(wfecomm.com)
●Integrated Gift Membership and store front with womensportsfoundation.org
Technologies: VB6.0, SQLServer2000, ASP.Net, C#, ADO.Net, XML, Crystal Reports8.0, Windows NT, Windows2000, Visual Source Safe
Wang Conversion Project Mar 2005 – Aug 2005
●Successful implementation of Wang Conversion Project for Department of Social Services using Acu COBOL and SQLSERVER 2000.
●Worked on modifications for daily routine procedures as per user requirements.
●Integrated tape copy utility interface in all tape copy programs.
●Integrated an interface to call .Net package using Acu COBOL in “List management programs”.
Technologies: Acu COBOL, SQLServer2000, Windows NT, Windows2000
WSF Monitoring System (WSFMS) (Phase2) Feb 2004 – Mar 2005
●Successful implementation of all phases of Women Sports Foundation storefront application from OO Analysis, design (UML), development, implementation, and training using ASP.Net, Web service and SQL SERVER 7.0 website http://www.wsfecomm.com/shop/
●Designed and developed Storefront application (wsfecomm.com) using ASP.Net, C#, including all store front features such as shopping cart, order review, material search
●Integrated Storefront Application with verisign.com interface for credit card processing.
●Integrated Storefront Application with ups.com interface for getting latest shipping & handling charges.
●Developed Import utility for WSFMS for “Advanta data” and “Kintera”
●Developed Bulk Email Utility (sending bulk emails from query builder) feature in WSFMS.
Technologies: VB6.0, SQLServer7.0,, ASP.Net C#, ADO.Net, XML, Crystal Reports8.0, Windows NT, Windows2000, Visual Source Safe
Integration of Data Retrieval Application: Nov 2003 – Jan 2004
●Development of an integrated data retrieval application for Suffolk Social services using Visual Basic 6.0, Access 2000 and SQLSERVER 2000.
●The “Data Retrieval Application” will enable counties to manage services and programs more efficiently and accurately. This system reads the data from SOS System to the local system at scheduled times.
●Developed an interface to transfer the data from SOS to the local system
●Developed Access 2000 screen for Medical SOS data.
Technology: VB6.0, SQLServer2000, Access2000, Windows NT, windows2000
Nassau Downs OTB: May 2003 – Oct 2003
●Developed a web based “Nassauotb” project using ASP.Net, C# and XML.(Website: www.nassauotb.com)
●Developed the above web site involving sophisticated features that enable Nassau OTB to publish latest and up to date racing information any time.
●The main features include racing information such as race calendars, handicapper picks, racing news, event announcements as well as general information about horse racing, betting and telephone accounts.
●Its database driven content management system provides Nassau OTB to deliver information in real time.
Technology: ASP.Net, XML, C#, ADO.Net, Access2000, Windows NT, Windows2000, Visual Source Safe
Blue Pearl: Feb 2003 – Apr 2003
●Developed a customized “Blue Pearl” (non–profit package) project for Stony Brook University using Visual Basic 6.0 and SQLSERVER 2000
●Blue pearl is an application for non-profit organizations that relies on donations and arranges various activities or events to raise money. It is a comprehensive CRM (customer relationship Management) solution which helps organizations maintain detailed information about their donors, referrals, community members and all other participants and the history of their relations with the organization.
●Designed and developed customized Blue Pearl project for non-profit organizations.
●Performed System Analysis for alumni data of Stony Brook University and converted into Blue Pearl System
Technologies: VB6.0, SQLSERVER2000, Crystal Reports 8.5, Windows NT, Visual Source Safe
WSF Monitoring System (WSFMS) (Phase1): Oct 1999 – Jan 2003
●Involved in all phases of the development of Women’s Sports Foundation Monitoring System database using Visual Basic 6.0 and SQL Server 7.0.
●Performed System analysis and design for WSF Monitoring System.
●Designed and developed modules such as Master, Athletes, Schedules, Donors, Awards, etc.
●Developed various reports using Crystal Reports 8.5 tool.
●Developed Query builder for WSFMS
●Converted the data from FileMaker Pro 3.0 to SQL Server 7.0
Technology: VB6.0, SQLSERVER 7/2000, Crystal Reports 8.5, Windows NT, Windows2000, Visual Source Safe, VBA
E-TELEMARK System: Mar 1998 – Sep 1999
●Designed and Developed E-TELEMARK system to track the recruitment process at Infosys International Inc.
●The objective of this project is to develop a distributed system to track the recruitment process at INFOSYS International Inc.
●This system was designed and developed as an internet/intranet application with multi-tier architecture.
●Performed System analysis and design and database admin activities.
●Technical Lead of E-TELEMARK System team.
Technologies: Power Builder 6.0/6.5, Oracle8.0, Windows NT
Connection System: Jul 1997 – Feb 1998
●Inclusion of batch processing module “Adoption and Placement” for the existing Connection System for State Department of Social Services, Albany, NY.
●State Department of Social Services, NY
●The Connection System Project involved a batch processing module to automatically monitor Invoicing and Billing of various services (adoption and placements) rendered by the State of New York.
●Performed system analysis for the already existing batch processing module of the system.
●Coded and tested retroactive rate setting module
●Worked with a team of six members in coordinating the other modules.
Technologies: Pro*COBOL, Oracle7.3, PL/SQL SQL*Loader, HP-9000, UNIX
Contact this candidate