SUMMARY:

• Extensive experience in all phases of database management system design, development and maintenance.
• Experience in designing and maintaining relational database.
• Strong MS SQL development skills, T - SQL coding and marketing data analyzing skills.
• Experience in creating different kind of reports and be able to write complex queries.
• Excellent problem solving skills. Good logic and strategic thinking.
• Solid background in mathematics and science.
• Easy going yet a hard worker able to work independently as well as a team member.

TECHNICAL SKILLS:

• MS SQL Server (2008/2012/2014 )
• T-SQL, DTS/SSIS
• SSRS, SSAS
• Salesforce, Boomi
• DBAmp, MYSQL
• C#, Visual Basic
• .Net, ASP.net, MS Access
• MS Excel, Visual Foxpro
• VBA, XML, HTML

PROFESSIONAL EXPERIENCE:

Senior SQL Server Developer

Confidential, Ewing, NJ

Responsibilities:

• Collect data and produce, troubleshoot and distribute routine reports regarding project operationson a daily, weekly, monthly, quarterly, semi-annual, and annual basis on an aggressive, deadline-orientedschedule.
• Deliver ad hoc reports, as per business needs.
• Translate stakeholders’ requirements into reporting deliverables.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.Maintain a general understanding of the various databases, systems, programs, policies, business processes, resource constraints and contractual requirements to facilitate appropriate data gathering, reporting and data interpretation. Monitors changes to determine their impact on data gathering, reporting and analysis.
• Collaborate with Risk Management and Audit departments on quality related tasks such as policy or procedure analysis and redesign, audits, benchmarking and performance standard setting, etc.
• Assist end-users to clearly define reporting needs, identify key performance measures, set benchmarks and design and develop measurement tools and reports. Communicate to ensure thatmeasurement tools, reports and data are understood accurately and consistently across work groups.
• Serve as a primary subject matter expert and custodian of certain project wide data. Participate inthe development; documentation and performance of procedures related to maintenance, clean up,consolidation of this information.
• Created and deployed Web-based application using Access for proposal management system, tracking win/loss of submissions, debriefing notes, and client data.
• Develop uniform reporting standards, processes, and documentation to schedule, prioritize, deliverand quality.
• Identify and address expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions.
• Keep abreast of developments within the broad area of IT and look for opportunities to apply themto the company/department goals.
• Perform other duties as assigned by management.

Environment: MS SQL Server 2016,MS Access, VBA,SQL Server Integration Services SQL Server Reporting Services,BusinessIntelligence Development Studio (BIDS),,T-SQL,Power BI.

Senior SQL Server DBA/Developer

Confidential, Moorestown, NJ

Responsibilities:

• Working on Database Load Performance, Database Mirroring for environments which includes data for more than 2 set of environments of 1 TB.
• Worked on setting up campaigns using Adobe Campaign.
• Created workflows and setup automations for the Campaign.
• Translated Business Requirements into workingLogical and Physical Data Models.
• Developed the Logical and physical data model and designed the data flow from source systems toTeradata tablesand then to the Target system.
• Designed the technical specifications document forTeradata ETLprocessing of data into master data ware house and strategized the integration test plan and implementation.
• Developed complex Multi load and Fast Load scripts for loading data intoTeradatatables from legacy systems.
• Used advanced data modeling concepts such asFamily of Stars, Confirmed Dimensions, and Bus Matrixin order to handle complex situations.
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for insurance applications
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design
• DevelopedData Mapping, Data Governance, TransformationandCleansingrules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Assisted with automation ofdepartment’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Prepared visible columns and formulas; imported data from SAP and exported data for metrics.
• Designed, created, and maintained DB2 database objects
• Managed database growth and performance with database reorgs
• Audited application SQL code with DB2 Explain prior to production implementation
• Assisted developers in database and application tuning for optimal performance
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Environment: MS SQL Server /2008 R2, SQL Server Integration Services (SSIS 2014/2012/2008 ), SQL Server Reporting Services (SSRS 2014/2012/2008 ),BusinessIntelligence Development Studio (BIDS), MS Excel 2003/2007,T-SQL,Power BI.

Senior SQL Server DBA/Developer

Confidential, New York NY

Responsibilities:

• Overseeing multiple instances of MS SQL 2005/2008 servers and their corresponding databases; Taking care of company’s data warehouse, including designing, implementing and maintaining Data warehouse for use in a Business Intelligence solution
• Advanced database administration and development including stored procedures, functions and SSIS packages and cube.
• Optimization and tuning of existing T-SQL stored procedures; Enforcing database policies and procedures regarding backup, restore, disaster recovery; Troubleshoot database and data loading issues.
• Loading data from different sources.
• Creating and deploying SSRS reports and Excel reports.

SQL Server DBA/Developer

Confidential, New York, NY

Responsibilities:

• Responsible for overseeing multiple instances of MS SQL 2005/2008 servers and their corresponding databases; Enforcing database policies and procedures regarding backup, disaster recovery, version updates, security monitoring and all other related policies; Resolving SQL Server performance issues. Designing and developing backup plan and disaster recovery strategies.
• Designing and creating database including all indexes; Creating SQL stored procedures and functions to processing data; Designing and developing SSIS/ETL packages for loading or processing data.
• Creating reports and running routine and ad hoc reports in SSRS.
• Creating Boomi package to transfer data from MS SQL Server to Salesforce and creating SQL Server Stored Procedures to processing and backup Salesforce data via DBAmp.

SQL Server Developer/Data Analyst

Confidential, Long Island City, NY

Responsibilities:

• Designing and maintaining relational database.
• Creating SQL stored procedures and functions, coding and debugging.
• Writing complicated queries.
• Creating reports
• Data analysis.
• Writing Excel’s macro to format reports

Environment: MS SQL Server 2000/2005, T-SQL, DTS/SSIS, SSRS, Visual Basic.Net, Access, Excel, XML, VBA...