SUMMARY

• 10+ years of experience as a SQL Server Developer and 4+ as a reports developer.
• Expertise in Database Administration activities that include Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
• Experience in upgrading SQL Server software to new versions and applying service packs and patches.
• Technical experience with High availability of SQL server databases and Always ON feature.
• Experience on High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and clustering and database security and permissions.
• SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
• Also involved in the operational maintenance of Student information systems, using tools such as SharePoint, Tableau, Power BI, SSIS, SSRS, SSAS and SQL Server.

TECHNICAL SKILLS

Databases: MS - SQL Server 2000/2017, Oracle 9i/10g/11g, MS Access, SAS

Operating Systems: Linux, UNIX, Mac OS, Windows 10/7/vista/2000/XP/NT/98

Tools: Visual Studio 2012, Crystal Reports (Business Objects), Microsoft Active Directory Services, PVCS, VSS, Visio, ADO, Adobe Acrobat,ADO.NET, PL/SQL,T-SQL, Power BI, TOAD, Red Gate, SSRS,SASS, DAX, MDX, Team FS, VSTS with Git, Power BI, Tableau

ETL tools: Ab Initio and SSIS

Methodologies: OOA/OOD, Distributed Network Architecture (DNA), Service Oriented Architecture (SOA)

Languages: C, C++, C#, COBOL, JAVA

Scripting Languages: PHP, Pythan, R

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. SQL Developer

Responsibilities:

• Working on CDC MS SQL server Hepccat (Hepatitis C) reports for every 3 and 6 months. Involved in backup up databases. Getting data from different providers sites and populating into data tables. Revolving lab results and lab order issues. Creating triggers for lab results bins.
• Involved CAPricorn project for hash matching and table 1. Improving query performance and writing new SQL agent jobs for automation.
• Responsible to move data (ETL) from different healthcare site to Confidential databases in various formats.
• Automated the process using SQL agent jobs. Wrote batch jobs to move data from SFTP sites to other sites.
• Did performance tuning on large stored procedures for various subject areas.
• Installed and implemented OpenEmr project (PHP, MySQL).

Confidential, Schaumburg, IL

Senior BI developer

Responsibilities:

• Involved in the operational maintenance of Student information systems, using tools such as SharePoint, Tableau, Power BI, SSIS, SSRS, SSAS and SQL Server.
• Created complex drillthrough, drilldown SSRS reports and maintained subscription to these reports to delivered to users inboxes in excel or PDF format. Send CSV files to vendors FTP sites using SSIS packages. Created and maintained SSIS package with dynamic natature by using SQL server tables. Maintaining and monitoring automated SQL agent jobs.
• Created and maintainted IPED crystal reprots. Created data visualization and data filter for various reports for quick information finding.
• Created SSAS cubs using MS Analysis services multidimensional mode as well as Tabular mode.
• Used TFS for version control in Visual studio. Use Git workflow and created Git branches.
• Designed and implemented ETL processes for Leads and call dispositions.

Confidential, Chicago, IL

Sr. BI Developer/IMPACT Developer

Responsibilities:

• Worked with ITS IMPACT (Instructional Management Program and Academic Communications Tool) department for Student information systems.
• Prior to above project, worked with data analytic team and data movement teams.
• Performs analysis on various students’ huge data sets. Created complex queries, stored procedures, views and tigers and reports using Crystal reports tool. Also produces ad-hoc reports up on request from various CPS internal departments and external vendors. Created complex health student report for Chicago health department with 150 columns and used SSIS package to transfer that data into Excel.
• Designed and developed various new subject areas ODS, such as school principals, elementary schedules, teacher certification.
• Did nightly supported for UC4 (Appworks) scheduling jobs. Analyzed and to corrective active for rejected records in ETL processing. Coordinated with various internal department for day to reporting and ETL processing procedures. Trained new employees and took KT sections on student health reports. Created and maintained special education students reports for services in crystal reports.
• Developed text messaging app to deliver messages to parents cell phones using grade book database. Saved a lot of school districts dollar amount by this application. Created SSIS package to create SPED student and personnel reports for ISBE.
• Analysis, design, developing, implementation and maintaining SIM, SSM web sites.
• Developed tool to transfer data from DB2 to Oracle in C#. Involved in developing system for HR department. Developed web base systems are Position inquiry system, LOA system and NRT system and grants. Involved in maintaining, enhancing many web sites (EQS-NCLB, CMSI, SES etc.). Developed grants internet web site for grants department (confidential). Involved in the PeopleSoft RFP process.
• Took a lead for students and staff projects and completed successfully. Created various reports for Special Education department, worked on ISBE special education reports, REA departments. Improving Operational Data Store (ODS) data quality by modifying data architecture.
• Stored SSIS packages in TFS to control different versions.
• Involved in Incident management system and student Behavior systems.

Environment: Visual Studio .net Enterprises version, Adobe Acrobat, MS project office, Oracle 9i, ASP, ADO.NET, VB.net, C#, TFS, ASP.Net, DB2, MS SQL, Sybase