SUMMARY

• 12 + years of IT experience with extensive expertise inSQLServer technologies like MSSQLServer 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 inSQLServer 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 TuningSQLqueries and T - SQLqueries, MDX & improving the performance of the queries.
• Very strong Transact-SQLDevelopment 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

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 ReportsBusiness 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)

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Database Developer

Responsibilities:

• Worked asDatabase Developerwith extensive use of analytical techniques and supporting INFOR ERP system.
• Supporting MOSCOW service tickets. Modified purchase order change order forms, packing slip and pallet labels
• WroteSQLqueries and optimizing the queries inSQLServer 2012.
• Performed data analysis and data profiling usingSQLon various sources systems including SQLSERVER 2012.
• Developed SSIS Packages to extract data from various data sources such Oracle and SQL Server
• Worked with Toad tool to work SQL queries for Oracle database.
• Formulated and documented the physical ETL Process design based on business requirements and system specifications with strong ETL design skills including source to target mappings.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformation like conditional split, Cache, for each loop, multi cast Derived column, Data conversions, Merge, OLEDB command, script task components.

Confidential

Senior Programmer Analyst/Data Analyst

Responsibilities:

• Worked asSQLDeveloperwith extensive use of analytical techniques
• WroteSQLqueries and optimizing the queries inSQLServer 2012.
• Worked on RDBMS concepts, Views, Triggers, Stored Procedures, Indexes and Constraints.
• Performed data analysis and data profiling usingSQLon 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.
• Worked with Data Modeling and DBA groups to create, refine, and validate Data model Structured Methodologies and business process re-engineering and data modeling.
• Responsible for Data Modeling for the projects phases.
• 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

Confidential, Brooklyn, NY

Application Technology Analyst/ Data Analyst/Programmer

Responsibilities:

• Created various Hedis modules Using SQLSERVER 2008 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 queries as per user requests
• 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.
• Created a crimson care registry module to extract data from Nextgen system as per Crimson specifications.
• Used SQL Server 2008 and SSIS
• 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).

Confidential, Melville, NY

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 tothe 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 productiontechnical issuestickets 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.

Confidential, Melville, NY

Programmer/Systems Analyst

Responsibilities:

• 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

Confidential, Huntington, NY

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

Confidential, Plainview, NY

Senior Programmer/Systems Analyst

Responsibilities:

• 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
• 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”.