Laserfiche WebLink
RFP NO. 20-124 <br />(7N'F JI"NI <br />Information Technology As -Needed Professional Services <br />Sun Trust Bank, Atlanta, GA February 2014 — October 2015 <br />SQL Server Developer <br />• Identified technical and functional specifications based on project requirements in JRD <br />meetings. <br />• Performed dimensional modeling with ER -win; designed and built relational data mart. <br />• Constructed T-SQL statements to fetch data from company OLTP and performed <br />various DML operations. <br />• Created triggers on tables to audit DML operations and store transaction details. <br />• Built user -defined function in SQL Server to calculate the complex business formula. <br />• Optimized existing stored procedures by evaluating indexing and partitioning large <br />tables. <br />• Developed and implemented capacity expansions to ensure scalable production <br />databases. <br />• Implemented slowly changing transformations with SSIS to maintain historical data in <br />the data mart <br />• Created SSIS packages to pull out the data from different sources and uploaded it to <br />SQL Server Database. <br />• Designed SSIS packages utilizing various transformations such as multicast, merge join, <br />lookup, fuzzy lookup, and fuzzy grouping. <br />• Utilized script task with C4 programming heavily to extend the SSIS functionality. <br />• Collaborated with team members on project updates by checking in and checking out on <br />TFS. <br />Pan-American Life Insurance Group, New Orleans, LA July 2012 — December 2013 <br />Database Developer <br />• Collaborated with the business users for ETL application enhancements with JRD <br />sessions to capture, document the BRD, and transform the relevant /approved BRD into <br />SRS/FRS. <br />• Created the T-SQL script to generate all the tables and relationships based on the <br />finalized ER -Diagram. <br />• Implemented error handling techniques such as try catch blocks, error functions in T- <br />SQL scripts to fine-tune query performance. <br />• Implemented CTE in SQL script to simplify the main SQL query logic helping debug. <br />• Utilized SSIS transformations for data scrubbing and validation checks before loading <br />into the data mart <br />• Debugged SSIS packages with features such as breakpoints, data viewers, and <br />checkpoints. <br />• Mapped documents and developed logic for data migrations, data imports, initial loads, <br />and incremental loads. <br />Infojini Inc. Response � 41 <br />Microsoft'� r ,�, �� rr <br />10)w b r le r <br />